?
Solved

Data Source Credentials - Best Practice

Posted on 2008-10-22
2
Medium Priority
?
869 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 38

Accepted Solution

by:
Jim P. earned 2000 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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

770 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