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