Re: sp_change_users_login doesn't work for me

From: Kimberly L. Tripp (Kimberly@nospam.sqlskills.com)
Date: 10/16/02 

From: "Kimberly L. Tripp" <Kimberly@nospam.sqlskills.com>
Date: Tue, 15 Oct 2002 19:11:41 -0700

I might be missing something here but if there's no associated username then
you shouldn't be able to get into the database - unless there's a guest
account... Are you a sysadmin? What's your permission in the db?

Everything in your email sounds good to me! (must be missing
something...more details maybe?)

Thanks,
kt

"Eric" <eric@nomailplease.com> wrote in message
news:30c901c27450$ca133fa0$3aef2ecf@TKMSFTNGXA09...
> I've restored a database to a different instance. I know
> about the sp_change_users_login proc, but my problem is
> different. I have a login, but no associated database
> user. When I run sp_change_users_login Report I get 0
> orphaned users, but I can't log into the database. Anyone
> seen this before?

Relevant Pages

  • Re: eseutil /p will nicht brauche dringend Hilfe!!!
    ... provides information about recovering the database if error -1216 occurs. ... the re-integration of the missing files with the data set. ... you can use an option in Eseutil to override ... the error and proceed with soft recovery despite missing or mismatched ...
    (microsoft.public.de.german.exchange2000.general)
  • RE: Events to "Trap" Incomplete Record Creation?
    ... validation checks and issue a message if anything is missing. ... Joe CluelessUser is adding a new record to a database through a form. ... because of the missing required data. ...
    (microsoft.public.access.formscoding)
  • Re: Convert a2000 back to a97
    ... Your computer is missing some of the DLL's or TLB's that come with Access ... The proper way to fix the References is to open the application in Access ... has the database connection hard-coded to use data access methods specific ... Those simple loads and conversions you mentioned -- could ...
    (microsoft.public.access.conversion)
  • Re: Merge in Word
    ... Peter - that was the problem! ... (here's was missing at certain numbered entries - mine is variable). ... characters" - that sort of thing. ... This has happened when the database is a simple address database in table ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Merge in Word
    ... (here's was missing at certain numbered entries - mine is variable). ... "Peter Jamieson" wrote: ... characters" - that sort of thing. ... work when I didn't use Excel for the database. ...
    (microsoft.public.word.mailmerge.fields)