Problem with extended procedure

From: Jan Schustr (Schustr_at_discussions.microsoft.com)
Date: 01/28/05 

Date: Fri, 28 Jan 2005 04:45:01 -0800

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

Relevant Pages

  • Re: Problem with extended procedure
    ... Run the query below to verify the login is a sysadmin role member. ... SQL Server MVP ... > i have MS SQL Server 2000 Standard with my own extended procedure. ...
    (microsoft.public.sqlserver.server)
  • Re: sp_OACreate + Sql Server 2005 problem!
    ... I tried to install this fix, but I couldn't reboot the server yet. ... I am having some dificulties with the extended procedure sp_OACreate, ... But, on microsoft SQL Server 2005, this generates an error SOMETIMES. ...
    (microsoft.public.sqlserver.connect)
  • xpsql70 DLL
    ... I dropped the xp_cmdshell extended procedure on my sql7 ... I tried deleting the xpsql70.dll. ... the server. ...
    (microsoft.public.win2000.security)
  • Re: SQL2005: Cannot connect error 11001
    ... The famous Windows Firewall (turned on my Server from which I'm trying to ... Exception Details: System.Data.SqlClient.SqlException: Login failed for user ... Try starting the SQL Server ... if you changed the port ...
    (microsoft.public.sqlserver.connect)
  • Re: error logging on SQL 2008
    ... I was, though, hoping for some more recognizable Reason for that error (state 11, " Token-based server access validation failed with an infrastructure error. ... Suggests that state 11 means "Valid login but server access failure", which doesn't really seem to rhyme with your description. ... How can you login to your SQL Server and use that tool if you can't log into your SQL Server? ... at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) ...
    (microsoft.public.sqlserver.server)