Wednesday, March 21, 2012

Interesting issue

I tried to create a new SQL Agent job today and couldn't. Got this error msg.
"Error 0: This server has been disconnected. You must reconnect to perform
this operation. The job was not saved." I got this message on every server I
connected to via EM, dozens - EXCEPT the ones that weren't default instances.
My colleague had the same problem but no-one else in the team did. My
colleague and I have different PC builds in that we have XP SP2 and have SQL
2005 tools installed as well as 2000. Sensing the problem was something to
do with port 1433 as it only affected default instances, I changed our client
connectivity protocols so that Named Pipes was above TCP/IP, and now we don't
have a problem. Strange. Anyone shed any light on why connecting to default
instance SQL Servers via EM using TCP/IP connections stops us saving new jobs
in SQL Agent? Many thanks.Solved it. New security software had a 'MS SQL Job Scheduling' intrusion
Prevention rule. When that was omitted, we could create jobs using TCP/IP
connections.
"Shirley" wrote:
> I tried to create a new SQL Agent job today and couldn't. Got this error msg.
> "Error 0: This server has been disconnected. You must reconnect to perform
> this operation. The job was not saved." I got this message on every server I
> connected to via EM, dozens - EXCEPT the ones that weren't default instances.
> My colleague had the same problem but no-one else in the team did. My
> colleague and I have different PC builds in that we have XP SP2 and have SQL
> 2005 tools installed as well as 2000. Sensing the problem was something to
> do with port 1433 as it only affected default instances, I changed our client
> connectivity protocols so that Named Pipes was above TCP/IP, and now we don't
> have a problem. Strange. Anyone shed any light on why connecting to default
> instance SQL Servers via EM using TCP/IP connections stops us saving new jobs
> in SQL Agent? Many thanks.|||Just out of curiosity, what kind of security software?|||Symantec.
"Curt" wrote:
> Just out of curiosity, what kind of security software?
>

No comments:

Post a Comment