TDS || Cannot open database 'SPECTRUM' requested by the login. Login Failed.
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.
By following these steps, you can troubleshoot issues with the TDS software and ensure that your data is backed up safely.
Related Articles
Data Restore || Custom Backup Restore
To restore a custom data backup for a specific client, please follow these steps: Open the Spectrum module, such as Income Tax or TDS. Navigate to the "Tools" Menu → "Database Utility" → "Custom Restore". Select the custom data backup file you wish ...Backup Restore - Through software
If client has taken the data backup through software then regarding data restore please follow the steps below: For Data Restore in Spectrum (Excluding TDS): Open Spectrum Software and navigate to Utility → Database Utility → Backup & Restore ...Spectrum || Backup
In the case, if the user wishes to format his system and henceforth requires to take backup of his software data to avoid the chances of losing the same, following steps can be taken up. A pre- requisite to this process is to close the Software on ...Spectrum || Schedule Backup
Here are clearer step-by-step instructions for setting up daily backups for Spectrum and its modules, excluding TDS, along with configuring backup reminders for TDS: Daily Backup for Spectrum (Excluding TDS): Launch the Spectrum software. Click on ...eXBace || Data back up and Data restore
Whenever the user wants to format the system or change his system to other, there would be requirement to take proper data backup of the software so that the data is not lost. eXBace SAAS: Please note that you cannot take data backup of Exbace SAAS ...