Cannot create a file through a file share subscription

Hi
I am trying to create a file share subscription for a report. I have
specified a valid unc path for the file.
When the schedule is run ny SQL Agent, it returns the following error:
"Failure writing file Depth Distribution : The Report Server has encountered
a configuration error; more details in the log files"
When I look at the log file, there is no error indicated. It just says the
following:
w3wp!subscription!1ec4!05/04/2005-15:26:58:: Subscription Created for report
/TRACKERS Templates/Dist Tracker Template/Depth Distribution at
2005-05-04T15:26:58 by NSchneider
w3wp!library!1358!05/04/2005-15:26:59:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1358!05/04/2005-15:26:59:: i INFO: Call to GetSystemPermissions
w3wp!library!1ec4!05/04/2005-15:27:02:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1ec4!05/04/2005-15:27:02:: i INFO: Call to GetSystemPermissions
w3wp!library!1358!05/04/2005-15:27:02:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1358!05/04/2005-15:27:02:: i INFO: Call to GetSystemPermissions
w3wp!library!1358!05/04/2005-15:27:03:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1358!05/04/2005-15:27:03:: i INFO: Call to GetSystemPermissions
w3wp!library!1358!05/04/2005-15:27:04:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1358!05/04/2005-15:27:04:: i INFO: Call to GetSystemPermissions
w3wp!library!1358!05/04/2005-15:27:05:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1358!05/04/2005-15:27:05:: i INFO: Call to GetSystemPermissions
w3wp!library!1358!05/04/2005-15:27:05:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1358!05/04/2005-15:27:05:: i INFO: Call to GetSystemPermissions
w3wp!library!1358!05/04/2005-15:27:06:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1358!05/04/2005-15:27:06:: i INFO: Call to GetSystemPermissions
w3wp!library!1358!05/04/2005-15:27:09:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1358!05/04/2005-15:27:09:: i INFO: Call to GetSystemPermissions
w3wp!library!1ec4!05/04/2005-15:27:09:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1ec4!05/04/2005-15:27:09:: i INFO: Call to GetSystemPermissions
w3wp!library!1358!05/04/2005-15:27:10:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1358!05/04/2005-15:27:10:: i INFO: Call to GetSystemPermissions
w3wp!library!1ec4!05/04/2005-15:27:10:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1ec4!05/04/2005-15:27:10:: i INFO: Call to GetSystemPermissions
w3wp!library!1ec4!05/04/2005-15:27:11:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1ec4!05/04/2005-15:27:11:: i INFO: Call to GetSystemPermissions
Does anyone know what is going on here?
Thanking you in advanceHi,
This could be a permission issue. Make sure the account executed the
subscription is in local user account and has access permission to the share
path.
Charles
"PORRASTAR" wrote:
> Hi
> I am trying to create a file share subscription for a report. I have
> specified a valid unc path for the file.
> When the schedule is run ny SQL Agent, it returns the following error:
> "Failure writing file Depth Distribution : The Report Server has encountered
> a configuration error; more details in the log files"
> When I look at the log file, there is no error indicated. It just says the
> following:
> w3wp!subscription!1ec4!05/04/2005-15:26:58:: Subscription Created for report
> /TRACKERS Templates/Dist Tracker Template/Depth Distribution at
> 2005-05-04T15:26:58 by NSchneider
> w3wp!library!1358!05/04/2005-15:26:59:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1358!05/04/2005-15:26:59:: i INFO: Call to GetSystemPermissions
> w3wp!library!1ec4!05/04/2005-15:27:02:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1ec4!05/04/2005-15:27:02:: i INFO: Call to GetSystemPermissions
> w3wp!library!1358!05/04/2005-15:27:02:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1358!05/04/2005-15:27:02:: i INFO: Call to GetSystemPermissions
> w3wp!library!1358!05/04/2005-15:27:03:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1358!05/04/2005-15:27:03:: i INFO: Call to GetSystemPermissions
> w3wp!library!1358!05/04/2005-15:27:04:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1358!05/04/2005-15:27:04:: i INFO: Call to GetSystemPermissions
> w3wp!library!1358!05/04/2005-15:27:05:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1358!05/04/2005-15:27:05:: i INFO: Call to GetSystemPermissions
> w3wp!library!1358!05/04/2005-15:27:05:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1358!05/04/2005-15:27:05:: i INFO: Call to GetSystemPermissions
> w3wp!library!1358!05/04/2005-15:27:06:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1358!05/04/2005-15:27:06:: i INFO: Call to GetSystemPermissions
> w3wp!library!1358!05/04/2005-15:27:09:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1358!05/04/2005-15:27:09:: i INFO: Call to GetSystemPermissions
> w3wp!library!1ec4!05/04/2005-15:27:09:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1ec4!05/04/2005-15:27:09:: i INFO: Call to GetSystemPermissions
> w3wp!library!1358!05/04/2005-15:27:10:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1358!05/04/2005-15:27:10:: i INFO: Call to GetSystemPermissions
> w3wp!library!1ec4!05/04/2005-15:27:10:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1ec4!05/04/2005-15:27:10:: i INFO: Call to GetSystemPermissions
> w3wp!library!1ec4!05/04/2005-15:27:11:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1ec4!05/04/2005-15:27:11:: i INFO: Call to GetSystemPermissions
> Does anyone know what is going on here?
> Thanking you in advance
>

Cannot connect with SQLCMD - VIA Provider : The specified module could not be found

I have the full version of SQL Server 2005 on my machine under XP. Installed ok and can connect with management studio, but if I try and connect with Analysis Services or even SQLCMD, I get the error below :

HResult 0x7E, Level 16, State 1
VIA Provider: The specified module could not be found.

Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

I have networking enabled, I've enabled all the protocols (apart from VIA because it doesn't start if you do that), and I have all the services running.

Any ideas what can be up ?

I have now fixed this issue and thought I'd just list what was wrong :

The VIA message was because in desperation to connect I had enabled some VIA connections - I think client side.

I disabled all connection types for both client and server except shared memory and TCP/IP.

Still didn't work - and gave a message that the server refused connection.

I then looked at the server side TCP options and found the port number, using SQLCMD tcp:servername,portnumber I could now connect !!

Finally changed the client side TCP to use this port number and now can connect with SQLCMD and no options.

My main gripe is why didn't it all work as installed and why did I have to go through all this to get it to connect !!!

Cannot connect to Server through Visual Studio .NET and Query Analyzer

Good day. I was able to connect to a database server using SQL Server
Enterprise Manager. The Server name specified on the tree is
JOMARGON(Windows NT). But no server was detected using either Visual
Studio .NET and SQL Server's query analyzer.

I highlighted one database (master) on the SQL Server Enterprise
Manager and chose 'SQL Query Analyzer' under the 'Tools' menu. It
worked. The Title of the Query Analyzer window is

SQL Server Analyzer - [Query- JOMARGON.master.JOMARGON\JM Gonzalez

and below on the status bar, I can see

JOMARGON(8.0) and JOMARGON\JM Gonzalez(52)

But again, I cannot connect manually using Query Analyzer as nothing is
listed in the SQL Server drop-down list

ThanksI am able to connect to the server using query analyzer. All I did was
restart my PC. The server name was JOMARGON.

But the only problem is, I still cannot connect to the server using
Visual Studio .NET's Server Explorer. Please help.

Thanks.|||JM (jomargon@.gmail.com) writes:
> But again, I cannot connect manually using Query Analyzer as nothing is
> listed in the SQL Server drop-down list

Just type in the name of the server.

> But the only problem is, I still cannot connect to the server using
> Visual Studio .NET's Server Explorer. Please help.

So what happens when you specify the server name?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Did that already and still cannot connect. By the way, I'm using
Windows NT Integrated Security. Pleae help.

Cannot connect to Locating Server/Instance Specified Other! Please Help Me.

TITLE: Connect to Server

Cannot connect to sia09-cxdb01\cxdb01.

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

BUTTONS:

OK

Please only post once, someone has replied to you in this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1587072&SiteID=1