Knowledgebase: Dedicated Server
I cannot connect to the SQL instance on my dedicated server.
Posted by Phil (Netcetera) on 07 January 2008 02:14 PM
1) Make sure that the server can telnet to localhost on port 1433 by typing â€œtelnet localhost 1433â€, if you fail connect, check that TCP/IP is enabled. If the firewall is preventing access to the port, follow through the rest below.|
2) RDC to server and Login to netscreen in web browser, go to Objects â€“ Services - Custom
3) Click â€œNewâ€ at the top set Service Name as â€œMSSQLâ€,
4) Click on â€œTCPâ€ on row 1
5) Leave Source Ports as Low 0 High 65535, set Destination Ports to 1433-1433 and click OK at the bottom
6) Go to policies, select Untrust on the left under â€œFromâ€, select Trust on the right under â€œToâ€, click on â€œNewâ€
7) Set the name as something like â€œAllow MSSQLâ€. For Source Address choose â€œANYâ€, for Destination Address choose â€œANYâ€
8) For Service select your new custom object (MSSQL in this example)
9) Set action to Permit and press OK
10) The rule likely appears BELOW the ANY ANY DENY rule. If this is the case the new rule needs to be ABOVE, and the easiest way is to move the DENY rule to the bottom. Click on the blue arrow to the far right that points rightwards, next to the ANY ANY DENY rule. The screen will then have arrows that point to the lines deviding each rule. Click on the arrow that is right at the bottom to move the rule.
11) Test the connect out, you should be able to connect to port 1433 and see a blank screen