Eirikur Eiriksson (4/6/2015)

---

pveilleux (4/6/2015)

---

It was not running. The 2005 server is a production server and the 2012...

It was not running. The 2005 server is a production server and the 2012 instances (sql101, sql102)...

Eirikur Eiriksson (4/6/2015)

---

pveilleux (4/6/2015)

---

I also went ahead and disabled Named Pipes on sql102, tried the queries, enabled Named Pipes, tried queries again. Everything on sql102 is behaving just...

I also went ahead and disabled Named Pipes on sql102, tried the queries, enabled Named Pipes, tried queries again. Everything on sql102 is behaving just fine. As...

I did not disable Named Pipes on sql101 because it is not disabled on sql102. From sql102, I can get to SQL2005INST no problem. In fact, from sql101,...

No, we're not using Named Pipes to connect. Not sure why that is coming back in the message.

Just for giggles, with the same set up, I tried to run...

No idea. My post is almost a year and a half old, and references something from my last job. I left about 2 months after I posted this....

opc.three (6/6/2012)

---

You say they are sysadmins, well they could be doing something like this which does not require them to know the password of the service account and would still...

SQLKnowItAll (6/6/2012)

---

pveilleux (6/6/2012)

---

SQLKnowItAll (6/6/2012)

---

If someone is a sysadmin, they are automatically in all fixed database roles. They have full access. You could add an SQL Agent role, or...

SQLKnowItAll (6/6/2012)

---

If someone is a sysadmin, they are automatically in all fixed database roles. They have full access. You could add an SQL Agent role, or take it...

This is good stuff, info I couldn't find in any of the BOL.

So, here's what I have:

JobA is owned by sa. SQL Agent and SQL Server are both run...

opc.three (6/1/2012)

---

pveilleux (5/31/2012)

---

Hello, all,

In digging around on one of our servers, I found what appears to be someone logging in as the SQL Server/Agent service account and running jobs. ...

SQLKnowItAll (5/31/2012)In that case, I would make sure to have a separate agent account from the database engine. That 15 minutes will give you time to switch that and keep...

Good point. I have always done a reboot to be on the safe side. This client has many, many, many processes that move data among multiple servers,...

It's...