SQL: 001 : SQL Server does not exist or access denied

SQL: 001 : SQL Server does not exist or access denied

Error Message:

ErrorCode: 61443

Message:

Failed to connect to database 'MainDB_sdx'. (ErrNo:-2147467259
Details:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.)


Cause: The error indicates that SOHODOX is unable to connect to MS SQL Server.

There could be many reasons for this..
  1. This is a known issue in Windows 10 and Windows 2012 Server. Windows stops services that may cause a delay during start up.
  2. SQL may not be configured to the right port
  3. SQL port may not be opened in Windows Firewall.

Solution: Please follows the steps below to resolve the issue.

Step 1: 

This is a known issue in Windows 10 and Windows 2012 Server. Windows stops services that may cause a delay during start up. Hence you will find the SQL service as well ITAZ Server service being stopped automatically. To resolve this you will have to delay the automatic startup of this service. 

To do this...

Start the Run dialog.
In the Open section, type services.msc
Click OK. The Services dialog will launch.
Select the instance of SQL Server service for SOHODOX under the Services window. (If SQL is installed using our DB Engine utility, the instance name would be SDXSQLEXPRESS)
Right click it and select Properties
On the General tab, in the Startup Type drop down choose Automatic (Delayed Start) option.
Click Ok to apply the changes.
Click Start to start the service. 

Make sure to do this for ITAZ SOHODOX Server services as well as the other ITAZ services. Also make sure that the SQL service for SOHODOX and all the ITAZ SOHODOX service are running.

If the issue is still not resolved then proceed to Step 2

Step 2: 

You have to configure SQL Server to use port 7732.

  1. Open SQL Server Configuration Manager from Start > Programs.
  2. Click on ‘SQL Server Network Configuration’ on the left panel and you will see the window expand. Select Protocols for SDXSQLEXPRESS.
  3. On the right panel, select TCP/IP. Ensure it is set to ‘Enabled’. Now, double click on the ‘TCP/IP’. The ‘TCP/IP Properties’ dialog will pop up.
  4. Scroll down and Click on the ‘IP Addresses’ tab. Expand ‘IPAll’ header and set the ‘TCP Port’ to ‘7732’. Click on OK to close the dialog.
  5. On the main window expand SQL Native Client 11.0 Configuration and select ‘Client Protocols’
  6. Double click on the ‘TCP/IP’. The ‘TCP/IP Properties’ dialog will pop up. Make sure, the Default Port is set to ‘7732’. Click on OK to save the changes.
  7. Now, select the ‘SQL Server 2012 Services’ node in the left panel. Select the SQL Server (SDXSQLEXPRESS) option to the right.
  8. Click on the Action > Restart menu option to restart SQL Server

You should now be able to work with Sohodox. If the issue is still not resolved then proceed to Step 3

Step 3: 

Please check if the SQL port is added in Windows Firewall Inbound exception, and that SOHODOX is configured with SQL Server authentication.

  1. Click on Start > Control Panel. In the Control Panel window, you will find Windows Firewall, click on it and a new window will open.
  2. On the right panel, click on Advanced Setting and another window will open labelled – Windows Firewall with Advanced Security.
  3. Select Inbound Rules on left panel. Then, on the left panel, click on New Rule.
  4. A new window called – New Inbound Rule Wizard will open. Ensure the Rule Type is selected as Port and click on Next.
  5. On the next screen, check that TCP is selected. Also, select ‘Specific local ports’ and type in the number – 7732. Click on Next.
  6. On the next screen, ensure that ‘Allow Connections’ is selected and select Next.
  7. The next screen will ask you the type of connect. Make sure ‘Private’ or ‘Domain’ is marked based on how your network security is set up.
  8. The final screen asks for a Name and Description. Both the Name and Description should be Sohodox_SQL_Port.
  9. Click on Finish.

Restart your machine. Now login to SOHODOX everything should work fine.


    • Related Articles

    • Convert your existing SQL Express Sohodox DB to SQL Server Standard/Enterprise Sohodox DB

      Note: The below instructions will only work if… You have an existing installation of SQL Server Standard or Enterprise (if you are unsure, drop an email to support@sohodox.com) You have purchased the SQL Server upgrade module. You have the new ...
    • Restore SOHODOX DBs using SQL Server Management Studio

      To restore the DBs using SQL Server Management Studio follow the steps below: Open 'SQL Server 2014 (or any) Management Studio'. On the 'Connect to Server' window, change 'Authentication' to 'SQL Server Authentication'. Please enter your MS SQL ...
    • Attach MDF and LDF files to SQL Server Management Studio

      If you are using SQL Express Edition, please download the SQL Server Management Studio from the link below...  https://www.microsoft.com/en-in/download/details.aspx?id=42299  Please download the file 'MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe' ...
    • Configure Sohodox to point to an existing SQL Server DB

      To to this... Press the Windows + R button. The Run dialog will be launched. In the Open: textbox, type the following command… "C:\Program Files (x86)\Sohodox Desktop\Sohodox.exe" /reconfiguremssqlmainDB /dbname=MainDB_sdx (Assuming Sohodox is ...
    • Backup SOHODOX DBs using SQL Server Management Studio

      To backup the DBs using SQL Server Management Studio follow the steps below: Open 'SQL Server 2014 (or any) Management Studio'. On the 'Connect to Server' window, change 'Authentication' to 'SQL Server Authentication' Please enter your MS SQL ...