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
            Updated: 09 Mar 2017 07:16 PM
            Help us to make this article better
            0 0