Tag Archives: connection

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