Fairy Tale---What is SQL Server Browser

Goofy Dog these days especially depressed, do not know how to pass TCP/IP Protocol Connection SQL Server database. Fortunately kung Fu, after a few days of hard research, finally got the answer.

Goofy Dog Call UDP1434 Port , "Jingle Bell, jingle Bell ... .. "

UDP1434 Port : Hello, i am SQL Server Browser My name is Daisy , may I help you? ?

goofy dog : ( ! The phone is a sweet-sounding mm! Heart rate, red-flushed !) Oh Oh ?! I want to ask you what DB instances are on your machine

udp1434 Span style= "font-family: Arial" > port ( daisy : sql Server db instance has Mickey Mouse , Donald Duck and Pluto , who would you like to find

goofy dog : ( hey ! How database instances are boys, really boring !) then I'll find Donald Duck .

UDP1434 Port ( Daisy ) : Donald 's TCP Port is 65032 , please call him directly.

Goofy Dog : Excuse me, Donald's TCP How does the port number differ from the last time? ?

UDP1434 Port ( Daisy ) : Each time a DB instance is started, its TCP The port number is dynamically allocated by the system, each time the assigned TCP the port number is rarely the same as before. Please call me before reconnecting your db instance.

Goofy Dog : your voice is so sweet, it must be very juicy, can you see a movie tonight? ?

UDP1434 Port ( Daisy ) : Less nonsense! Go find your Donald Duck , remember his TCP port is 65032.

Goofy Dog Call TCP65032 Port , "Jingle Bell, jingle Bell ... .. "

TCP65032 Port ( Donald Duck ) : Hello, I am a database instance Donald , what can I do for you? ?

Goofy Dog : Damn Donald Duck ! Finally found you again! Last data transmission half of you went down, hurriedly give me a breakpoint to continue to pass !

Through this fairy tale, we draw the following conclusions:

Conclusion 1 : You can have multiple DB instances on a single computer.

Conclusion 2 : Each DB instance is dynamically assigned by the system each time it is started TCP Port number.

Conclusion 3 : by SQL Server Browser you can query what DB instances are available and TCP Port number.

Conclusion 4 : SQL Server Browser The port number is fixed to UDP1434 .

Fairy Tale---What is SQL Server Browser