Solved

Data Source Credentials - Best Practice

Posted on 2008-10-22
2
849 Views
Last Modified: 2012-06-27
Windows 2003 running SQL2005 with Reporting Services 9.00.3282.00SP2Enterprise Edition (64-bit)

Is there a resource which provides definitive best practices or recommendations for configuration of SQL 2005 DataSources?  I have found within the different forums various resolutions people have tried but have not been able to find a best practice scenario.
I have used succesfully within another reporting services environment the DataSource option: "Credentials stored securely in the report server" but is this best practice? Our developers are recommending that i use the windows integrated security.

The problem associated with my question is related to:
Events leading up to the issue:
After transferring a set of reports the data source was set to use "windows integrated security"
The reportingservices service on the reporting services server is set to use local system

Specific error:
Running the report(s) results in the following error:
An error has occurred during report processing. Cannot create a connection to data source 'datasourcename'. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. For more information regarding this error it was recommend to enable remote error
------------------------------------------------------------------------------------------
Microsoft indicates --> this error occurs when credentials are passed across multiple computer connections. If you are using Windows Authentication, and the Kerberos version 5 protocol is not enabled, this error occurs when credentials are passed across more than one computer connection. To work around this error, consider using stored credentials or prompted credentials. For more information about how to work around this issue, see Specifying Credential and Connection Information for Report Data Sources.
-----------------------------------------------------------------------------------------
Other troubleshooting steps I have tried on this:
created a test system dsn:
Microsoft SQL Server ODBC Driver Version 03.86.3959
Running connectivity tests...
Attempting connection
Connection established
Verifying option settings
Disconnecting from server
TESTS COMPLETED SUCCESSFULLY!
---------------------------------------------------
Enabled remote errors for reporting services
0
Comment
Question by:mscitssae
  • 2
2 Comments
 
LVL 38

Accepted Solution

by:
Jim P. earned 500 total points
ID: 22786260
>> The reportingservices service on the reporting
>> services server is set to use local system

It is a Best Practice /security hole that you should not use the the Local System account for any SQL service. It should be a regular domain user account with permissions only to the directories and files that are needed on the server that it is running on.

Change that and windows authentication should work fine.
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 22864389
Glad to be of assistance. May all your day get brighter.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now