I would expect that would depend on the needs and requirements of your environment.

A secure type environment might require you to use a separate certificate for each database (even if...

Have you tried connecting by IP instead of the name?

Presuming this is all internal to the VMware (IE, the network these three are on does not connect to the wide-world)...

Man, I hate when my Google-Fu has an off day...

Spent a chunk of the morning fighting with a DB restore on a Devs stand-alone, Google'ing like mad to find the...

That could be the problem then. This is on a developers stand-alone which I have no control over the patch level of the SQL he has installed. ...

You describe the SQL servers as nodes, are they clustered?

If so, what sort of clustering?

Otherwise, if they're two stand-alone instances of SQL, check that the Windows Firewall is either off...

Ed Wagner (9/27/2016)

---

Michael L John (9/27/2016)

---

Phil Parkin (9/27/2016)

---

Brandie Tarvin (9/27/2016)

---

SET RANT Brandie ON;

I just spent the past week working on a bug fix to get into our production systems before...

Steve Jones - SSC Editor (9/26/2016)

---

jasona.work (9/26/2016)

---

I find it a little concerning that while there's been a decent amount of talk about how this will impact desktop Windows, there's not...

I find it a little concerning that while there's been a decent amount of talk about how this will impact desktop Windows, there's not been so much about how it's...

Trying to figure out when I'm going to need to take a week or two off to avoid the angry mob that's coming...

We're going to be taking away access for...

I saw that monstrosity and I'm not even going to try to parse it out...

Sometimes I'll take messy queries like...

If you haven't already, and this might take some work, check in the SQL Agent jobs. I've got several of my SQL Servers set up with a job that...

BrainDonor (9/22/2016)

---

jasona.work (9/21/2016)

---

So a book I'm currently reading (highly recommend, I've actually laughed out loud because of what I'm about to tell you) has possibly the BEST explanation for why...

Luis Cazares (9/21/2016)

---

jasona.work (9/21/2016)

---

I have had a topic resurrected from the dead!!!

I am now a member of that elite group of "dead topics revived!"

Noticed the email alert that a reply...

I have had a topic resurrected from the dead!!!

I am now a member of that elite group of "dead topics revived!"

Noticed the email alert that a reply had been posted,...

Brandie Tarvin (9/21/2016)

---

jasona.work (9/21/2016)

---

So a book I'm currently reading (highly recommend, I've actually laughed out loud because of what I'm about to tell you) has possibly the BEST explanation for...