March 3, 2010 at 4:11 pm
this would be my first question on sql 2008..please advice....i have sql 2008 X64 running on port no 12345..not the default one...mentioned below are my questions
tcp/ip enabled, named pipe enabled...users access sql through client by mentioning (servername,portno)....---- does sql browser need to be enabled on this server?
my understanding was if we are running sql engine on any port no other than default then sql browser has to be running and users can only connect by mentioning (servername,portno). i request sql gurus to clarify this please....
Thanks
March 3, 2010 at 4:29 pm
You don't need to have the browser running if people know the port. They can't connect with server/instance without the browser I believe, but if you have specific ports setup, they can just connect with that TCP port.
The browser responds to requests to let the client know what port to use. Especially in the case of named instances. However if you set specific ports, you can have clients use those. I would enable FQDNs for the server rather than the Windows name.
March 3, 2010 at 5:03 pm
Steve is correct about the browser, port and using an FQDN makes sense.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply