You want to use a different username and password to connect to a SQL Server but the Windows Authentcation Username/Password are greyed out / disabled!
When connecting to a SQL Server using Windows Authentication, there is no way to type in an alternate domain/username through the user interface. It will default to the user that you are currently logged into the computer as.
How to Fix it
To connect using an alternate windows domain name, run the following command line script (alter the path to SSMS.EXE based on your computer’s configuration).
runas /netonly /user:[DOMAIN]\[USERNAME] “C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe”
This will open the tool. You can connect to any SQL Server that the user has access to – however, the domain\username that you typed in will not actually appear in the SQL Credential window. Don’t be confused – this will work, even though it doesn’t appear to.
if you are on vista or above please run this command from an administrator command prompt
Some commands that you can run using Command Prompt might require elevated or administrative privileges. To run these commands, you can use the Run as administrator command:
- Click the Start button
- In the Search box, type command prompt.
- In the list of results, right-click Command Prompt, and then click Run as administrator.
If you are prompted for an administrator password or confirmation, type the password or provide confirmation.