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 Ser...

Question In SQL Server Management Studio, why is there a red arrow pointing down in the icon next to a login? This icon can be found in the Object Explorer. Expand Security , then expand Logins , and note that one or more of the login icons...

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 perform a clean uninstall of Microsoft SQL Server Procedure Steps Important: Modifying the registry could cause irreversible damage to your Windows operating system; be sure to back up the registry before making any changes. Follow...

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 Explor...

 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 a...

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...

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) Bro...

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....