SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
System.Web.Services.Protocols.SoapException:

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
System.Web.Services.Protocols.SoapException:
Author Message
pboor



Joined: 03 Jan 2008
Posts: 19
Country: United States Minor Outlying Islands

Post System.Web.Services.Protocols.SoapException: Reply with quote
I am new to DB Audit. We have set up a few tables for DB Audit and receieve the following error. The server principal "sa" it not able to access the database "our db name" under the current security context. There are Web Services writing/updating/deleting records in to the db that we want to audit. Any help would be appreciated. Thanks...
Thu Jan 03, 2008 11:51 am View user's profile Send private message Send e-mail
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Please provide more details about your environment. Which database system type are you auditing? Is this a SQL Server system? Which version?

Did you setup system-level auditing for monitoring user/system activities or data-change auditing for capturing data changes?

Which DB Audit version are you running?
Thu Jan 03, 2008 11:56 am View user's profile Send private message
pboor



Joined: 03 Jan 2008
Posts: 19
Country: United States Minor Outlying Islands

Post Reply with quote
Thanks for the quick reply. It is SQL Sever 2005(9.00.3054.00 SP2 Enterprise Edition (64-bit), 3.2 of DB Audit, System Level Auditing is disabled.
Thu Jan 03, 2008 12:24 pm View user's profile Send private message Send e-mail
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
From your reply I assume you are doing data-change auditing against SQL Server 2005 database. You should set the TRUSTWORTHY ON flag for the database being audited. Without this flag, the auditing procedures are unable to write to the repository database, and as a result, updates fail and you are getting exceptions in your Web application.

Note that DB Audit version 4 does it automatically whenever you enable the data-change auditing. I highly recommend upgrading to version 4 for this and many other reasons.
Thu Jan 03, 2008 12:33 pm View user's profile Send private message
pboor



Joined: 03 Jan 2008
Posts: 19
Country: United States Minor Outlying Islands

Post Reply with quote
Thank you for your timely responses. We will be setting the flag that you mention and evalute the option of upgrading. I will follow on the success or failure of the trustwothy flag in the 3.21 Environment.
Thu Jan 03, 2008 5:38 pm View user's profile Send private message Send e-mail
pboor



Joined: 03 Jan 2008
Posts: 19
Country: United States Minor Outlying Islands

Post Reply with quote
We still get the same error message on 3.21 version. We are seeing this on two different SQL boxes but have the same configuration.
Fri Jan 04, 2008 2:47 pm View user's profile Send private message Send e-mail
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Please check a few things:

1. The TRUSTWORTHY flag has been set on the audited database.
2. "sa" login has access to the repository database, and "sa" login is mapped to "dbo" user in that database.
3. The repository database has an owner, normally "dbo"
4. You can update audited tables in the SQL Query Analyzer or MS Management Studio. If you get an error, please provide the complete error text.
Fri Jan 04, 2008 2:58 pm View user's profile Send private message
pboor



Joined: 03 Jan 2008
Posts: 19
Country: United States Minor Outlying Islands

Post Reply with quote
Msg 916, Level 14, State 1, Procedure audit_tr_200801091001196740, Line 36
The server principal "sa" is not able to access the database "LW_Auditing" under the current security context.
Wed Jan 09, 2008 12:15 pm View user's profile Send private message Send e-mail
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Is this a response to question #4 from the previous post?

What about #1? Have you set the required flag?
Wed Jan 09, 2008 12:21 pm View user's profile Send private message
pboor



Joined: 03 Jan 2008
Posts: 19
Country: United States Minor Outlying Islands

Post Reply with quote
After recreating another db and rerunning and then dropping the target information and resetting, everything appears to be working. Thanks again on your very timely responses.
Wed Jan 09, 2008 3:17 pm View user's profile Send private message Send e-mail
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Thanks for the status update
Thu Jan 10, 2008 11:00 am 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.