| Author |
Topic |
|
daquoc
Starting Member
35 Posts |
 Posted - 2006-02-20 : 20:52:44
|
| Hi experts,I can't start remote sever's SQLServerAgent. Is there any solution?.Thanks a lot.daquoc |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-20 : 21:19:46
|
| do you have sa privilege?what version are you using? enterprise will be able to do it remotelyHTH--------------------keeping it simple... |
 |
|
|
daquoc
Starting Member
35 Posts |
Posted - 2006-02-22 : 01:29:54
|
| Hi jen My client's pc (PC_01) run SQL Server 2000, my server also runs SQL Server 2000 (SERVER_01) and I also have password sa of SERVER_01. But when I use Service Manager from PC_01 to start SQLAgent the error access denied occurs.daquoc |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-22 : 02:40:16
|
| is the sqlserveragent in server running using a domain account?--------------------keeping it simple... |
|
|
|
daquoc
Starting Member
35 Posts |
Posted - 2006-02-22 : 19:47:19
|
| Hi Jen How can I check if it's using domain account?daquoc |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-22 : 20:19:26
|
| start-->settings-->control panel--> administrative tools--> servicescheck for sqlserveragent and go to Log On tab, verify the account used--------------------keeping it simple... |
|
|
|
daquoc
Starting Member
35 Posts |
Posted - 2006-02-23 : 23:10:11
|
| Yeah, It logs on as Local system account. So, what'll I do next.daquoc |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-24 : 07:36:09
|
| change it to a domain account and add that account as member of thelocal administrator group of the server (under computer management)--------------------keeping it simple... |
|
|
|
daquoc
Starting Member
35 Posts |
Posted - 2006-02-26 : 20:26:15
|
| Hi Jen The first step I did it OK (change it to a domain accoutn). But I couldn't make the second step (add that account as member of the local administrator group of the server) because I'm not an Admin of the server (SERVER_01). However, I can do it on PC_01. Is it impossible if I can't do the second step on server?.daquoc |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-27 : 03:13:04
|
| you should make that domain account member of the local admin group...How where you able to change the logon account without admin privilege on the server_01?--------------------keeping it simple... |
|
|
|
daquoc
Starting Member
35 Posts |
Posted - 2006-02-27 : 20:03:47
|
| Oh no, I did it on PC_01 (change it to domain account). I mean how can I start SERVER_01's SQLServerAgent on PC_01. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-27 : 20:18:32
|
| don't panic, follow through:you have PC_01 and Server_01you want to be able to start and stop sqlserveragent on Server_01 using PC_01what to do:change the service account on Server_01 to domain accountmake sure that the domain account is member of the local admin group on Server_01when you make the change, make sure you restarted the service (no need for a reboot)--------------------keeping it simple... |
|
|
|
daquoc
Starting Member
35 Posts |
Posted - 2006-03-01 : 21:06:46
|
| Hi Jen, we may misunderstood.How can I change the service account on SERVER_01 to domain account when I don't have admin privilege on the server_01. I think that on PC_01 I can't do that task, right?.So the next steps I also unable to do it.All what I do is using SQLSERVER on PC_01 to register SQLSERVER on server_01 with SERVER_01's sa password .Nice working day.daquoc |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-01 : 21:15:44
|
| ok, then it means you have no permission to make that change,Are you the DBA? If yes, by right, you should have admin privilege on that server box.If not, why do you want to restart the service?--------------------keeping it simple... |
|
|
|
daquoc
Starting Member
35 Posts |
Posted - 2006-03-02 : 20:11:01
|
| Hi JenThat's what I want to ask you. May be I'll do it on server_01 when I have admin privilege.Thank so much and see you again.daquoc |
|
|
|
|
Start SQLServerAgent at remote Server?