October 22, 2004 at 8:24 am
We have two SQL Servers. Report Services is installed on one of the servers. I created a report which accesses data on the other SQL Server (the server which does not have report services installed). The report works perfectly from VS.NET and there are no errors when depolying the report to the Report Manager web site. When running the report from Report Manager, I get the following error:
Cannot create a connection to the data source 'Name of our SQL Server Name'. (rsErrorOpeningConnection)
SQL Server does not exist or access denied.
Any ideas would be greatly appreciated. Thanks!
October 22, 2004 at 2:23 pm
Are you using integrated authentication?
If you are we have a similar problem beacuse we are currently running in mixed mode security and not 2003 server native. This mean that delegation is turned off so you can't access the sql server with integrated authentication.
Anyway the long and short of it is try modifying the data source in report manager to connect to the other server using an sql server account.
hth
Dave
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply