Building and deploying works, but not running

Question

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:

enter image description here

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.

@SimonWhitehead thank you for your msg. it's set up for windows authentication. i tested the connection and it worked fine — Alex Gordon, Feb 03 '13 at 05:18

score 1 · Answer 1 · answered Feb 04 '13 at 21:35

1

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.

answered Feb 04 '13 at 21:35

glh

4,900
3
23
40

thanks! where do i get the oledb drive and how can i be sure i dont have it? – Alex Gordon Feb 04 '13 at 21:35
It comes with the SQL Server feature pack, check http://www.microsoft.com/en-au/download/details.aspx?id=16978 or http://www.microsoft.com/en-au/download/default.aspx – glh Feb 04 '13 at 21:43
how can i be sure i dont have it? – Alex Gordon Feb 04 '13 at 21:58
Dont know to be honest... check http://stackoverflow.com/questions/113860/how-to-check-if-an-oledb-driver-is-installed-on-the-system – glh Feb 04 '13 at 22:03
MS has this... http://msdn.microsoft.com/en-us/library/windows/desktop/ms721219(v=vs.85).aspx – glh Feb 04 '13 at 22:06
hey! i think i figured out whats wrong. there'a server that has a provider called PervasiveOLEDB.11.0 and connecitng works from there! do you know how i can get this same provider? – Alex Gordon Feb 07 '13 at 23:03
try http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/920a0817-d9b8-4766-b0bf-baa6430acf93/ – glh Feb 08 '13 at 02:05

score 1 · Accepted Answer · answered Feb 05 '13 at 15:00

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 :)

score 0 · Answer 3 · answered Feb 03 '13 at 06:52

0

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

answered Feb 03 '13 at 06:52

J.T. Taylor

4,147
1
23
23

thanks so much. i will try this. can you please tell me what does asp.net have anything to do wiht it? – Alex Gordon Feb 04 '13 at 03:57
Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '\'. Msg 102, Level 15, State 1, Line 2 Incorrect syntax near '\'. – Alex Gordon Feb 04 '13 at 17:25

Building and deploying works, but not running

3 Answers3

Linked