Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 changin authentication modes

Author  Topic 

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2002-12-02 : 07:31:28
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

12543 Posts

Posted - 2002-12-02 : 07:37:04
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
   

- Advertisement -