Can someone point me in the direction of a good network configuration FAQ?

• zippy-476815

  SSC Veteran

  Points: 247

  More actions

  August 17, 2007 at 1:03 pm

  #62917

  Here is our scenario:

  We have our LAN, and a server in the DMZ with an internally accessible IP address (192.168.xx.xxx) and an external IP address (DNS > IP address)

  The server is running the default named instance of SQL Server 2005 Express (SQLEXPRESS), and GFI Languard tells me port 1033 is wide open for service "ISA Server" but the randomized port assigned by SQL Server is 1105.

  How do I connect to this SQL Server from my LAN?

  I've tried everything I can think of...

  192.168.xx.xxx:1105\SQLEXPRESS

  192.168.xx.xxx:1033\SQLEXPRESS

  192.168.xx.xxx\SQLEXPRESS:1105

  192.168.xx.xxx\SQLEXPRESS:1033

  192.168.xx.xxx\SQLEXPRESS

  192.168.xx.xxx

  192.168.xx.xxx:1105

  etc, etc...

  What am I missing here?!? Thanks in advance for any help with this frustrating network configuration...

  Mike

   

• zippy-476815

  SSC Veteran

  Points: 247

  More actions

  August 17, 2007 at 1:21 pm

  #727745

  nevermind, I found this tidbit:

  http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

   

  And realized that my SQL Browser service was not running.