what is wrong in my steps - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

what is wrong in my steps

Author

Topic

nehadpro
Starting Member

2 Posts

Posted - 2007-11-14 : 06:44:21

welcome everybody
i want to publish my sql2005 server through my isa2004
so i do the following steps and i want to know if there is wrong in it or if
there is another step is missing or not?

1-i make editing in router configuration file to natting requests on my real
ip to the external interface of my isa

2-at isa i make sql publishing rule to forword requests to the ip of sql
server
(from:anywhere to: ip of sql server listner:external protocol:microsoft
sql server requests:appear from isa not original client ports:default
ports1433)

3-at sql server i enable allow remote and local connection over tcp only
4-at sql server i enable allow remote desktop
5-at sql server i enable firewall and in exception tab i add remotedesktop
and 1433 port

but still when i try to connect from internet using the studio managment
express tool using the real ip address(tcp:{my real ip address}) and login information of sql still
error occure and no connection opened....
note:scw was installed and i uninstall it

so what is the problem
why sql can't published
also i make at isa another rule to allow remote desktop to my sql server using rdp protocol but when i try to connect using remote connection to sql server it failed but when connect to any other internal server it work succesfully

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2007-11-14 : 15:27:30

Is it enterprise edition