Re: Login problem

From: Ragnar Midtskogen (ragnar_ng_at_newsgroups.com)
Date: 04/29/05

  • Next message: Jens Süßmeyer: "Re: Login problem" 
    Date: Fri, 29 Apr 2005 16:42:51 -0400

    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: Jens Süßmeyer: "Re: Login problem"

    Relevant Pages

    • Re: Backing Up WSS
      ... Backup and Restore Options for Windows SharePoint Services ... ·Use the Microsoft SQL Server 2000 tools to back up the databases. ...
      (microsoft.public.sharepoint.portalserver)
    • Re: stsadm.exe
      ... Yes, Stsadm will create the site for you on restore, and it will maintain all permissions. ... Stsadm only backups up data that is stored in the database, so any changes you make to the IIS server's file system you'll have to back up via some other method. ... only backup. ... For example, your production environment is IIS/WSS on one server, SQL Server on another. ...
      (microsoft.public.sharepoint.windowsservices)
    • Backing Up WSS
      ... Backup and Restore Options for Windows SharePoint Services ... ·Use the Microsoft SQL Server 2000 tools to back up the databases. ...
      (microsoft.public.sharepoint.portalserver)
    • Backing Up WSS
      ... Backup and Restore Options for Windows SharePoint Services ... ·Use the Microsoft SQL Server 2000 tools to back up the databases. ...
      (microsoft.public.sharepoint.portalserver)
    • Re: Backups Best Practices
      ... I use SQLLiteSpeed to backup to a UNC share on a remote file server. ... The UNC host is also the tape host so tape backups and restores happen ... I don't bother with index rebuilds after a restore unless the backup was ... I support the Professional Association for SQL Server ...
      (microsoft.public.sqlserver.server)