Re: Login problem

From: Jens Süßmeyer (Jens_at_Remove_this_For_Contacting.sqlserver2005.de)
Date: 04/29/05

  • Next message: Ragnar Midtskogen: "Re: Login problem" 
    Date: Fri, 29 Apr 2005 23:27:13 +0200

    You are stucked in with orphaned users, you should look here:

    http://support.microsoft.com/kb/274188/en-us

    HTH, Jens Suessmeyer. 

    ---
http://www.sqlserver2005.de
---
"Ragnar Midtskogen" <ragnar_ng@newsgroups.com> schrieb im Newsbeitrag 
news:Ow0VLwPTFHA.2768@tk2msftngp13.phx.gbl...
> Thank you Jens,
>
> I fixed the problem by adding a new userid with the appropriate 
> privileges, but I just restored an up to date backup and now the new 
> userid doesn't work.
> This clearly has something to do with the restore, but from my 
> understanding of SQL Server it should not happen, since the userids and 
> the security data is stored in the Master database.
>
> This time I was able to delete and add back the userid, so I am back in 
> business, but I need to find out why this is happening so I can prevent 
> it.
> We will be doing regular restores in order to keep the backup server ready 
> to take over if the live machine fails.
>
> I guess I could run a script to delete and add back the user after every 
> restore, but I would rather avoid that.
>
> Ragnar
>
>
  • Next message: Ragnar Midtskogen: "Re: Login problem"

    Relevant Pages

    • Re: Login problem
      ... I fixed the problem by adding a new userid with the appropriate privileges, ... This clearly has something to do with the restore, ... of SQL Server it should not happen, since the userids and the security data ... We will be doing regular restores in order to keep the backup server ready ...
      (microsoft.public.sqlserver.security)
    • Re: MSDE SQL 7 nach MSDE 2000?
      ... Sorry, Backup und Restore, die Dateien müssten ... HTH, jens Suessmeyer. ...
      (microsoft.public.de.sqlserver)
    • Re: DB von einem Server auf einen anderen kopieren
      ... Backup and Restore -oder ... Diese beiden haben bei mir bisher immer funktioniert, wobei ein Backup ... HTH, Jens Suessmeyer. ...
      (microsoft.public.de.sqlserver)
    • Re: DB von einem Server auf einen anderen kopieren
      ... herstellt anstatt aus der Restore library solltest Du auch die Restore ... HTH, Jens Suessmeyer. ...
      (microsoft.public.de.sqlserver)
    • Re: MSDE SQL 7 nach MSDE 2000?
      ... Backup and Restore the file should be compatible. ... HTH, jens Suessmeyer. ...
      (microsoft.public.de.sqlserver)