Re: Problem with extended procedure
From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 01/29/05
- Next message: Hassan: "Re: Retoring a backup from another SQL server."
- Previous message: mark baekdal: "RE: Robust database with easy rollback capability..."
- In reply to: Jan Schustr: "Problem with extended procedure"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 29 Jan 2005 10:51:55 -0600
Run the query below to verify the login is a sysadmin role member. Also,
verify that you are connecting to the correct SQL Server instance from your
extended proc. A Profiler trace may help.
SELECT IS_SRVROLEMEMBER ('sysadmin' , 'domain\xxx')
-- Hope this helps. Dan Guzman SQL Server MVP "Jan Schustr" <Jan Schustr@discussions.microsoft.com> wrote in message news:10A5175F-50C8-4C0E-B503-47CD5B08D4C5@microsoft.com... > Hi all, > i have MS SQL Server 2000 Standard with my own extended procedure. I run > extended procedurec, and this procedure make sepparate session and run > stored > procedure (asynchronous). But the extended procedure failed with error: > Server user 'domain\xxx' is not a valid user in database 'db'. > Database 'db' was restore from backup from another server, but user's SID > is > the same as login, there is no orphanes , or somethink like that. (to be > on > the safe said)I drop the user and the login and create new login and user > . > But no change. > User domain\xxx is the local admin, and MS SQL Server and ServerAgent > start > with this account. > > Any suggestion? > > Thanks Honza
- Next message: Hassan: "Re: Retoring a backup from another SQL server."
- Previous message: mark baekdal: "RE: Robust database with easy rollback capability..."
- In reply to: Jan Schustr: "Problem with extended procedure"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
