Re: SQL Server Logins do not have database access

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: Membership download
    ... SSIS task does not include the property for ALTER AUTHORIZATION ON SCHEMA. ... How to move databases between computers that are running SQL Server ... With SSIS transfer object task, if your destination server has no logins, ...
    (microsoft.public.sqlserver.dts)
  • Re: object level permissions being lost when migrating
    ... I first transferred the logins from the 2000 server to the 2005 server via ... I then restored the databases and re-synched the users via the ... Errors After Restoring Dump ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server Logins do not have database access
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... created all user logins before restoring the databases. ... A few users are SQL Server logins. ...
    (microsoft.public.sqlserver.security)
  • Re: sql 2008 evaluation edition upgrade
    ... your databases that's why I told you about BACKUP command. ... If you want to transfer your Logins, you can use some scripts or SSIS' s ... restore logins. ...
    (microsoft.public.sqlserver.setup)
  • db_owners unable to see login list
    ... add new users to their databases, despite the fact that logins exist ... for these users on the server. ... look at the logins, the complete list is not presented to them. ... assign them to server-level security roles, ...
    (comp.databases.ms-sqlserver)