Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rdaudt
Starting Member
2 Posts |
 Posted - 2007-04-04 : 15:24:40
|
| Hi everyone.I am getting the message "Cannot create a connection to data source '...'. For more information about this error navigate to the report server on the local server machine, or enable remote errors" when users try to run reports. Information gathered so far:- the users access reports through Report Manager- it is a Sql Server 2005 database- the database and the report server are in the same Windows Server 2003 box; the client (IE) is in a XP desktop- the shared data source for all these reports is configured to make use of Windows Integrated Security- users can browse OK the folders and files in Report Manager; they get the error message when they try to run any of the reports- myself, I am able to run any report; the difference is that I belong to the Domain Admins group- we have verified that if we add the users to Doman Admins group the problem goes away- I have also verified that if I create users in the database the problem also goes awayI am looking for a solution that doesn't require assignment of users to the Domain Admins group and that doesn't require the creation of users at database level.Any clue anyone?I appreciate any insight about it.Thanks in advance.Roque DaudtDatabase Analyst |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-04-04 : 16:59:28
|
| You could setup a specific login that the data source will use, and then enter the username and password under the selection “Credentials stored securely in the report server”, and check the box “Use as Windows credentials when connecting to the data source”. You would also need to grant that login access to the database in the data source. This will probably be simpler and more secure that granting each user access to the database that the report uses.Note: this is from SQL Server 2000; I am not sure if this setup is done exactly the same in SQL Server 2005 Reporting Services.CODO ERGO SUM |
 |
|
|
rdaudt
Starting Member
2 Posts |
Posted - 2007-04-13 : 22:45:59
|
| Hi Michael,This is what I ended up doing. It works just fine.Thanks.Roque |
|
|
|
|
|
|
Cannot create a connection to data source