|
Home > Archive > MS SQL Server OLAP > September 2005 > Using PTS only through XP firewall
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Using PTS only through XP firewall
|
|
|
| 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/defaul...kb;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]& #91;DBNETLIB]Connect
ionOpen
(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
| |
| dbahooker@hotmail.com 2005-09-22, 3:23 am |
| uh i think that you just have to open up 1433, the sql server port..
right?
| |
| Darren Gosbell 2005-09-22, 7:23 am |
| 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_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell
In article <eIZH7nwvFHA.464@TK2MSFTNGP15.phx.gbl>, keith@alh.com says...
> 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/defaul...kb;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]& #91;DBNETLIB]Connect
ionOpen
> (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
>
>
>
| |
|
| 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@xxx.com> wrote in message
news:MPG. 1d9d16099fb32f119896
b9@news.microsoft.com...[color=darkred]
> 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_do
t_com>
> Blog: http://www.geekswithblogs.net/darrengosbell
>
> In article <eIZH7nwvFHA.464@TK2MSFTNGP15.phx.gbl>, keith@alh.com says...
| |
|
| OK,
After inspecting the firewall log, I opened port 1434 UDP and now everything
works.
Thanks to everyone who responded!
Keith
"Keith" <keith@alh.com> wrote in message
news:Om%23vNz8vFHA.596@TK2MSFTNGP12.phx.gbl...
>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@xxx.com> wrote in message
> news:MPG. 1d9d16099fb32f119896
b9@news.microsoft.com...
>
>
|
|
|
|
|