question

GMC avatar image
GMC asked

Two Sql server agents in configuration manager

There are two sql server agents in the configuration manager.One is stopped and the other is running . previously i was using sql2008 and now I am using Sql server 2008 R2. Also in sql2008 I was able to restart the sql server services through command prompt using command "NET STOP MSSQLSERVER" and "NET START MSSQLSERVER". Now in SQL2008R2 when i try to do the same it is showing "System error 5 occured ,access denied" Is this restarting option not availaible in SQL2008R2..??? Should i enable any option for Sql2008 R2 to communicate through command prompt...???
sql-server-2008sql-server-2008-r2sql-agent
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Cyborg avatar image
Cyborg answered
The configuration Manager is showing two SQL Server agent because there are two instance installed on the server, SQL Server 2008 and SQL Server 2008R2. There seems to be a permission issue, check the Log on Account for the SQL Agent (R2) is a Administrative account.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

In the log on tab i was using built in account
0 Likes 0 ·
and using local system
0 Likes 0 ·
Kev Riley avatar image
Kev Riley answered
If you have had 2008 installed and now have 2008R2, then as @Cyborg has pointed out you have 2 instances installed - this is quite normal. Trying to issue the command line start and stop commands is probably trying to reference the first (2008) instance, instead of the newer (and differently named) 2008R2 service. For example on my laptop I have a 2008R2 Express instance, and to start that by command line I need to issue NET START MSSQL$SQLEXPRESS To find the service name, I looked at the properties of the service as listed in services.msc
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hai Kev Riley... now i got the problem solved.but when i try to connect to the database engine using SQL authentication its not allowing me to login. It throws the error "A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)" As per my knowledge i hope there is no prpblem with credentials coz its showing connection established successfully... what exactly does this error mean....
0 Likes 0 ·
The error message suggests a Shared memory issue, but this can be misleading - is this instance on the same machine that you are trying to connect from?
0 Likes 0 ·
Yes it is on the same machine ... and just know i have gone through the configuration manager and was shocked to MSSQLSERVER service being stopped and even if i re-start i couldnot restart it.along with this full text deamon launcher service is also stopped...does this full text service has anything to do with my process.? why am i not able restart the MSSQLSERVER service. I have 30GB free space in my Drive where i have installed sql server and my C: has 15GB free space..i couldnot make it out what exaactly the problem is ?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.