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 |
|
ashy_16in
Starting Member
16 Posts |
 Posted - 2005-08-08 : 11:38:35
|
| I tried viewing a few reports in a project which uses a shared data source. I am able able to view all the reports except one.When I click the Data tab for the report , I get the following error. 'A connection cannot be made to the db. Set and test the connection string. Login failed for user '(null)'. Reason : Not associated with a trusted SQL Server connection.'Any help with this issue would be greatly appreciated. |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-08-09 : 11:45:12
|
| It sounds like that report is not properly set to use the shared data source. When you say you "click the Data tab for the report" are you in the designer (Visual Studio IDE)? If so, select the each dataset and click the ellipses (three dots) button to edit the data set. Verify that it is set to use the right data source.---------------------------EmeraldCityDomains.com |
 |
|
|
walterlee78
Starting Member
4 Posts |
Posted - 2005-08-16 : 15:35:01
|
| this occurs too when I import reports to the project. One quick way to fix it is to delete a data set and recreate it. make sure you copy the sql first.deletecreate new datasetpaste the sqland that should fix the issue |
|
|
|
gcowhsu
Starting Member
38 Posts |
Posted - 2005-08-16 : 18:12:25
|
| You can also reassign the datasource for that dataset and type in the credentials. It really doesn't matter how you access the database here because you will probably change it again when you deploy to the Report Manager. |
|
|
|
|
|
|
Sql Reporting Services - Error clicking Data Tab