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 |
|
meef
Posting Yak Master
113 Posts |
 Posted - 2010-12-01 : 13:11:46
|
| I'm trying to run a report but when I deploy it, I get this message:An error has occurred during report processing.Cannot impersonate user for data source 'TBLBL'.Logon failed.For more information about this error navigate to the report server on the local server machine, or enable remote errors I can run it fine in the Visual Studio reporting program, but that's it. How can I fix this? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-12-01 : 13:39:37
|
| what are properties you set for data sources in report manager of report server?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
meef
Posting Yak Master
113 Posts |
Posted - 2010-12-01 : 13:48:49
|
| Which properties do you need? I have it set to "Use SQL Server Authentication", if I try Windows Authentication it gives me an error saying it can't log in. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-12-01 : 13:57:37
|
| why? isnt server containing report server not configured for windows authentication?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
meef
Posting Yak Master
113 Posts |
Posted - 2010-12-01 : 14:15:42
|
| I don't know, the other reports seem to run fine with Windows Auth, but this one doesn't. I did change the server where the database lies because we did some switching around, but I can pull data and test the connection fine. I'll try Windows Auth again and edit this with the exact error.EDIT: Actually, I can't test the connection when I enable Windows Auth. It tells me the login is from an untrusted domain and can't be used with Windows auth. |
|
|
|
|
|
|
Cannot impersonate user