Re: Database Users disappered after restore

From: Linda Bendele (lbendele_at_saleslogix.com)
Date: 08/28/03 

Date: Thu, 28 Aug 2003 09:03:01 -0700

Why wouldn't he create the needed users in the new server
and then update the user with sp_change_users_login ?

>-----Original Message-----
>Hi
>
>Your users are stored in master. More importantly, the
user ID and name is
>the only reference in you database. sp_attach_db and
sp_detach_db do not
>move the master information, and since the same user does
not exist on the
>other machine, the linkage is lost.
>
>On the other server, if you try to add a user to the
database with the same
>name, you will notice that it claims that the user
already exists in the
>database. That is because your user ID does not match the
user name.
>
>It is recommended to remove all users from a database
before an
>attach/detach so that you do not have orphaned users.
>
>----------------------------
>Mike Epprecht
>Epprecht Consulting (PTY) LTD
>Johannesburg, South Africa
>Mobile: +27-82-552-0268
>
>Specialist SQL Server Solutions and Consulting
>
>"Oladimeji Suberu" <ladi.suberu@systemtech-ng.com> wrote
in message
>news:0bdc01c36d6b$4b8bd790$a501280a@phx.gbl...
>> I am trying to restore a database from one machine to
>> another. I 've tried using Backup/Restore and equally
>> using DTS. I equally used attach method of transact
SQL.
>> At the end of any of the operation, the databasers are
>> removed from the database living dbo only.
>>
>> Has anybody experienced this?
>>
>> Please help.
>>
>> Oladimeji Suberu
>>
>
>
>.
>

Relevant Pages

  • Re: Connecting to a remote sbs from a website?
    ... Your solution only works if your web app doesn't need to write data to the database. ... SQL server has always supported SQL authentication which does NOT require an SBS username/password. ... And if you aren't, somebody will find a way to break you, regardless of how well you think you've secured your master database. ...
    (microsoft.public.windows.server.sbs)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: fc3 & mysql clustering
    ... > fault tolerance/redundancy is not just an issue of multiple mysql databases. ... > machine is the slave being tied to the master, ... The real trick is redundant database servers. ... > server goes down the other server takes over it. ...
    (Fedora)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)