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 |
|
fjnlsa11
Starting Member
4 Posts |
 Posted - 2013-05-06 : 15:49:38
|
| I am connected to SQL Server 2000 using SSMS 2008. I have a user (for example, UserName: SQL1I usually login with Windows Authentication. I want to change this to SQL Authentication but it is not accepting my old password in order to do this. I logged in using the SA account to see if I can make the change for user: SQL1 but I can't locate where I can do this. Any ideas? Thanks. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-05-06 : 15:57:38
|
| You don't enter a password when connecting via Windows Authentication |
 |
|
|
fjnlsa11
Starting Member
4 Posts |
Posted - 2013-05-06 : 16:16:37
|
| Russell, thanks for replying. I am not sure if my post was clear enough. I am looking to login as SQL Authentication which does require a password -- (currently I am logging in as Windows Authentication). It looks like it is enabled for mixed mode but I am getting denied when I tried to login. When I login as SA, how can I change the password for another user? Thanks. |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-05-06 : 16:32:28
|
| Mixed mode does not mean that you can login with the same login name in Windows Authentication mode AND in SQL Authentication mode. If you want to login in SQL Authentication mode, create another login, designating it as SQL login when you create it, and supplying a password. |
|
|
|
fjnlsa11
Starting Member
4 Posts |
Posted - 2013-05-06 : 16:37:19
|
| James. For the user: SQL1 can I change this from Windows Authentication to SQL Authentication? Thanks. |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-05-06 : 17:01:26
|
| One way to do this is to drop the login and recreate it. When you do that, you will lose all the privileges you have granted to the user/login; any schemas they own will have to be reassigned etc.Another possibility - and I don't know if SQL 2000 supports it - is to create a new SQL login and associate the database user with this new login. |
|
|
|
fjnlsa11
Starting Member
4 Posts |
Posted - 2013-05-06 : 18:06:37
|
| Thanks for the follow up. I am not sure what schemas the user owns. I don't need to use this for that long. I guess I will just create another user account, at least I know now I can't do what I was looking to do. Thanks again. |
|
|
|
|
|
|
User Authentication