Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Security

Database Security Question

I am running SQL 2005, SP2

I have two databases (happen to be SMS (dbA) and SMS Client Health (dbB))

I have created a view in dbA that selects records from a table in dbB - view is called v_ClientHealthStatus

The view works great with my credentials

dbA (the SMS db) has SMS Web Reports configured (IIS will run a particular report - which is a sql query). All reports work, except the one that tries to use the view, v_ClientHealthStatus. I get the following error:

An error occurred when the report was run. The details are as follows:

The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "dbB" under the current security context.

Error Number:

-2147467259

Source:

Microsoft OLE DB Provider for SQL Server

Native Error:

916

The NT Authority\System user has been granted public database role and is in the schema db_datareader on both databases. I have even gone so far as to explicitly grant the user Select permissions

I ran profiler and it shows NT AUTHORITY\SYSTEM as the account trying to access the database. I think the permissions are OK - and shouldnt the System account have full access anyway?

Why can it not run the report?

Any help would be appreciated

Thank you

[1839 byte] By [TomGibson] at [2008-1-10]
«« convert a bitmap format rgb 24 or 32 bits to rgb-8-bits
»» Outlook appointment items don't seem to correctly report dates or calculate dates
SQL Server
SQL Server Security

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified