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
> >.
> >

Cant see sql express in vwd2005

I've installed vwd2005 and sql express, I'm trying to setup a database connection but the sql server doesnt appear in the drop down list. I've checked that the service is running and that the browser service is running too.

Anyone any ideas?

just type name of you server in the list and it should work

|||

just type name of you server in the list and it should work

Janusz