<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Steve Jones
»
SQL Server Browser
11 posts, Page 1 of 2
1
2
»»
SQL Server Browser
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Monday, November 24, 2008 11:51 PM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526,
Visits: 13,864
Comments posted to this topic are about the item
SQL Server Browser
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #608106
ghollis
ghollis
Posted Tuesday, November 25, 2008 7:28 AM
Old Hand
Group: General Forum Members
Last Login: Thursday, January 12, 2012 12:05 PM
Points: 308,
Visits: 126
The link provided in the answer states, "When SQL Server clients request SQL Server resources, the client network library sends a UDP message to the server using port 1434. SQL Server Browser responds with the TCP/IP port or named pipe of the requested instance. The network library on the client application then completes the connection by sending a request to the server using the port or named pipe of the desired instance."
Does this not contradict the reported explanation?
Post #608336
Cliff Jones
Cliff Jones
Posted Tuesday, November 25, 2008 7:31 AM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 2:31 PM
Points: 3,418,
Visits: 3,438
I was just about to make the same point. It seems that Conecting via TCP/IP should be correct also?
Post #608338
Joe Burdette
Joe Burdette
Posted Tuesday, November 25, 2008 7:38 AM
SSC-Addicted
Group: General Forum Members
Last Login: Yesterday @ 11:49 AM
Points: 437,
Visits: 359
Agreed, I third the motion… ;)
Regards,
Joe Burdette
hanesbrands.com
Post #608346
A_A_R_T
A_A_R_T
Posted Tuesday, November 25, 2008 7:47 AM
SSC Veteran
Group: General Forum Members
Last Login: 2 days ago @ 6:28 AM
Points: 276,
Visits: 330
I'll be the fourth then :P
Post #608355
Mohit K. Gupta
Mohit K. Gupta
Posted Tuesday, November 25, 2008 7:54 AM
SSC Eights!
Group: General Forum Members
Last Login: Monday, June 10, 2013 10:58 AM
Points: 941,
Visits: 1,042
Aaa I am late
. But I agree with it, I was talking to Microsoft Engineer on recent course. Because every book tells me to turn of Browser service as it is not required. So I ask him why the heck Microsoft made it if most people recommend it to disable it.
After talking, it turned out the Browser service is required if you use a non-standard port for SQL Server. If you a non-standard port, and you have the browser service turned off, then you did have to enter the port information into the connection properties.
:).
---
Mohit K. Gupta, MCITP: Database Administrator (2005),
My Blog
, Twitter:
@SQLCAN
.
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing.
How to ask for help .. Read Best Practices
here
.
Post #608362
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Tuesday, November 25, 2008 9:01 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526,
Visits: 13,864
Perhaps things are mis-worded, but I think the answer is fine.
Connecting via IP and port would be connecting to my local server as 127.0.0.1, 1433
That would not use the Browser service. If I connected via SJONES, then the Browser would return the IP and port to my client, which would then connect.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #608433
Cliff Jones
Cliff Jones
Posted Tuesday, November 25, 2008 9:24 AM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 2:31 PM
Points: 3,418,
Visits: 3,438
OK, I understand what you are saying. If my client connects by specifying the IP and Port then it would not use or need the Browser Service. Thanks for the explanation.
Post #608463
A_A_R_T
A_A_R_T
Posted Tuesday, November 25, 2008 9:51 AM
SSC Veteran
Group: General Forum Members
Last Login: 2 days ago @ 6:28 AM
Points: 276,
Visits: 330
Clear. Thanks for your explanation. I'm always having difficulties with semantics
Post #608502
Mohit K. Gupta
Mohit K. Gupta
Posted Tuesday, November 25, 2008 9:55 AM
SSC Eights!
Group: General Forum Members
Last Login: Monday, June 10, 2013 10:58 AM
Points: 941,
Visits: 1,042
Steve Jones - Editor (11/25/2008)
Perhaps things are mis-worded, but I think the answer is fine.
Connecting via IP and port would be connecting to my local server as 127.0.0.1, 1433
That would not use the Browser service. If I connected via SJONES, then the Browser would return the IP and port to my client, which would then connect.
I just read it again, I agree. Its one of those Microsoft certification questions, its sounds like but not quite what the question was asking heh. I guess if the option was "provide ip/port information", then it would be a correct option.
---
Mohit K. Gupta, MCITP: Database Administrator (2005),
My Blog
, Twitter:
@SQLCAN
.
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing.
How to ask for help .. Read Best Practices
here
.
Post #608507
« Prev Topic
|
Next Topic »
11 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
