March 25, 2013 at 1:01 pm
I have Installed Sql Server 2012 on windows Server 2012 and enabled mixed mode authentication on Installation. I have added few users during the Installation. Now I am unable to login with the username and password that I specified. When I login with Windows Credentials I see "sa" account created and it is the only one with password associated with it. All other usernames that I specified are default to windows credential and no way can I use username and password. What I am doing wrong. I am using the Developer version of SQL Server 2012(SQL Server 11.0.2100)
March 26, 2013 at 4:38 am
Do any of the other windows accounts have sysadmin access? If so simply change the SA password.
March 26, 2013 at 8:17 am
Yes, all the users name added have sysadmin rights. Ok. I will change the password for sa and see. Thanks a lot
March 26, 2013 at 8:20 am
Also I would check your local computer keyboard and language vs the servers keyboard and language.
E.g English British and English American the keys are in different locations eg Shift+2 in the UK is " in the US its @ (I think)
So if your UK and server is US and you have " is it actually an @ etc etc
Might be something that simple, has caught me out a few times.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy