Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

windows authentication

0 views
Skip to first unread message

DD

unread,
Jul 6, 2010, 5:18:36 AM7/6/10
to
default windows authentication is greyed out, how can i change to be abled to
allow use different windows authentication id to login ?

Erland Sommarskog

unread,
Jul 6, 2010, 11:13:10 AM7/6/10
to
DD (D...@discussions.microsoft.com) writes:
> default windows authentication is greyed out, how can i change to be
> abled to allow use different windows authentication id to login ?

You can't. The whole point with Windows authentication is that Window
has already authenticated you.

What you can do, though, is to is to use Run As in Windows and start
SSMS this way.


--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

0 new messages