ToolBox -

These instructions will allow you to connect to MS SQL Server using Windows Authentication (your NetID and password). You will not need these steps when connecting from a faculty, staff, or Ph.D. computer owned by the UW as they are domain joined. There are extra steps required if you are connecting from a lab machine.

You might need these instructions if you are taking, teaching, or TAing a course that requires you to connect to a SQL Server and you want to connect from your personal computer.

If you need a copy of SQL Server Management Studio (SSMS) you can get that directly from Microsoft for free.

If you need a copy of Windows and are a current student or faculty member you can download that from Microsoft Imagine. See the Microsoft Development Tools section on our website for more information. If you’re on a Mac or Linux computer, you can install the Windows OS in a Virtual Machine. We recommend Virtual Box, which you can also download for free.

If you are connecting to a SQL Server that is not on the public network, please VPN first.

 

Here are the steps for connecting:

1) In the start menu find SQL Server Management Studio (SSMS). Right click and select “Open File Location”.

 

2) You’ll have a new File Explorer window open and you should see a shortcut to SQL Server Management Studio. Right click on this and select “Send to” then select “Desktop (create shortcut)”.

 

3) On your desktop you should have a new copy of the SSMS shortcut. Right click this and select “Properties”.

4) In the “Target” box prepend the following text (do not delete or change the text that is already there). “runas /netonly /user:netid\your_netid ” where your_netid is your actual netid. Then press the “OK” button.

 

5) The icon of your shortcut will change, this is expected. Now double click your SSMS Desktop shortcut.

6) A command window will open and ask for your password. This is your NetID password. Enter it and press enter.

 

7) You should now have SSMS open with a “Connect to server” window in it. This will show your local credentials, but you can safely ignore that. You will be connecting with the credentials used when creating the shortcut above.

8) Enter the server address you want to connect to (your instructor should have given you this) and press connect.

 

9) You should now be connected to your SQL Server.


If you have any questions after reading this article or if you need any help, please don't hesitate to contact the iSchool IT Help Desk.

http://ischool.uw.edu/help
(206) 616-3086