Error while starting SQL server Agent service in MS SQL server 2008

[Alfie K]

Hi,

If you receive the error message "SQLServerAgent could not be started (reason: Error creating a new session)" while starting SQL server Agent service in MS SQL server 2008 configuration manager on Windows server, follow the steps below to get this sorted out.

Error :

SQLServerAgent could not be started (reason: Error creating a new session)

[You will see this error in event viewer]

Solution :

1. Click Start, click Programs, and then click SQL Server 2008.
2. Click Configuration Tools, and then click SQL Server Configuration Manager.
3. Expand SQL Server 2008 Services.
4. Locate the SQL Server Agent service. The SQL Server Agent service is named "SQL Server Agent" for default instances and is named "SQL Server Agent (Instance name)" for named instances.
5. Right-click SQL Server Agent, and then click Properties.
6. On the Log On tab, click to select the account check box. Specify a different account name and password.
7. In the Service status section, click Start, and then click OK.

[Tech Hunter]

Re: Error while starting SQL server Agent service in MS SQL server 2008

Hello Alfie,

I often see most of the people select the Default Instance name while installing the SQL server.
What should be the "Instance name" while installing the SQL server.? or Which Option should I select in installetion Default Instance or Named Instance?


Regards,
Tech Hunter
[email protected] Lo0king S0meth!ng

[Rock]

Re: Error while starting SQL server Agent service in MS SQL server 2008

Hello Alfie,

I often see most of the people select the Default Instance name while installing the SQL server.
What should be the "Instance name" while installing the SQL server.? or Which Option should I select in installetion Default Instance or Named Instance?


Regards,
Tech Hunter
[email protected] Lo0king S0meth!ng

Hi,

There's no major difference in choosing between a default instance & a named one. When you choose default instance during installation, you can simply connect remotely (or locally) to the SQL server using the IP address (or hostname or domain name) only ie. ip-address & when you choose a named instance, you need to specify it (named instance) after the IP/hostname/domain name. ie: ip-address\named.. Also, there can be only one default instance but you can install multiple named instances if you're going to install more than one copy of SQL on that single machine.