I have a report that connects to a database via a "command" that I wrote. When I connect in the designer it does not need to take a database name as it defaults to master.
In my ASP.NET app, when running it in Development environment takes the following code without issue:
report.SetDatabaseLogon(username, pw, servername, "")
When in the staging environment, the page displays a message:
The report you requested requires further information.
-
192.168.11.111
Server name:
Database name:
User name:
Password:
Use Integrated Security
What can I do to get the staging environment to accept my database logon credentials without specifying a database name?
I am using the following tools:
VS 2008
CR 2008 SP 3
Thank you in advance,