June 6, 2007 at 6:49 pm
Hi
Iam migrating sql server 7.0 db to sql server 2005. I took the back up and restored it on sql server 2005 instance and i found there is only one sa login in the sql 7.0 instance . so i tried and create it manually on sql server 2005 after restoring the back up with the same login name I sucessfully created the login but iam unable to connect to the instance using sa login. what i have to do to connect to the instance by the login I have created.
please its very urgent can any body help me out with this
thank you
pavan posani
June 6, 2007 at 7:02 pm
I'm not sure I understood what you are talking about, but if you don't have any valid login to connect to the sql 2005 instance then you may have to create one - hopefully your sql has been installed with "mixed mode" authentication. If yes then connect to the box, create a local windows account and add it to the admin group; you can connect using this because BUILTIN/Admin group has got admin permissions by default in sql instance. Then go ahead and change the sa password and keep the new password safe.
Good luck!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply