SQL

Symptom When connecting to SQL Server, whether from the ODBC DSN or another method, you may experience all or part of the following error message: An error has occurred while establishing a connection to the server. When connecting to SQL Serve...

Symptom You may encounter the following issues after restoring a backup of the AccessControl database into an OnGuard system running SQL Server: - When configuring or testing the ODBC DSN, the AccessControl database is not listed in the Change...

 How to restore a database backup to SQL Server  Procedure Steps 1) Install OnGuard, SQL Express, and Microsoft SQL Server  Management Studio. Microsoft SQL Server Management Studio and SQL Express can  be downloaded from Microsoft at:...

How to configure SQL Server 2005 Express if the installation utility was not used. Procedure Steps 1) Click the  Start button, then select All Programs > SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager . ...

Symptom When running Database Backup in SQL Server the following error message appears: "Backup failed for server "XXXXXX". (Microsoft.SqlServer.Express.Smo)" Additional Information: System.Data.SqlClient.SqlError: Cannot Open Backup Device "...

How to modify the server name in SQL Server Procedure Steps NOTE: Please be sure to back up the Master and AccessControl databases before proceeding. To update the name do the following: 1) Open the Microsoft SQL Server Management Tool. ...

How to change the Lenel database password Procedure Steps 1) Click the Start button, then select Programs > Microsoft SQL Server xxxx > SQL Server Management Studio . 2) Log into SQL Server Management Studio. 2) In the Object Explorer...

How to check SQL Server authentication settings Procedure Steps 1) Start Microsoft SQL Server Management Studio. 2) Right-click the server name and select "Properties." 3) Select the Security page. 4) Verify that Server authentication is s...

How to install and configure SQL 2005 Express Procedure Steps To configure SQL Server 2005 Express when the installation utility was not used, complete the following steps: Note: If preferable, uninstall SQL Server 2005 Express and delete...

How to attach a database to SQL Server  Procedure Steps 1) Open Microsoft SQL Server Management Studio.   2) In the left pane, right-click on Databases and select Attach . 3) In the Databases to attach section, click [Add]. 4) Brows...