Tag Archives: mssql query

SQL Drill – Excel Add-In for building and running SQL queries

About SQL-Drill Building complex SQL queries for a particular database can take some time and effort. SQL-Drill is a simple Excel Add-in which can connect to a SQL Server or MySQL Database, show all the tables, and allow you to … Continue reading

Posted in mssql, mysql | Tagged | 3 Comments

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