SQL Browser on Windows Server 2008 with 2 networkcards

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Klaus Löffelmann - 29 Jul 2008 17:54 GMT

Hi,

we're running SQL Server 2005 on a Windows Server 2008. One networkcard -
fixed IP 192.168.3.1 (WAN) - is the internet gateway. The other - 192.168.0.2
(LAN) - connects this server with our local network.

As long as the WAN network cards is disabled, the default instance of SQL
server ist accessible via SQL browser. If we enable teh WAN cards, the SQL
server is neither reachable via SQL Browser nor via direct ip address
(192.168.0.2:1433).

How can we have both networkcards working and the SQL SERVER browser running
properly?

Thanks,

Klaus

Reply to this Message

Siim Karus - 30 Jul 2008 11:40 GMT

Hi Klaus!

I am running similar configuration with SQL Server 2008 and it is working
without any problems. I suggest having a look at your SQL Server Network
Configuration (in Configuration Manager) and verify the addresses the server
is listening on. Also, checking the status (and events) of Browser and
Firewall (SQL Browser default port is 1434) can help you find the cause for
the issue. You can also try fixing ports and ips for servers to make sure
they are accessible. It is also worth to note that SQL Browser notes only
the first enabled port for an instance
(http://msdn.microsoft.com/en-us/library/ms181087.aspx).

Yours sincerely,
Siim Karus

> Hi,
>
[quoted text clipped - 15 lines]
>
> Klaus

Reply to this Message

Rick Byham, (MSFT) - 30 Jul 2008 16:33 GMT

You could be having trouble due to loose source mapping. See the Multiple
Server IP Addresses section of SQL Server 2008 Books Online topic
Troubleshooting: Timeout Expired.
http://msdn.microsoft.com/en-us/library/ms190181(SQL.100).aspx

Signature

Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

> Hi Klaus!
>
[quoted text clipped - 31 lines]
>>
>> Klaus

Reply to this Message