can't access SQL Server 2005 Cubes, when Integrity firewall runs

Hi,

i'm not able to access the content of the SQL Server Cubes, when i've running the Checkpoint Integrity firewall on the system. I've to shut down the firewall to see the content of the Cubes. Does any one have idea, what could cause this?

best regards

Alfredo

allow traffic to pass thru port 1433 for sql server clients|||

hi,

thx for your answer, traffic for is port 1433 is open. For testing i allowed also any traffic, but it didn't fix the issue, it only works when Integrty doesn't. I had a similar issue with the Ab Initio application, but this Software Company did fix the issue. I don't know how they exactly fixed it, but it was not a Firewall Policy related issue.

|||

kindly post the error text.

|||

Hi,

there are no error messages, the SQL server 2005 Managemnet Studio application just 'hangs', when the Integrity firewall runs. We've the issue, only when we try to accecss the content of the Cubes container, independent if we use the SQL Server toools or f/e Microsoft Excel to access it.

can't access SQL Server 2005 Cubes, when Integrity firewall runs

Hi,

i'm not able to access the content of the SQL Server Cubes, when i've running the Checkpoint Integrity firewall on the system. I've to shut down the firewall to see the content of the Cubes. Does any one have idea, what could cause this?

best regards

Alfredo

allow traffic to pass thru port 1433 for sql server clients|||

hi,

thx for your answer, traffic for is port 1433 is open. For testing i allowed also any traffic, but it didn't fix the issue, it only works when Integrty doesn't. I had a similar issue with the Ab Initio application, but this Software Company did fix the issue. I don't know how they exactly fixed it, but it was not a Firewall Policy related issue.

|||

kindly post the error text.

|||

Hi,

there are no error messages, the SQL server 2005 Managemnet Studio application just 'hangs', when the Integrity firewall runs. We've the issue, only when we try to accecss the content of the Cubes container, independent if we use the SQL Server toools or f/e Microsoft Excel to access it.

sql

Cannot use TCP of SQL Server Client.

Our IIS Webserver and SQL server 2000 installed into two
machine and separate by a firewall.
Recently, I need to disable name-pipe protocol in our SQL
client of webserver. But the TCP/IP not work, even I
opened the port 1433 of this.
I've a test that I release all port for that and set the
client network setting to use TCP IP only. It still not
work.
Please help.
(P.S: if I added Name-pipe in network config. of client,
it request port 445 & 139 on the firewall. Is it correct
response? I afraid we are under attack)Things to test.
1. Can you make a tcp socket connection to the server inside the firewall?
Test with ISQL.
ISQL -Stcp:ServerNameHere -Uuser -Ppassword -Q"select @.@.version"
If it fails, search on the OS error returned.
Example:
10060 is connection timeout
10061 is the server is not listening on the socket.
11001 host not found
If it works inside the firewall, try the same on the machine outside the
firewall.
Check the firewall logs.
Or make simultaneous network traces on both the client and server when
running the ISQL command above.
Hope this helps.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.