|
Home > Archive > MS SQL Server > November 2006 > Which service has to be auto started ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Which service has to be auto started ?
|
|
|
| I install the first SQL Server 2005, during installation, I have to choose
which service to start up automatically.
Should I get SQL Server Agent & Browser services checked ? Besides, I would
like to know what is the SQL Server Browser service.
Thanks
| |
| Paul Ibison 2006-11-28, 5:16 am |
| Peter,
here is an article which explains the use of the browser service:
http://msdn2.microsoft.com/en-us/library/ms165724.aspx. Basically it is a
service that is used to identify the ports that named instances listen on.
In the section "Using SQL Server Browser" you can see what won't work if the
service is not enabled.
As for the SQL Server Agent, I would always have it autostart otherwise the
maintenance and backup tasks won't run.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
| |
|
| Dear Paul,
Thank you for your reply.
If I don't use Named Instance, I don't need to set "Browser Service" to
auto-start ?
Thanks again
Peter
"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:%23J2hpHtEHHA.3188@TK2MSFTNGP06.phx.gbl...
> Peter,
> here is an article which explains the use of the browser service:
> http://msdn2.microsoft.com/en-us/library/ms165724.aspx. Basically it is a
> service that is used to identify the ports that named instances listen on.
> In the section "Using SQL Server Browser" you can see what won't work if
> the service is not enabled.
> As for the SQL Server Agent, I would always have it autostart otherwise
> the maintenance and backup tasks won't run.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
| |
| Paul Ibison 2006-11-28, 7:13 pm |
| Yes you could disable in this case. However there will be other implications
that are worth noting but which might not be important in your case:
The DAC won't work if you are not using the default port.
The OLAP redirector service won't work
Enumerating servers in SQL Server Management Studio won't work (in my case
this actually still seems to work but perhaps this is just caching).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
| |
|
| Dear Paul,
Many thanks for your advice.
Peter
"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:%23dSnU7tEHHA.3520@TK2MSFTNGP04.phx.gbl...
> Yes you could disable in this case. However there will be other
> implications that are worth noting but which might not be important in
> your case:
> The DAC won't work if you are not using the default port.
> The OLAP redirector service won't work
> Enumerating servers in SQL Server Management Studio won't work (in my case
> this actually still seems to work but perhaps this is just caching).
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
>
>
|
|
|
|
|