1

I have a Web server in my DMZ, I have a SQL Server 2008 R2 server inside the LAN, this database server has named instance with a NO dynamic port. I have set as firewall rules the connection from my DMZ server and the database server in the SQL Server instance port and the UDP port 1434 for SQL Browser.

I thought this will be enough to allow the connection between the two servers, however I created a UDL file in my DMZ server and tried to connect to the SQL server instance and it failed, but when I included the Instance port in the string, it worked.

Please can you help me, I want to be able to connect to the named instance without including the Instance port, instead use the SQL Browser as it would be for other serves inside the LAN.

Thanks

benRollag
2114 silver badges14 bronze badges
asked Jul 27, 2012 at 19:19
1
  • Do you have another SQL Server instance running on the server? Commented Jul 28, 2012 at 22:55

1 Answer 1

1

Although what you described should work as configured, another option would be just create an alias for your named instance.

answered Jul 29, 2012 at 3:34

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.