SQL Server 7.0 Login issue

From: Clement (clement@clementlau.com)
Date: 11/27/02 

From: "Clement" <clement@clementlau.com>
Date: Wed, 27 Nov 2002 09:10:07 -0800

Dear all,

I have a database with the 2 following login
dbo_production and
sa

both login associated with user property dbo.

Unforunately due to a server problem the server needed to
be reformatted and therefore SQL Server had been reinstall
again. After the reinstall, the database was restored
back to the server with its lastest backup status. Then
problem arise.

After the restore, the only login remain in my database is
sa. So obviously I try to create a new login called
dbo_producition again, but when I try to attached this
login to user property dbo..it fails, because there are
already objects in the database belong to that user.

Does someone know who to get around this problem?

thx

Relevant Pages

  • Re: Install MSDE w/ MSDE Depl.Toolkit. What permissions when using Win Auth?
    ... I created a login using Enterprise Manager on SQL Server on my server. ... Database Access tab I ticked the tick box for the database that I ... Now when my user installed the MSDE database on his machine locally, ...
    (microsoft.public.sqlserver.msde)
  • Re: Installation OK, but cant connect
    ... > created an access database. ... SQL Server authentication is "client" independent.... ... connections or SQL Server authenticated connections... ... which authenticate user's login at the windows login step... ...
    (microsoft.public.sqlserver.msde)
  • Re: Setting up Linked server to MsAccess
    ... At the server level I have added my windows user group ... At the database level I have added my Server login ...
    (microsoft.public.sqlserver.security)
  • Re: SQL2005: Cannot connect error 11001
    ... user mapped to one database. ... Does the issue has to do with the login account / user ... Server connection. ... if you changed the port ...
    (microsoft.public.sqlserver.connect)
  • Re: Sql Server Login
    ... > When i'm using Server Explorer, I have a small red x next to all the ... > Which is better for creating the database on one computer and then ... login credential you need to, you have to set the SQL Server/MSDE instance ... SQL Server uses a so called "2 phase" authentication policy: ...
    (microsoft.public.sqlserver.msde)