Re: Login problem

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

Date: Fri, 29 Apr 2005 21:22:34 -0400

Thank you Jens,

You hit the nail on the head!
I did not notice it, but the database username I was having problems with
does not have a login name, but there is a login with that name, so I
thought everything was OK.
And, sure enough, when I run the sp_change_users_login, the user can log in
to the DB again.
Of course, the acid test of the fix will come when I do the next restore.

I am puzzled how this happened though, I did not set up the DB on the backup
server, but I know it was created initially by restoring a backup from the
live server.
And the user could log in until I did a restore with recent data..

Thank you, made my day!

Ragnar

Relevant Pages

  • Re: Portal Areas or WSS Sites for Libraries?
    ... What's interesting is the discussion of backup / restore function, ... > server setup like the live server. ... No word on if it will do sites, portals, or ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ISV Using SQL Authentication - a login concern
    ... How you login depends on the tool you are using. ... you can backup a database with users in it. ... access to restore a database. ...
    (microsoft.public.sqlserver.security)
  • Re: dbcreator and restore?
    ... I also created a backup after the login was set ... >dbo and that is the backup that i successfully restored. ... >which to restore onto the DEV server, ...
    (microsoft.public.sqlserver.security)
  • After database restore, cannot set a login for access to database
    ... Select the DB that you restore from backup, ... >After restoring a database backup to another server, ... >want to set a login (either Windows or SQL ...
    (microsoft.public.sqlserver.security)
  • new problem - RESTORE
    ... however in my .NET program I am getting an error message about the ... So what I did is create a login id using sp_grantlogin. ... It is in the middle of a restore. ... files in the backup. ...
    (microsoft.public.sqlserver.msde)