• 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.

    :).

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    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. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].