SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 changin authentication modes		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

harshal_in
Aged Yak Warrior

India
633 Posts
Posted - 12/02/2002 :  07:31:28  Show Profile  Visit harshal_in's Homepage  Send harshal_in a Yahoo! Message  Reply with Quote
hi,
is it possible to change the authentication mode of a user from sql server authentication to windows authentication after a user is created?

thankyou.
harshal

nr
SQLTeam MVY

United Kingdom
12543 Posts
Posted - 12/02/2002 :  07:37:04  Show Profile  Visit nr's Homepage  Reply with Quote
Pretty sure not.
Just add the new entry, map it to the same groups and delete the old.


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.25 seconds. Powered By: Snitz Forums 2000