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

Can't Restore a DB backed up with COPY_ONLY in Mgmt Studio

If I create a backup using the following T-SQL, is there a specific reason that I cannot restore it through Mangement Studio.

BACKUP DATABASE MyDB

TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\MyDB_1.BAK'

WITH FORMAT, COPY_ONLY, NAME = 'Backup of MyDB'

I can still restore it using T-SQL but would like the conveinence of using Managment Studio. Any ideas? Is this a bug or is this by design? If by design, what would be the reason?

Any help is appreciated.

Are there any ideas on this one?|||SQL Server Management Studio does not support copy-only backups, as per BOL notes.

Can't Restore a DB backed up with COPY_ONLY in Mgmt Studio

If I create a backup using the following T-SQL, is there a specific reason that I cannot restore it through Mangement Studio.

BACKUP DATABASE MyDB

TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\MyDB_1.BAK'

WITH FORMAT, COPY_ONLY, NAME = 'Backup of MyDB'

I can still restore it using T-SQL but would like the conveinence of using Managment Studio. Any ideas? Is this a bug or is this by design? If by design, what would be the reason?

Any help is appreciated.

Are there any ideas on this one?|||SQL Server Management Studio does not support copy-only backups, as per BOL notes.

Can't login to specific database with user sa, all others okay

Hi,
I'm hoping someone can shed some light on this. We're using sql
server express edition, and our server has a couple of databases (in
addition to the built in ones). We've been using user sa, with a
password set (non-blank) to access the databases. Suddenly, we can't
access the one of them. Unfortunately, we have no other users
configured with access to it either. Logging in with windows
authentication (as administrator) does not grant us access to the
database either. What can cause this? How can we fix it?
Thanks,
Aerik
What error message are you getting when you try to query the database?
Linchi
"Aerik" wrote:

> Hi,
> I'm hoping someone can shed some light on this. We're using sql
> server express edition, and our server has a couple of databases (in
> addition to the built in ones). We've been using user sa, with a
> password set (non-blank) to access the databases. Suddenly, we can't
> access the one of them. Unfortunately, we have no other users
> configured with access to it either. Logging in with windows
> authentication (as administrator) does not grant us access to the
> database either. What can cause this? How can we fix it?
> Thanks,
> Aerik
>

Can't login to specific database with user sa, all others okay

Hi,
I'm hoping someone can shed some light on this. We're using sql
server express edition, and our server has a couple of databases (in
addition to the built in ones). We've been using user sa, with a
password set (non-blank) to access the databases. Suddenly, we can't
access the one of them. Unfortunately, we have no other users
configured with access to it either. Logging in with windows
authentication (as administrator) does not grant us access to the
database either. What can cause this? How can we fix it?
Thanks,
AerikWhat error message are you getting when you try to query the database?
Linchi
"Aerik" wrote:
> Hi,
> I'm hoping someone can shed some light on this. We're using sql
> server express edition, and our server has a couple of databases (in
> addition to the built in ones). We've been using user sa, with a
> password set (non-blank) to access the databases. Suddenly, we can't
> access the one of them. Unfortunately, we have no other users
> configured with access to it either. Logging in with windows
> authentication (as administrator) does not grant us access to the
> database either. What can cause this? How can we fix it?
> Thanks,
> Aerik
>