SQL Search is a great tool and I used it quite a lot. Then I installed 2016 SSMS and that was the end of it. I'll be sure...

Some additional notes. In order to get the SQL Server Agent to start I had to put the tcp protocol for the instance back to "Listen All : yes"...

Thank you very much for you assistance Elliott, that was the issue. I had not realised I needed to (or even could) add extra IP addresses to a single...

None at all. I might not have been clear that 10.10.10.149 is not the IP address of the machine, it's the IP address I attempted to point at the...

TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING

This...

Thanks for your time and help with this.

From the application log in event viewer, trying to start the SQLTEST SQL Server service when "Listen All" is set to no:

Error 1:...

Well the virtual machine is running on a hyper-v cluster, but that's not the cluster you're talking about, correct? I'm fairly certain there is no sql server cluster setup...

Fernando-235287 (10/17/2011)

---

:w00t::hehe:

I initiated this trend a couple of months back due to the fact that we were moving forward with our consolidation project (went from 88 servers to 14) We...

Yes, there will be named instances, 3 of them eventually (unless we go to the fallback in which case there's no DNS or aliases or anything, it would effectively be...

If it was just 'the app', that would be a viable solution. But it's not, there are 60+ one click .net apps that all have multiple connections to the...

I don't believe we are using fail-over clustering on SQL Server (though I'm not entirely certain how to check). We have 3 different servers at the moment and ideally...

Having encountered a similar scenario to those outlined in this thread I'm trying to follow the steps given and getting hopelessly lost. I work as a programmer for a...