Post reply

Copy Database/Login Question

  • September 4, 2007 at 6:39 am

    #176540

    I am trying to move a database to a new Server instance.  Its a SQL2000 database, but both server instances are SQL 2005 Server.  The copy seems to work fine but I have trouble connecting to it through the app. 

    The admin server login for the application is mapped to the dbo user account on the database on the original db, but this is lost when I copy it over, so I can no longer login.

    Am I missing something in the copy routine that is causing this? Or does it have to do with the server instance not having the same setup?  I was pretty sure I set them up the same.

    Thanks,

  • September 4, 2007 at 8:40 am

    #731229

    Are you sure its a login problem or is the issue that it cannot find the server? Are you passing the instance name along in the login string?

  • September 4, 2007 at 10:22 am

    #731269

    Yes I went into the app and reset the logon string to the correct instance.  It says the user/password combo is invalid.  when I check the server login, it is there and correct, but it is no longer mapped to the db user.  

     In this app, the app admin server login was mapped to the dbo user account in the database, and I cannot modify that account to map it correctly. And it did not copy over correctly from the original.

    thanks again,

    Taylor

  • September 4, 2007 at 10:34 am

    #731273

    Ah, you probably have orphaned users. the knowledge base article here:  http://support.microsoft.com/kb/314546  has good techniques for transfering logins and fixing orphaned users.

  • September 4, 2007 at 11:10 am

    #731281

    That was it.  Orphaned users.  Using the procedures in the KB, i can now login again.

     

    Thanks so much for the help!

    Taylor Prentice

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply