walid_afghani
New Member
I know the solution has to be simple and I'd appreciate some help.Several reports are deployed to the ReportServer. Application runs fine, reports get created just fine from the app in the ReportViewer, but when I programatically create a subscription, the report fails to run. SQL Server Agent is running.Next. Using the Report Manager, I can select a report and View it, but when I create or modify a Standard Subscription, I get an error: "Query execution failed for 'Dataset1'...A network-related or instance specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible...."So thinking that this is related to an external process trying to run SQL Server and that process isn't finding the SQL Server, I did the following: From a Command Prompt, I ran C:>SQLCMD -U Administrator -P password -S ServerName\InstanceIDI got the error,"Named Pipes Provider: Could not open a connection to SQL Server [53]"In reading about the error, it appears that a TCP/IP was attempted, failed and Named Pipes was then attempted. TCP/IP is Enabled and whether Named Pipes is Enabled or Disabled, I get the same error.Next, I found a Data Link Properties utility that also tests the SQL Connection and it too gave me an error,"SQL Server does not exist or access denied."So it's pretty clear that whatever process runs the Subscription, just like these 2 utilities, cannot find my SQL Server.Has anyone experienced this or can anyone point me in a direction.