TDS || Cannot open database 'SPECTRUM' requested by the login. Login Failed.

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.
In this case, consider restoring the last data backup → Data Restore
or performing a recovery process for TDS data → TDS Data Recovery Process.

By following these steps, you can troubleshoot issues with the TDS software and ensure that your data is backed up safely.
    • Related Articles

    • 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 ...
    • Schedule Backup > Could not find stored procedure 'Sp_full backup'

      When trying to take backup of TDS using backup reminder shows error - Could not find stored procedure 'Sp_full backup' Solution: To resolve the error when you are trying to take TDS backup using backup reminder pop-up please follow the process ...