Category Archives: MS SQL Server

SQL Activity Monitor – Debug high CPU Usage for SQL Server

START -> All Programs -> Microsoft SQL Server 2008 R2 -> SQL Server Management Studio Connect as normal and right-click on the SQL Server (top left) and go “Activity Monitor”. The Activity Monitor will show the queries been run, the … Continue reading

Posted in MS SQL Server | Tagged , | Leave a comment

Find all MSSQL Instances running, Connect and show Version

The diagram below, shows how you can use SQL Management Studio to connect to all instances of SQLServer running on your computer (as indicated in the Services list) and run a simple query to find out the exact version and … Continue reading

Posted in MS SQL Server | Tagged , , | Leave a comment

Allow Domain Admin to Login to SQLServer & have full Access

For some reason when SQLServer 2008 was installed/setup, admins were not added. Therefore when trying to login via SQL Management Studio, an error was obtained: Login failed for user “username”. (Microsoft SQL Server, Error: 18456) I also didn’t know the … Continue reading

Posted in MS SQL Server | Tagged , , , | Leave a comment

Test MSSQL Server Connection

Method 1 – Command Prompt telnet server 1433 #for named instances: telnet server 1434 Method 2 – ODBC Data Source Control Panel\Administrative Tools\Data Sources (ODBC)  

Posted in MS SQL Server | Tagged , | Leave a comment