Login problem after DB restore

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_..._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
>.
>Hi !
I had the same probs earlier with my databses and I followed the following s
teps to correct it may be you find them helpfull in your scenario as well.
1) Go to SQL Enterprise Manager Login through 'sa'.
2)Create Database ABC (The one you want to restore)
3)Go to Security Folder in SQL Server Enterprise Manager Select Logins and t
hen select user a.
4)After Select a(user name) ->Select Properties -> Select Database Access
5)You now see the list of all DB installed. Select abc Database and Check on
db_owner in permission.
6) Restore abc Database from another server provided to you.
7)Go to Query Analyzer Login as sa and select abc Database run the followin
g line as it is .
USE abc
GO
EXEC sp_change_users_login 'Update_One', 'a', 'a'
Go
Regards ,
Jayzee
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...