| Author |
Topic |
|
rohans
Posting Yak Master
194 Posts |
 Posted - 2003-11-10 : 07:19:55
|
| All,How do I remotely start the SQL server agent and the SQL server if they are stopped? I have the sql client running on my desktop. I tried starting the SQL agent but it keep telling me access denied. What should I do?All help appreciated |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-11-10 : 07:28:31
|
| Look in the Services app in your administrative tools. Find the SQL Server agent and see what account it is running as. It's possible you have it logging on with an old password.Damian |
 |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-11-10 : 07:33:28
|
AFAIK, you need to be part of Administrator or Power user groups on the server to be able to start and stop SQL Server.Owais
Where there's a will, I want to be in it. |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2003-11-10 : 11:47:58
|
| I tried making myself an administrator on the machine and it did not seem to work. However it worked for another server that I tried it on. Any ideas why it would not work on some servers. I must also state that the server that it worked on uses my account to start the SQL server.All help appreciated. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-10 : 12:22:58
|
| Is the account a domain account? Or is it just a local account?Tara |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2003-11-10 : 12:36:20
|
| A Domain account. I know this is bad practise but it is a test box. In production I would rather use a local account to start the services for security reasons but how would I be allowed remote service control then?All help appreciated. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-10 : 12:37:47
|
| Actually, a domain account is recommended. The account should be a member of the local admin group though. It is recommended in scenarios where the SQL Servers will need to talk to each other.Tara |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2003-11-10 : 14:29:28
|
| I am getting an error message saying, "Error 22022: SQL ServerAgent Error: The SQL Server Agent mail session is not running; check the mail profile and/or the SQLServer Agent service startup account in the SQL Server Agent Properties dialog."The accout I am using has a mailbox on Exchange server. and the SQL mail under Supported Services is running. Is there another mail session i should check.All help appreciated. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-10 : 14:33:03
|
| Did you configure SQL Mail yet? Simply having a mailbox isn't enough. Google this for info: how to configure SQL Mail. The first link from MS is what you want to look at.Tara |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2003-11-10 : 16:09:33
|
| I went through the document and did every thing and the xp_sendmail worked but when I try setting up my operators I am getting the same message error 22022 message. any idea?All help appreciated. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-10 : 16:22:09
|
| Have you tried xp_startmail? Which account is the SQLSERVERAGENT logging on as for the service? Is it an admin account? Does it have a mailbox on the Exchange server? We need to know how things are setup in order to assist.Tara |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2003-11-10 : 16:42:18
|
| You need to configure the SQL Mail. You also need to go into the properties of SQL Server Agent and set up the mail there. You will have to do this to set up operators.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-10 : 16:44:05
|
| Derrick, he already setup SQL Mail. It just isn't working for operators. rohans, so do you get any errors with xp_sendmail? Can you test it out again to see if it is still working? What service pack are you running for SQL Server? Which version of SQL Server?Tara |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2003-11-10 : 17:10:06
|
| I know that. To set up the operators though, you also have to go to the properties of SQL Server Agent and make sure the Mail Session has the exchange setting set up properly. Otherwise, you will be able to use xp_sendmail; however, you won't be able to set up an operator because it runs through the SQL Server Agent service.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-10 : 17:14:25
|
I guess I was confused by your statement then:quote:
You need to configure the SQL Mail.
Sorry about that.Tara |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2003-11-11 : 09:34:32
|
| Tara, I started did the xp_startmail and got the SQL mail session started.Derrick, where in the service properties do I find the SQL Mail configuration. I looked at the four tabs.All help appreciated. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-11 : 12:06:36
|
| Go to Management in EM, then go to SQL Server Agent. Right click and go to properties. Check out the mail session section on the first tab.Tara |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2003-11-11 : 12:38:56
|
| Tara, It finally worked. I owe you big time. Thanks alot. let me know how I can assist you, whenever.All help appreciated. |
|
|
|
|
remote service start