Building and deploying works, but not running

问题:

When I try to deploy or build a report, I am able to succesfully. There are no errors.

However, when I try to run it locally, I am getting:

I would be most grateful on advice on where I can start in order to troubleshoot this issue?

I am running SSRS 2008 in Visual Studio 2008 on windows 7, 64 bit.

回答1:

If you use linked server and windows authentication my first guess would be to check if your SQL Server service account is a domain user and if it is - check if it is set up properly in AD.

link: http://blogs.msdn.com/b/sql_protocols/archive/2006/08/10/694657.aspx

But then again, i'm not very good at guessing things :)

回答2:

Are you using the same user login for both? If not check that the user has the access the the data source.

Also it seems the local pc doesn't have the OLE DB driver installed. I got a reverse situation at work where my pc had the driver but the server didn't.

Good luck.

回答3:

Did you try http://forums.asp.net/t/1383105.aspx/1

Seems like some kind of grant is needed for the linked server operation locally that is probably already present in production, I thought this bit was promising:

GRANT ALTER ANY LOGIN TO MachineName\ASPNET
GRANT ALTER ANY LINKED SERVER TO MachineName\ASPNET