Microsoft – Visual Studio – Error – “The Selected connection could not be opened. Verify that the server and database are available.”

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.

MSVisualStudio-ErrorMessage-TheSelectedConnectionCouldNotBeOpened

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….

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s