2nd instance of SQL Agent won't start

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

2nd instance of SQL Agent won't start

Author

Topic

djj366
Starting Member

4 Posts

Posted - 2011-12-01 : 01:39:29

Hi everyone,
I'm running SQL Server 2008R2 SP1.
I've got 2 instances installed, each with it's own SQL Agent. (DEV and TEST)

Unfortunately SQL Agent on the TEST instance won't start...
When I start it through SSMS I get a message

"The SQLAGENT$Test service on {machine} started and then stopped."

I've checked in the Windows Event logs, but no useful information there. Does anyone have any pointers on how to get this working, or places to look for a more detailed error message?

Is this a known issue at all?
Many thanks in advance!
regards
Sid

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-01 : 02:06:25

have you configured them (agent services) to run under same account?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

djj366
Starting Member

4 Posts

Posted - 2011-12-01 : 02:09:02

Thanks visakh16,

Yes both Agents are running under Network Service account.

djj366
Starting Member

4 Posts

Posted - 2011-12-01 : 02:49:30

I've just got this from the SQL log file...

2011-12-01 17:15:58 - ? [100] Microsoft SQLServerAgent version 10.50.2500.0 ((Unknown) unicode retail build) : Process ID 1340
2011-12-01 17:15:58 - ? [101] SQL Server SRADWN-DBS02\DEV version 10.50.2500 (0 connection limit)
2011-12-01 17:15:58 - ? [102] SQL Server ODBC driver version 10.50.2500
2011-12-01 17:15:58 - ? [103] NetLib being used by driver is DBMSSOCN.DLL; Local host server is SRADWN-DBS02\TEST
2011-12-01 17:15:58 - ? [310] 4 processor(s) and 8156 MB RAM detected
2011-12-01 17:15:58 - ? [339] Local computer is SRADWN-DBS02 running Windows NT 6.1 (7601) Service Pack 1
2011-12-01 17:15:58 - ! [000] SQLServerAgent cannot start because the instance of the server (DEV) is not the expected instance (TEST)
2011-12-01 17:15:58 - ? [098] SQLServerAgent terminated (normally)

If anyone can help me fix this bit, that would seem to be the problem "SQLServerAgent cannot start because the instance of the server (DEV) is not the expected instance (TEST)"

Thanks!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2011-12-01 : 16:22:24

Read this

http://blogs.msdn.com/b/sqlserverfaq/archive/2010/04/30/sql-server-agent-cannot-start-because-the-instance-of-the-server-instance-is-not-the-expected-instance.aspx

djj366
Starting Member

4 Posts

Posted - 2011-12-01 : 19:19:43

Yes that worked fine thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources