Login problem after DB restore

From: Mary (Mary_Scheffler_at_urscorp.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 10:15:38 -0800

Don, we just went through the same scenario here at my
office. The problem when moving a database from one
server to another, is the SID doesn't match between the
master and user database. Refer to Microsofts Knowledge
Base Articles, 240872, 168001, 298897. We also had a
problem when we changed the IP address and name of the
server. If you need information on this, refer to
http://ambrosoli.com/ambrosoli/how_to_rename_a_sql_server_7
_0.htm

>-----Original Message-----
>SQL 7.0 using SQL/Windows authenication.
>
>A DB backup was restored from one server to another which
>had a new install of SQL 7.0.
>
>Problem:
>In EM/Security, if I try to add the user login 'xxx' with
>access to the restored DB, SQL says the login name
>already exists in the the DB. Yet, it doesn't exist, that
>I can see any where. If I try to access the DB from an
>ODBC connection using the login 'xxx' it denies access.
>I tried droplogin 'xxx', but that didn't help.
>Any ideas?
>Thanks,
>Don
>
>.
>

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Moving a database to another server
    ... onto a server at home. ... The database has a user that has public, db_owner, ... SQL Server login or a Windows login. ...
    (microsoft.public.sqlserver.server)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)