TDS : SQL SERVER Network Configuration

KDK Software products are Multi-user software products that can be used in the Network area. There might be few situations arising due to some network failure or configurations, where some software modules would respond properly and some would not. One such case is explained below with the TDS module where its error, conditions, and solution has been explained.

TDS software not working on LAN / Client or Network system

Some settings that have to be made on the Server / Main system so that there will not be an issue in opening TDS software on LAN.

ON SERVER: 

1. Go to the server system where Spectrum\Taxsuit\TDS (if the user has only TDS) is registered.
   
2. Close the TDS Software.
   
3. Right Click on My Computer/This PC → Manage → Services and Applications → SQL SERVER Configuration manager 
   
4. Go to SQL SERVER Network Configuration → Protocols for KDKSQL8 (Default database Instance used and installed for TDS software) 
   
5. Enable all the protocols 
   

            

1. Similarly Go to SQL Native client 10.0 Configuration 
   
2. Click on Client protocols and enable all the protocols. 
   

            

            

1. Once the above process is done, click on “SQL SERVER Services” 
   
2. Restart the Service for SQL Server (KDKSQL8) (Currently running) 
   

            

Now, run TDS software on the server first and then on the node system. 

On LAN:

If running the TDS on LAN system and the below error described message is encountered follow the process mentioned below

Error Description 1:SQL Server Network Interfaces: Server doesn't support requested protocol [xFFFFFFFF].

            

Click OK,  the Error message would appear on the screen as shown below

            

Please check that the Instance name (KDKSQL8) is the same as that of the Server system along with the password.

NOTE: - SQLCONFIG.lan file (available at default location where the software is installed: - “C:\Program Files (x86) \K.D.K. Software\Spectrum\Zen TDS”) would help the user to check the running instance on the server system.

            

Once the Instance is checked and same as that of the server, Test the connection and save the file.

Now run the software.

Error Description 2: [DBNETLIB][ConnectionOpen(Connect0),]SQL server does not exist or access denied.

            

1. Click on OK for the error. Connect window would appear as shown below. 
   
2. Click on the Driver option and then on the Installed Driver 
   

                        

1. Now always select either the second driver or the third driver in any under Installed Drover option.
   
2. Click on OK and then Test Connection. 
   
3. Once the connection is established successfully, Save the file and then cancel.
   

            

NOTE: - On successful connection the file is to be saved at the location where the software is installed on the LAN system.

Default Location: - “C:\Program Files (x86) \K.D.K. Software\Spectrum\Zen TDS”.

If the same issue arises, please try connecting to the TDS database using the Administrative Tool - Process.

I hope this solution proves helpful.

• Related Articles

• TDS || SQL Server does not exist or access denied

  --------------------------- SQL Server --------------------------- Unable to connect: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the ...

• How to install Microsoft SQL Server 2008 R2 Express Edition with KDK instance for TDS / eXBace (On - Premise) application

  Please follow the steps below to install the Microsoft SQL Server 2008 R2 Express with KDK Instance for TDS application: Open website : MSSQL LINK If it is 64-bit then download "SQLEXPR_x64_ENU.exe" or if it is 32-bit download "SQLEXPR_x86_ENU.exe". ...

• TDS || SQL SERVER Service Start Issue

  When starting SQL Server services, you might encounter the following error: "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details". Root Cause of the Error → This ...

• SQL SERVER || "Could not find the Database Engine startup handle" error while installing SQL Server 2008 R2 SP2 Express Edition

  To rectify the error, follow these steps: Begin by securely backing up the data from the TDS Software to ensure no loss of crucial information. Completely uninstall Microsoft SQL Server, including all its instances and related files. After ...

• SQL SERVER || The Specified credentials that were provided are not valid.

  Root Cause of the error → This issue arises when the "Account Name" is not selected in the "SQL Server Database Engine" row under the "Server Configuration" page. Solution → To resolve this, simply click "OK" on the error message and select the ...