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.
| Author |
Topic |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
 Posted - 2008-07-22 : 12:13:44
|
| I have a whole batch of users e.g "USERONE" which currently is SQL Server Logon . I would like to change these to use Windows Authentication .Is there a way to script change the user from SQL Server Logo to Windows Login ?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-22 : 12:38:44
|
| They have to be created by windows admin first and you can grant login. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-22 : 23:14:32
|
| Can't change standard sql login to trusted ones. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-07-23 : 04:53:29
|
| rmiao / sodeep - thanks for the feedback , i ended up scripting the login them from scratch based on the SQL Server Authentication naming conventionJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
changing authentication mode of users