School of Information Studies
Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Procedure

 
IMPORTANT: If you are off-campus you need to connect to the VPN before attempting to connect to SSMS. Instructions can be found here: Configure VPN on Windows (SURA)

 

  1.  Create a new text file on your desktop. It should open in your default text editor, usually Notepad.

2.  Copy and paste the following text exactly as it appears into the new file, replacing the bold text "NETID" with your own SU NetID.

(The file path is dependent on the version of your SSMS installation – you'll need to edit it accordingly)

 

@echo off

runas /netonly /user:ad\NETID "C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe"

 

3.  Within your text editor app, choose File -> Save As. For the location, choose your Desktop or somewhere else that you'll remember.

4.  Under the "Save as type" drop-down, choose "All Files (*.*)"

5.  For the file name, choose a name and give the file a ".bat" extension. Save the file.

6.  Run (double-click) the .bat file that you created and provide your NetID password when prompted.

Note
iconfalse

No characters will appear when typing your password. Just type your password followed by the Enter key.

7.  Enter the following information into the Connect to Server dialog.
Server Type:  Database Engine
Server Name:  DBLAB.ISCHOOL.SYR.EDU
Authentication: Windows Authentication
Click Connect (The Password field will be blank)

Note
iconfalse

The username box will show your local computer user account. This is OK, the app is still running with your SU NetID account.

Image RemovedImage Added