All geek questions in one place

Create and deploy jobs, but not launch

When I try to expand or create a report, I can succeed. There are no errors.

However, when I try to run it locally, I get:

enter image description here

I would really appreciate some advice on where I can get started to fix this problem?

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

0
source share
3 answers

If you use authentication with a connected server and windows, I would prefer to check if your SQL Server service account is a domain user, and if so, check if it is configured correctly in AD.

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

But then again, I don’t guess things very well :)

+1
source

Do you use the same login for both? If you do not check whether the user has access to the data source.

It also seems that there is no OLE DB driver installed on the local computer. I got the opposite situation at work, where my computer had a driver, but the server did not.

Good luck.

+1
source

Have you tried http://forums.asp.net/t/1383105.aspx/1

It seems like some kind of grant is needed for a local server operation, which 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
0
source

Source: https://habr.com/ru/post/1433055/

More articles:


All Articles