Hello,

I have a C# app that creates local cubes using PTS. It works fine as long
as the relational source (an MSDE instance) referenced in the create cube
command isn't behind an XP firewall. I've tried making firewall exceptions
for all the ports recommended by this KB article

http://support.microsoft.com/default...b;en-us;841549

(meaning 2725, 2393, 2394, 135, 137, 138, 139, 445) but it doesn't seem to
make any difference. I always get the following:

Cannot connect to the data source '[Microsoft][ODBC SQL Server
Driver][DBNETLIB]ConnectionOpen
(Connect()).;01000;[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server
does not exist or access denied.;08001'.

I can only get it to work if I turn the firewall off. Does anyone have an
idea how to configure the firewall to get this working?

Helpful ideas or suggestions greatly appreciated!

Keith

uh i think that you just have to open up 1433, the sql server port..
right?

If the MSDE data source is behind the firewall it is the SQL ports you
will need to open, not the AS ones.

Try opening port 1433 (and you can probably close the others)

HTH

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <eIZH7nwvFHA.464 (AT) TK2MSFTNGP15 (DOT) phx.gbl>, keith (AT) alh (DOT) com says...

I thought of this today (it really was a 'duh!' sort of moment) but it
doesn't seem to make any difference, either with the Analysis Services ports
open or not. I'm trying to make sense of the firewall log, but it looks
like PTS is using a range of TCP ports (I haven't opened any UDP ports...do
I need to?) and I don't see a way to open a range of ports in the firewall.

Any other suggestions?

"Darren Gosbell" <xxx (AT) xxx (DOT) com> wrote

OK,

After inspecting the firewall log, I opened port 1434 UDP and now everything
works.

Thanks to everyone who responded!

Keith

"Keith" <keith (AT) alh (DOT) com> wrote