SQL Server does not exist or access denied -- sql server reporting services

Michael W. Krout, MCSE
1/12/2006 10:05:02 AM

When I run reports directly from the SRS they run fine. When I try to access
the reports over the internet then I get this message once in a while. If I
run the same report from the SRS then I can run it again in the browser on
the client. I am running a database server with SQL 2000 SP4 on Windows 2003
Enterprise Server and SRS on a seperate box, Windows 2003 Server. When run
on the development machine it works fine. When I run it from the SRS machine
the reports work. When I run the reports from a client sometimes they come
up with the message above. Go Figure.... Anyway, if anyone can give

Michael W. Krout, MCSE
1/13/2006 6:20:02 AM

Potter,

I have a shared datasource that is using the SA account as the user account.
Now the reports are being used internal only. What is puzzling is that once
I fire the reports from the Report Server directly then fire them from the
browser they work fine. It is when I do not launch the reports locally from
the Report Server that they fail to get a connection. If a report does not
come up right away, I RDP into the Report Server and launch the reports
directly from the server and then try them through the browser and they fire
with no problem. The Security model for SQL is Mixed. The Virtual directory
is set to Integrated Security. The credentials are stored for the database
connections.

This is a little unnerving. You think that you have it fixed and then wham
it shows it's ugly face. Thanks for your help.

Michael W. Krout, MCSE, MCT

[quoted text, click to view]

Potter
1/13/2006 6:51:41 AM

So this only happens sometimes (aka randomly) when requesting the
report for a client machine? It isn't specific to report/user?

Do you know if the access is being denied to your Report Catalog (the
ReportServer db) or denied to the database the report is attempting to
query?

You might want to set of a SQL trace profile and see what security
context is being used when you receive the Access Denied message.

Andy Potter

Bava Mani
3/29/2006 10:05:04 AM

Im facing the same problem of "SQL Server does not exist or access denied".
when i run the report. I have the reportingserver and sql server in seperate
machine.
while installing the report server i hve made it to point to the remote sql
server.

please let me know if you have the solution.

Thanks

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : SQL Server does not exist or access denied