Enterprise Manager problem

When a database is restored Enterprise Manager does not display the users
for the restored database. The account I am signing in with has the correct
rights. I have uninstalled Enterprise Manager and reinstalled with no change
.
I notice that when I reinstall Enterprise Manager it immediately displays my
server connections. Which file holds this information and is this file the
likely culprit? Any ideas for solving the issue?If the dbs were restored from another server, there could be a user/login
mismatch... Users in the db, but no associated login on this server...User
information is stored in each database ( sysusers), and login information is
stored in master.dbo.sysxlogins
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:CC420453-549B-4A58-A75E-FBAA018A1208@.microsoft.com...
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the
> correct
> rights. I have uninstalled Enterprise Manager and reinstalled with no
> change.
> I notice that when I reinstall Enterprise Manager it immediately displays
> my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?|||Have a look at these, especially the one about mapping logins to users.
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between
Andrew J. Kelly SQL MVP
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:CC420453-549B-4A58-A75E-FBAA018A1208@.microsoft.com...
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the
> correct
> rights. I have uninstalled Enterprise Manager and reinstalled with no
> change.
> I notice that when I reinstall Enterprise Manager it immediately displays
> my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?|||There are two other DB folks that have access to the server and their EM
installs show all of the users as does the EM install on the server itself.
My install is the only one that does not show the users.
"bassbuster" wrote:

> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the correc
t
> rights. I have uninstalled Enterprise Manager and reinstalled with no chan
ge.
> I notice that when I reinstall Enterprise Manager it immediately displays
my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?|||Apply SP3a.
Ayad
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:BFF0EF1A-F46A-48B1-960E-F3011F007AD3@.microsoft.com...
> There are two other DB folks that have access to the server and their EM
> installs show all of the users as does the EM install on the server
itself.[vbcol=seagreen]
> My install is the only one that does not show the users.
> "bassbuster" wrote:
>
users[vbcol=seagreen]
correct[vbcol=seagreen]
change.[vbcol=seagreen]
displays my[vbcol=seagreen]
the[vbcol=seagreen]