Skip to content
Hallway
0:00 / 0:00

#sqlserver#ssms#windowsauthentication

Connect SSMS to SQL Server using WinAuth

Leigh Waldie (MisterMagoo)

7 subscribers • 1 video on Hallway

YouTube
  • Recommended by 1 person: 1 on Stack Overflow and its sister sites.
  • Presented by Leigh Waldie

Intermediate. Assumes working knowledge.

18K views12 years ago1 recommendation

Databases and dataTools and practiceSQL

Leigh Waldie demonstrates how to connect SQL Server Management Studio using Windows Authentication with different user credentials.

Video demonstrating how easy it is to connect SSMS using WinAuth when the credentials required are not the credentials of the current logged in user.

Why it's here

1 person recommends this

What people say. Recommended as an alternative method to connect to SQL Server with Windows Authentication from a different domain.

Mister Magooon Database Administrators Stack Exchange • Recommends

On “Connect to SQL Server with Windows Authentication in a different domain”

There is another way, which I now use in preference to the runas /netonly method. You can add the credentials to your profile in Windows using the Credential Manager found in the Windows control panel. Open Credential Manager Click "Add A Windows Credential" Populate the "internet or network address" field with the name and port number of the SQL instance you wish to store credentials for. Example: UniServer:1433 (1433 is the default port, you may need a different port, especially if you are connecting to a named instance) Populate the "User Name" (don't forget to include the domain e.g. MYDOMAIN\MYUSER ) Populate the "Password" Click OK If you have the server name, port an…
152View the answer