August 5, 2010 at 6:09 pm
when I try to create a new SQL login on sql server 2008, I am getting an login failure. I installed 2008 on the server and attached sql 2005 database and also moved logins from 2005 to 2008 sql server.
I did upgrade other sql server and it works fine.
the issue is only on the server where I installed not upgrade. Any one know how to fix this issue.
August 5, 2010 at 7:28 pm
What is the error that you are getting when attempting to login?
When you created the logins on the new machine did you use the same SID?
August 6, 2010 at 12:06 am
Actually, Server was set to Windows authentication mode instead of Mixed more. I changed to mixed mode and it's working now.
Thanks for your reply
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply