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 |
|
jql
Starting Member
30 Posts |
 Posted - 2011-04-14 : 09:09:29
|
| Hi,i have created a report in BIDS and it works fine. as soon i deploy to report server via share point the report no longer returns any data.i have checked the data sources and they are as they should be.can not work this one out. any help/ideas would be appreciatedThanks |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-04-14 : 09:25:33
|
| Does you data source use Windows Authentication to connect or a specific user account?Hey, it compiles. |
 |
|
|
jql
Starting Member
30 Posts |
Posted - 2011-04-14 : 09:33:02
|
| the data source uses the following connectionCredentials stored securely in the report serverwith a username and password |
|
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-04-15 : 08:48:25
|
| Does that username have an account on the SQL Server and access to the database?Hey, it compiles. |
|
|
|
|
|
|
bizare report problem