dbTalk Databases Forums  

windows authentication

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss windows authentication in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
DD
 
Posts: n/a

Default windows authentication - 07-06-2010 , 05:18 AM






default windows authentication is greyed out, how can i change to be abled to
allow use different windows authentication id to login ?

Reply With Quote
  #2  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: windows authentication - 07-06-2010 , 11:13 AM






DD (DD (AT) discussions (DOT) microsoft.com) writes:
Quote:
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, esquel (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.