I am connected to SQL Server 2000 using SSMS 2008. I have a user (for example, UserName: SQL1 I 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, 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.
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.
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.