1

Topic: There is no connection with server SQLEXPRESS

All greetings
I try to be connected to server SQLEXPRESS , it is impossible the message is deduced and I cannot be connected
After check broad gulls a problem from a SQL Agent:
2017-10-06 11:07:51 AM-! [298] SQLServer Error: 15247, User does not have permission to perform this action. [SQLSTATE 42000] (DisableAgentXPs)
2017-10-06 11:07:51 AM-! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object ' sp_sqlagent_has_server_access', database ' msdb ', schema ' dbo '. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

Launched it in services (services.msc) works, but in the second time when I launch the error 1067 [/color] deduces
And in [color=red] sql server configuration Manager it generally stopped also does not change on running
when I start it
At me MSQ the SQL Server 2008 R2 and it not edition were read by all connected to this problem of the decision did not find
In what business help to solve a problem

2

Re: There is no connection with server SQLEXPRESS

Urzi wrote:

After check broad gulls a problem from a SQL Agent:

the Agent is inaccessible in edition EXPRESS

3

Re: There is no connection with server SQLEXPRESS

What for launch the agent if then incorporate to the server?
Launch the server

4

Re: There is no connection with server SQLEXPRESS

alexeyvg;
At me not EXPRESS

5

Re: There is no connection with server SQLEXPRESS

o-o;
I need to launch SQL Server Agent for creation Job
But when through services.msc I launch the Agent deduces an error 1067

6

Re: There is no connection with server SQLEXPRESS

Here when I want to launch SQL Server Agent deduces such error

7

Re: There is no connection with server SQLEXPRESS

Urzi wrote:

Here when I want to launch SQL Server Agent deduces such error

What on figs the Agent in the express train?
What version SqlServer?

8

Re: There is no connection with server SQLEXPRESS

Rolg Hupin;
At me a SQL Server 2008 R2, not EXPRESS
I understood that the agent is not supported in EXPRESS

9

Re: There is no connection with server SQLEXPRESS

Urzi wrote:

Rolg Hupin;
At me a SQL Server 2008 R2, not EXPRESS
I understood that the agent is not supported in EXPRESS

select @@ version

10

Re: There is no connection with server SQLEXPRESS

Rolg Hupin;
Thanks! At me it appears EXPRESS