Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-01-04 : 09:50:01
|
| Leon writes "I am trying to connect to a W2K3 Server's 2005 Reporting Server through my laptop's (WXP Pro SP2) SQL Server Management Studio.I turned Port 1433 on in the server's Windows Firewall and was able to connect to the server's database engine from my laptop, but I have to turn Windows Firewall on the server off completely to be able to connect to the Reporting Server.I have tried all the ports listed for SQL Server in the Microsoft documentation (TCP and UDP), but they seem to have no effect.Can anyone tell me which port or ports I need to turn on in the server's firewall so that I can access Reporting Services through my laptop's SSMS?Thanks in advance.LGR" |
|
|
BitShift
Yak Posting Veteran
98 Posts |
Posted - 2007-02-01 : 17:05:42
|
A better option, if possible, would be to run IIS on an additional machine that is open/accessible to the outside. Then on this IIS machine, have an asp.net page request the report from sql and thenstream this report back in the http response to the user.  |
 |
|
|
|
|
|
Windows Firewall Port Needed for Reporting Services 2005