can't see users

HI:
I can't see the users of a specific database from other
workstations, although they appear fine in the SQL server.
This database is retored by using a backup file created
from another SQL server. Both are the SQL Server 2000 on
Windows 2000 Server boxes. When I tried to add on some of
the users to the db, it told me that the user is already
existing in the db.
Thank you for your help
Frankrun sp_change_users_login system stored procedure
with "update_one" or "auto_fix" option for those users.
- Vishal
>--Original Message--
>HI:
>I can't see the users of a specific database from other
>workstations, although they appear fine in the SQL server.
>This database is retored by using a backup file created
>from another SQL server. Both are the SQL Server 2000 on
>Windows 2000 Server boxes. When I tried to add on some of
>the users to the db, it told me that the user is already
>existing in the db.
>Thank you for your help
>
>Frank
>.
>|||Not sure what you meant by you can't see the users from other workstations.
But if this is a case of mismatched SID's, check out sp_change_users_login
in the BOL.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"frankie" <frank.su@.harlandfs.com> wrote in message
news:0b1d01c383bc$f16208d0$a401280a@.phx.gbl...
> HI:
> I can't see the users of a specific database from other
> workstations, although they appear fine in the SQL server.
> This database is retored by using a backup file created
> from another SQL server. Both are the SQL Server 2000 on
> Windows 2000 Server boxes. When I tried to add on some of
> the users to the db, it told me that the user is already
> existing in the db.
> Thank you for your help
>
> Frank|||You need to sync the users to the logins. See sp_change_users_login in Books Online and the a tool
to do this at www.dbmaint.com (free utilities).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"frankie" <frank.su@.harlandfs.com> wrote in message news:0b1d01c383bc$f16208d0$a401280a@.phx.gbl...
> HI:
> I can't see the users of a specific database from other
> workstations, although they appear fine in the SQL server.
> This database is retored by using a backup file created
> from another SQL server. Both are the SQL Server 2000 on
> Windows 2000 Server boxes. When I tried to add on some of
> the users to the db, it told me that the user is already
> existing in the db.
> Thank you for your help
>
> Frank|||>--Original Message--
>HI:
>I can't see the users of a specific database from other
>workstations, although they appear fine in the SQL server.
>This database is retored by using a backup file created
>from another SQL server. Both are the SQL Server 2000 on
>Windows 2000 Server boxes. When I tried to add on some of
>the users to the db, it told me that the user is already
>existing in the db.
>Thank you for your help
>
>Frank
>.
>|||I assume below is a re-post and my answer was lost:
You need to sync the users to the logins. See sp_change_users_login in Books Online and the a tool
to do this at www.dbmaint.com (free utilities).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Frankie" <frank.su@.harlandfs.com> wrote in message news:055201c3844d$156848d0$a101280a@.phx.gbl...
> >--Original Message--
> >HI:
> >
> >I can't see the users of a specific database from other
> >workstations, although they appear fine in the SQL server.
> >
> >This database is retored by using a backup file created
> >from another SQL server. Both are the SQL Server 2000 on
> >Windows 2000 Server boxes. When I tried to add on some of
> >the users to the db, it told me that the user is already
> >existing in the db.
> >
> >Thank you for your help
> >
> >
> >Frank
> >.
> >