Microsoft – Visual Studio – Error – “The Selected connection could not be opened. Verify that the server and database are available.”
Kicking around Microsoft Visual Studio this morning and trying to do a couple of things…
And, here is that same error that I wanted to document months ago.
It basically comes back and says
The Selected connection could not be opened. Verify that the server and database are available.
So what do to…
Well, in security conscious environments, it might be a Firewall issues.
What can I do to make sure :
Well run netstat -anb | find “SYN_SENT”
once I ran that command, was able to find the connections experiencing SYN_SENT Errors:
Which connections, surprisingly I am having problems with the DB Mirrored passive node.
Next up, is why is SQL Server having me “pivot” to the Mirrored pair….