Articles in this category Allow both Windows and SQL authentication in SQL Server Q: How do I set SQL Server to allow both Windows and SQL authentication? A: Follow these steps: Open SQL Management Studio. In the tree at the left, Right-Click on the server name. Select Properties in the pop... (1021) SQL Server Driver Download Q: I am getting the error "Server does not exist or access denied" when I try to connect to the database. A: This could be caused by a number of iss (619) SQL Authentication Q: Can we connect the Client interface using SQL authentication?A: Yes, you may use SQL authentication; however, if you do, you will need to add both the Windows user and the SQL user as users within ... (641) Connect to a Live and a Test Database Q: How can I connect my user interface to both the test database and the live database? A: To allow a user to connect to two separate back-end databases, you need to set up two separate ODBC connections and the... (740) Backup SQL Database and Send Q: How do I send a backup copy of my SQL database? A: To send us a backup copy of your database, you will need access to your SQL Management Studio. Please follow these steps:Make a backup of your database1. Op... (841) Restore SQL Database from Backup Q: How do I restore my SQL database from a .bak file? A: To restore a SQL Server database from a back-up, please follow these steps: 1. Open SQL Server Management Studio (843) Create a Test Copy Q: I would like to set up a test copy of TRAIN TRACK®. How do I do this? Your license allows you to have a production copy, a test copy, an (910) Move database to a new server Q: How do I move my database to a new server? A: A quick guide to moving your database to a new server. More comprehensive installation instructions are included with your purchase. Install and configure SQL o... (2144) Run a Script and Update Tables Q: How do I run a script and update the tables? A: To run the script and update your database, please follow these steps: (1056) HRESULT_FAIL has been returned from a call to a COM component Q: After I generated a database script, when I tried to open it, I got the message: "Error HRESULT_FAIL has been returned from a call to a COM component". What is wrong? A: This error may be displaye... (624) Transaction Log Full Q: I am getting an error message when I try to run a script saying the transaction log is full due to active transactions. A: To resolve this issue, open SQL Server Management Studio (SSMS) and locate your dat... (447)
"