The error message typically occurs when a user attempts to connect to a SQL Server database using a login, and the database does not respond to the application.
To troubleshoot the issue, you can try the following steps:
Step 1: Press Windows + R to open the "Run" dialog, type services.msc, and hit Enter. This will open the Services window.
Step 2: Scroll down and find the service named "SQL Server (KDKSQL8)".
Step 3: Right-click on "SQL Server (KDKSQL8)" and select "Properties".
Step 4: In the Properties window, navigate to the "Path to Executable" field. This will display the location of the SQL Server binaries and the root directory where the SQL Server data and log files are stored.
Step 5: Before copying the data, you need to stop the SQL Server service. In the Services window, right-click on "SQL Server (KDKSQL8)" again and select "Stop".
Step 6: Navigate to the folder location identified in step 4. Copy the entire "Microsoft SQL Server" folder to any of your safe location.
Step 7: Once the folder is copied successfully, you have backed up the TDS data stored in Microsoft SQL Server.
Note: If there are multiple SQL Server instances running, it's crucial to stop all instances before copying the Microsoft SQL Server folder (Find each SQL Server service instance, such as "SQL Server (KDKSQL)", "SQL Server (KDKSQL1)", etc. → Right-click on each SQL Server service instance and select "Stop" to stop the service).
Step 8: After backing up the data, restart the SQL Server service by right-clicking on "SQL Server (KDKSQL8)" in the Services window and selecting "Start".
If the issue persists, there may be a problem with the existing database.
In this case, consider
restoring the last data backup → Data Restore
By following these steps, you can troubleshoot issues with the TDS software and ensure that your data is backed up safely.