Re: SQL Server Logins do not have database access

Also take a look at sp_change_users_login:

http://msdn2.microsoft.com/en-US/library/ms174378.aspx

Thanks

--
Laurentiu Cristofor [MSFT]
Software Design Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/

This posting is provided "AS IS" with no warranties, and confers no rights.

"Brett I. Holcomb" <Brett@xxxxxxxxxxxxxxxxx> wrote in message
news:umvF%23QZaGHA.1020@xxxxxxxxxxxxxxxxxxxxxxx
Check out sp_help_revlogin - it's in the knowledgebase and will help get
the
logins back.

HarlanM wrote:

I uninstalled SQL Server 2000 and reinstalled w/ SP4 because SP4 wouldn't
install correctly on the existing installation. After new installation, I
created all user logins before restoring the databases. I restored the
databases which restored the users in each database with their previous
permissions. Most of the users are domain accounts using windows
authentication. A few users are SQL Server logins. A few of these SQL
Server logins are owners of tables in some databases.
These SQL Server logins in the Security section of Enterprise Manager do
not have access to any of the databases but they are in the user lists in
the databases. I fixed some of them by deleting the user from the
database
and then adding them again. The problem I have is with the users that own
tables. I can't remove the users because they own objects and I can't fix
the database access rights at the security section because they already
exist.

Is there a way to straighten this out?



.

Relevant Pages

  • Re: Server Migration...
    ... The logins are in the master DB and the DTS packages are in msdb. ... Columnist, SQL Server Professional ... database between server including all Systems Databases, ...
    (microsoft.public.sqlserver.server)
  • Re: Moving SQL Objects
    ... Moving SQL Server databases to a new location with Detach/Attach ... Transfer Logins and Passwords Between Instances of SQL Server ... How to Resolve Permission Issues When a Database Is Moved Between SQL ...
    (microsoft.public.sqlserver.server)
  • Re: URGENT (again) :-)
    ... the system databases are special... ... > Using WITH MOVE in a Restore to a New Location with Detach/Attach ... > How To Transfer Logins and Passwords Between SQL Servers ... > Disaster Recovery Articles for SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Moving SQL Server Components
    ... Moving SQL Server databases to a new location with Detach/Attach ... Transfer Logins and Passwords Between Instances of SQL Server ... How to Resolve Permission Issues When a Database Is Moved Between SQL ...
    (microsoft.public.sqlserver.server)
  • Re: Moving SQL objects
    ... Moving SQL Server databases to a new location with Detach/Attach ... Transfer Logins and Passwords Between Instances of SQL Server ... How to Resolve Permission Issues When a Database Is Moved Between SQL ...
    (microsoft.public.sqlserver.server)