SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Error (dbcmd) executing sp_bindsession procedu

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Error (dbcmd) executing sp_bindsession procedu
Author Message
Gabriel



Joined: 15 Mar 2006
Posts: 4

Post Error (dbcmd) executing sp_bindsession procedure. Reply with quote

hi when i try to enable system audit get an error,
and if execute this in the sql server

EXEC sp_db_audit_startup

get this error

Msg 20001, Level 1, State 20001

Error (dbcmd) executing sp_bindsession procedure.


Tue Mar 14, 2006 2:34 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Re: Error (dbcmd) executing sp_bindsession procedu Reply with quote

This indicates problems with the internal db connection. Try connecting to SQL Server using Windows authentication (e.g. the integral security option) rather then SQL authentication). After that enable the system auditing and you should be fine.

: hi when i try to enable system audit get an error,
: and if execute this in the sql server

: EXEC sp_db_audit_startup

: get this error

: Msg 20001, Level 1, State 20001

: Error (dbcmd) executing sp_bindsession procedure.

Wed Mar 15, 2006 12:25 am View user's profile Send private message
Gabriel



Joined: 15 Mar 2006
Posts: 4

Post Re: Error (dbcmd) executing sp_bindsession procedu Reply with quote

i was connecting with Windows authentication and still have this error

: This indicates problems with the internal db connection. Try connecting to
: SQL Server using Windows authentication (e.g. the integral security
: option) rather then SQL authentication). After that enable the system
: auditing and you should be fine.

Wed Mar 15, 2006 12:17 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Re: Error (dbcmd) executing sp_bindsession procedu Reply with quote

Which version and service pack of SQL server are you running? Is that a named instance or the default instance?

: i was connecting with Windows authentication and still have this error

Wed Mar 15, 2006 1:01 pm View user's profile Send private message
Gabriel



Joined: 15 Mar 2006
Posts: 4

Post Re: Error (dbcmd) executing sp_bindsession procedu Reply with quote

Version: Microsoft SQL Server 2000 Enterprise - 8.00.2039(SP4)
is the default instance

: Which version and service pack of SQL server are you running? Is that a named
: instance or the default instance?

Mon Mar 27, 2006 4:22 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Re: Error (dbcmd) executing sp_bindsession procedu Reply with quote

Please verify youhave SQL SErver's BINN directory in the system search path.

: Version: Microsoft SQL Server 2000 Enterprise - 8.00.2039(SP4)
: is the default instance

Tue Mar 28, 2006 10:07 am View user's profile Send private message
Gabriel



Joined: 15 Mar 2006
Posts: 4

Post Re: Error (dbcmd) executing sp_bindsession procedu Reply with quote

yes, the directory figure in the listing

Thu Mar 30, 2006 1:59 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Re: Error (dbcmd) executing sp_bindsession procedu Reply with quote

It appears that the user who is running the audit must be a member of the the public role. Granting public role to the user will solve the problem.

: yes, the directory figure in the listing

Wed Apr 12, 2006 7:04 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.