Problem with SQL server browser. Help needed

Question

Post reply

Problem with SQL server browser. Help needed

stimanov

Old Hand

Points: 396
More actions
October 14, 2011 at 2:09 am

#244581

Hello everybody. Need help from gurus.
My setup: SQL Express 2008 R2 on Win 7 Professional.
My problem: SQL browser doesn't listen on ipv4 - only on ipv6. This is confirmed by itself (when starting it in console mode):
[font="Courier New"]c:\Program Files (x86)\Microsoft SQL Server\90\Shared>sqlbrowser -c
SQLBrowser: starting up in console mode
SQLBrowser: starting up SSRP redirection service
SQLBrowser is successfully listening on ::[1434]
[5064]: Waiting for next request...
[5064]: Received request...
[2996]: Waiting for next request...
[2996]: Received request...[/font]
As far as i understand there should also be line "SQLBrowser is successfully listening on 0.0.0.0[1434]" but there is no.
It also confirmed by netstat:
[font="Courier New"]C:\>netstat -ano | findstr 1434
UDP [::]:1434 *:* 3700[/font]
Again it can be seen that it doesn't listen on ipv4.
TCPView shows the same (you can trust me here even without screenshot ;)).
As a result i can't connect to the server through ipv4 without explicitly specifying IP port in the server name.
Any ideas how to force this stupid sql browser to start listen on ipv4?
Or maybe root cause of the problem somewhere else?

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

Skandalis Hall of Fame Points: 3517 More actions · Answer 1

Hi,

See if this helps:

http://msdn.microsoft.com/en-us/library/ms177440.aspx

stimanov Old Hand Points: 396 More actions · Answer 2

Thanks, but http://msdn.microsoft.com/en-us/library/ms177440.aspx is about different issue. It is about sql server itself which works well. But my question is about sql server browser and it's ignoring of ipv4.

Skandalis Hall of Fame Points: 3517 More actions · Answer 3

Can you confirm, via the Configuration manager, that SQL is listening on that port for IPV4?

Have you tried restarting the browser?

stimanov Old Hand Points: 396 More actions · Answer 4

SQL server is listening on it's default TCP port 1433 and (surprise!) TCP port 49955 both on ipv4 and ipv6. I can successfully connect to it both from local and remote computers (remote computer is XP and doesn't have ipv6 at all).

SQL browser listens on it's default UDP port 1434 only[/u] on ipv6.

I restarted sql browser service some number of times, started it in console mode - nothing helps.

I simply don't understand why it drops ipv4? Where it can be configured?... All documentation tells that if ipv6 installed on computer then sql browser should listen on both protocols. But it doesn't.