February 13, 2008 at 9:15 am
I developed a report using BIDS on XP which uses dynamic connection string. I deployed it to a Windows 2003 server. The report uses windows integrated security. The database is on my machine. The report works fine when I view from BIDS but does not when I view from report manager. I enabled remote connections in SQL server 2005 surface area configuration on local SQL Server.The error it throws when viewed from report manager is as follows:
An error has occurred during report processing. Cannot create a connection to data source "Dsxxxxxx".
I did not deploy any datasource to report server as the connection string is dynamic. Please suggest as it is very urgent and also let me know if any additional information is needed. Thanks in advance.
February 13, 2008 at 9:21 am
When you mean dynamic how do you get the server name to add to the connection string. I know the you are using windows credentials and there is no need to send them but what about your server name. It should be the instance name of your sql server and can't be your host server name. remember that there is a difference between host server name and sql server instance name.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 13, 2008 at 9:42 am
Thanks for the prompt reply. Actually, I calling this report from a web application. The user will pass both server and database names. The connection string accepts these two as parameters values from web application.
December 17, 2009 at 8:14 am
Hello,
Were you able to find a solution to this?
I have the exact same situation but the difference being, my report works in preview but when deployed,the dynamic connection string doesn't work.
Here is the link to my post.
http://www.sqlservercentral.com/Forums/Topic835275-150-1.aspx#bm835460
Thanks.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply