We help IT Professionals succeed at work.

User name grayed out in SQL Server 2005 Server Management Studio

Tasburath
Tasburath asked
on
1,401 Views
Last Modified: 2008-01-09
I am running the Microsoft SQL Server Management Studio for SQL 2005 on my local workstation.

When I start it, username is grayed out when choosing windows authentication as the Authentication mode.

Is there a way to select a different user name for authentication?
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
>Is there a way to select a different user name for authentication?
not when using windows authentication. using windows authentication means that your sql server will take your current windows login.

if you want to use a different login, you have to login with a different windows account, or, which might be more useful, use the "RunAs" method to start your management studio with the credentials of another windows account:
http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/runas.mspx?mfr=true

Author

Commented:
Thanks guys
Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.