Sql agent not starting Can we reinstall just agent ?

[Alex]

SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).

Is any has the same problem ?

[Siva]

Hi Alex,

I think the server you have specified is not there or its not able to recognise try to give the instance name instead of (local) and start the agent.

Or try this:

D:Program FilesMicrosoft SQL ServerMSSQL$(instance name)Binnsqlagent.exe -i (Instancename)

It should start your Sqlserveragent.

In a previous posting's reply on Version Control can you explain these parameters:

set @SQLExec = 'ss cp $/Sql_server/smtmcrsql01/'+rtrim(@dbname)+' -Ysmtmcrsql01 -I-'

set @SQLExec = 'ss add C:Sql_server'+rtrim(@dbname)+'* -Ysmtmcrsql01 -K -I-'

set @SQLExec = 'ss checkin * -Ysmtmcrsql01 -I- -GLC:sql_server'+rtrim(@dbname)+ ' -K '



HTH

Thanks & Regards,
Siva



------------
Alex at 2/7/2002 6:58:27 PM


SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).

Is any has the same problem ?

[mmwops]

Hi Alex,

Another option: what account is being used by the agent (not expired, required to change password or any other obvious password option?)?


------------
Siva at 2/8/2002 12:16:53 AM

Hi Alex,

I think the server you have specified is not there or its not able to recognise try to give the instance name instead of (local) and start the agent.

Or try this:

D:Program FilesMicrosoft SQL ServerMSSQL$(instance name)Binnsqlagent.exe -i (Instancename)

It should start your Sqlserveragent.

In a previous posting's reply on Version Control can you explain these parameters:

set @SQLExec = 'ss cp $/Sql_server/smtmcrsql01/'+rtrim(@dbname)+' -Ysmtmcrsql01 -I-'

set @SQLExec = 'ss add C:Sql_server'+rtrim(@dbname)+'* -Ysmtmcrsql01 -K -I-'

set @SQLExec = 'ss checkin * -Ysmtmcrsql01 -I- -GLC:sql_server'+rtrim(@dbname)+ ' -K '



HTH

Thanks & Regards,
Siva



------------
Alex at 2/7/2002 6:58:27 PM


SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).

Is any has the same problem ?

[Alex]

1.
SQLServer Agent
My server did exist for more then 1 year run fine with service account
DomainSvcSql for Sqlserver and Agent
a) Mail, Agent, Sql server itself runs fine

2 days ago we created account DomainSvcSql2000 and set it to run
Sqlserver and Agent and it did run fine (jobs, dts ,amil )
for 24 hrs then stop
DomainSvcSql2000 member of domainadmin group

Now we can't even login with DomainSvcSql2000 to server
we have to use sa, but Sqlserver service still running
with DomainSql2000

3. Any member domainadmin group deny access to this server .
4. I have same setting on 8 servers and they all run fine

Thank for any help










2. ---- Regarding VSS ---

set @SQLExec = 'ss cp $/Sql_server/smtmcrsql01/'+rtrim(@dbname)+' -Ysmtmcrsql01 -I-'

set @SQLExec = 'ss add C:Sql_server'+rtrim(@dbname)+'* -Ysmtmcrsql01 -K -I-'

set @SQLExec = 'ss checkin * -Ysmtmcrsql01 -I- -GLC:sql_server'+rtrim(@dbname)+ ' -K '

1. ss- command line utility for VSS
2. ss cp -- change directory
3. ss add -- add files to VSS
4. -K -- keep check out
If you go to help for command line for VSS you can find more details
or send me mail to T2581@hotmail.com I can help you set it up over weekend.




------------
mmwops at 2/8/2002 5:24:30 AM

Hi Alex,

Another option: what account is being used by the agent (not expired, required to change password or any other obvious password option?)?


------------
Siva at 2/8/2002 12:16:53 AM

Hi Alex,

I think the server you have specified is not there or its not able to recognise try to give the instance name instead of (local) and start the agent.

Or try this:

D:Program FilesMicrosoft SQL ServerMSSQL$(instance name)Binnsqlagent.exe -i (Instancename)

It should start your Sqlserveragent.

In a previous posting's reply on Version Control can you explain these parameters:

set @SQLExec = 'ss cp $/Sql_server/smtmcrsql01/'+rtrim(@dbname)+' -Ysmtmcrsql01 -I-'

set @SQLExec = 'ss add C:Sql_server'+rtrim(@dbname)+'* -Ysmtmcrsql01 -K -I-'

set @SQLExec = 'ss checkin * -Ysmtmcrsql01 -I- -GLC:sql_server'+rtrim(@dbname)+ ' -K '



HTH

Thanks & Regards,
Siva



------------
Alex at 2/7/2002 6:58:27 PM


SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).

Is any has the same problem ?

[Ray Miao]

Run 'select @@servername' in query analyzer. If result is not the host name, use 'sp_dropserver ser_name' and 'sp_addserver host_name, local' to change server name then restart sql service.

------------
Alex at 2/7/2002 6:58:27 PM


SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).

Is any has the same problem ?

Yes 'select @@servername' returned NULL
I did run 'sp_addserver and still I can't start Agent

The only way I can start agent
a) service Start up Account domainSql2000( the one in trouble)
b) connection use Sql security = set to Sa

when I switch
b) connection use Windows security server stops


------------
Ray Miao at 2/8/2002 9:44:23 AM

Run 'select @@servername' in query analyzer. If result is not the host name, use 'sp_dropserver ser_name' and 'sp_addserver host_name, local' to change server name then restart sql service.

------------
Alex at 2/7/2002 6:58:27 PM


SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).

Is any has the same problem ?

[Alex]

thank everybody for help problem solved .
I have 3 windows groups in my logins
domainSqlAdmin
domainFaxServerAdmin
domainPrintServerAdmin



each group has member = domainsvcsql2000(used as service account for
Sqlserver and SqlServer Agent)
somehow domainPrintServerAdmin was denid access to server in login
properties so access to sql server for domainsvcsql2000 was denid
(does not matter account is member of other groups !!!)
So wnen I granted access to domainPrintServerAdmin everything returned
to normal.









------------
Alex at 2/7/2002 6:58:27 PM


SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).

Is any has the same problem ?