locked
Microsoft SQL Server Login RRS feed

  • Question

  • I have moved a database from sql server1 to sql server2 for testing.  When trying to login, I get the following message...

     

    Connection Failed:

    SQL State '28000'

    SQL Server Error: 18456

    [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'guestviewer'

     

    Note:  sql server2 exists;  the spelling of guest viewer is correct.

     

    Ideas?

     

    Thanks for your help.

     

    CaprSky

    Monday, December 1, 2008 5:32 PM

Answers

  • I had to recopy the logins over to sql server2.  It worked.

     

    CaptSky

    Monday, December 1, 2008 7:39 PM