Post reply

Unable to connect to sql server using sql account(urgent help needed)

  • June 6, 2007 at 6:49 pm

    #173976

    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

    #711289

    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