Re: Users in database have no associated login
From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 04/14/04
- Next message: Sourabh Moharil: "Re: Counting number of IO Accesses per DB"
- Previous message: Russell White: "Users in database have no associated login"
- In reply to: Russell White: "Users in database have no associated login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 14 Apr 2004 15:08:03 -0400
Do not multi-post. See my answer in .server.
-- Tom --------------------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinnaclepublishing.com/sql "Russell White" <rwhite04@maine.rr.com> wrote in message news:unk3eKlIEHA.3144@TK2MSFTNGP10.phx.gbl... we got sql2000 dump from a customer and we can't run against it because, for some reason, the users in our database don't have associated logins (as seen in sql enterprise mgr >> db >> users >> login name column). In all other databases the users of our database have the sa login associated with them. the users screen in a working db has 3 columns: name (e.g. dbo), Login Name (e.g sa) and Database Access (e.g. Permit). in this same screen in the database we can't upgrade/run against the login name is blank for the dbo user... any way i can reassociate the sa login w/ this user? Thanks in advance, Russ White
- Next message: Sourabh Moharil: "Re: Counting number of IO Accesses per DB"
- Previous message: Russell White: "Users in database have no associated login"
- In reply to: Russell White: "Users in database have no associated login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
