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.
| Author |
Topic |
|
wided
Posting Yak Master
218 Posts |
 Posted - 2011-12-12 : 09:59:23
|
| HIin which case there is not "sql agent" on SQL SERVERI think all SQL options except SQL AGENT knowing that I find if I log on the server as an administrator on the field or as a local user |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-12 : 10:30:28
|
| did you install it when running the sql server intallation?Or it might be that you dont have access to see it. It depends on what role your login is mapped in the db------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
wided
Posting Yak Master
218 Posts |
Posted - 2011-12-12 : 10:58:33
|
| thanks visakh, SQL AGENT exists in the list of services when I try to start the service, a message appears: "the service starts and stops, some services start and stop if they have no case there is no work to do .." If I connect then server SQL as authotification Windows, I can not find the option If I connect as "sa" , I find the option, but the service will not start and the "New" button is grayed if this can help you see the problem |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-12 : 11:01:54
|
| ok. whats the account used by sql agent service? you you see it by right clicking service and seeing properties inside services.msc.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
wided
Posting Yak Master
218 Posts |
Posted - 2011-12-12 : 11:20:18
|
| This is the account that I used at the opening of the sessionwhen I click apply it asks me to restart the service, I restartedje n'ai pas utilisé compte système localj'ai utilisé ce compte (login) + mot de passe |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-12 : 11:23:25
|
quote:
Originally posted by wided
This is the account that I used at the opening of the sessionwhen I click apply it asks me to restart the service, I restartedje n'ai pas utilisé compte système localj'ai utilisé ce compte (login) + mot de passe
hmm? sorry i cant see the details of accountplease check if account has enough access------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
wided
Posting Yak Master
218 Posts |
Posted - 2011-12-12 : 11:30:36
|
| ok thanks |
|
|
|
|
|
|
SQL AGENT