SQL : 004 : Specified SQL server not found

SQL : 004 : Specified SQL server not found

The most likely cause of this issue is that SOHODOX is not able to connect to SQL Server. Please follow the steps below to trouble-shoot the problem...

STEP 1:
Make sure SQL Server is installed and the service is running on the machine
  1. Press the Windows+R key. The Run dialog will be launched.
  2. Type services.msc
  3. Click OK. The 'Services' dialog will be launched.
  4. Scroll to the Service 'SQL Server (InstanceName)'. 
  5. Check if the service is Running.
STEP 2:
If you have recently changed the MachineName or IP of the machine on which SQL Server is installed...
  1. Press the Windows + R button. The Run dialog will be launched.
  2. In the Open: textbox, type the following command…

    "C:\Program Files (x86)\Sohodox Desktop\Sohodox.exe" /reconfiguremaindb

  3. Now a dialog will launch. It will show you the credentials to login to MS SQL Server. Make sure you have entered the correct information. Also make sure you are using SQL credentials to login. 
  4. Click the Test connection button to make sure the connection is successful. 
  5. Now click the Save button to save the settings.
STEP 3:
Testing if the machine is able to connect to SQL Server...
  1. Click on 'Start > Control Panel > Administrative Tools > ODBC Data Sources (64-bit)’. The’ ODBC Data Source Administrator (64-bit)’ window will pop up.
    Note: If you are using a 32 bit operating system, please use  'ODBC Data Sources (32-bit)'.
  2. On the ‘User DSN’ tab, click on the Add button. The ‘Create New Data Source’ window will pop up.
  3. Select the option ‘SQL Server’ from the List displayed and then click on the Finish button. The ‘Create a New Data Source to SQL Server’ window will pop up.
  4. Enter the name, description and SQL Server for the data source. Click on the Next button. (You will need to enter the Server name in the format MachineName\InstanceName ). 
  5. Choose the option ‘SQL Server Authentication using a login ID and password entered by the user’.  
  6. If you are using a custom port instead of the default 1433, you will need to click on the Client Configuration button. 
  7. Uncheck the checkbox 'Dynamically determine port'. Specify the custom port being used. Click OK.
  8. Enter the Login ID and password and click on the Next button.
  9. If you proceed to the next page, it means that you have connected to MS SQL Server. Other wise it should give an error saying ‘Connection Failed’.
If you receive an error connection failed, please write to support@sohodox.com
    • Related Articles

    • 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 ...
    • 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' ...
    • 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 ...
    • 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 ...