Visual Studio 2012 and MS Sql Server 2012 - connect with Server Explorer

sql visual-studio-2012 server-explorer
Milen Stefanov picture Milen Stefanov · Sep 15, 2012 · Viewed 15.5k times · Source

I have a problem establishing connection with Server Explorer in Visual Studio 2012 Ultimate with MS SQL server 2012 Express. Everything is on local machine.

You can see screen shot here - http://s16.postimage.org/4gvo7r5id/se_prob_ss1.png

With System.Data.SqlClient and SqlConnection.Open() everything work fine I'm able to connect and execute SQL scripts (with and without Windows Authentication).

What I tried so far:

  • I checked in MS SQL Management Studio in Conncetions "Allow remote connections to this server" (Checked)
  • In SQL Server Configuration Manager on my SQL server TCP/IP protocol is enabled
  • I tried to connect with turned off firewall and antivirus protection
  • I tried with new Logins (with System.Data.SqlClient.SqlConnection it work)

Answer

Jeff Siver picture Jeff Siver · Sep 15, 2012

In the picture, the server name you are connecting to appears wrong. You indicated you installed SQL Express; it has a default instance name of SQLEXPRESS. So the server you are connecting to should be:

MILLENIUM\SQLEXPRESS

instead of just MILLENIUM.

Related questions

SQL Server 2012 installation Reporting Services Catalog error

I'm installing SQL Server 2012 at the moment and when I was about to run the installation, this error pops up: On clicking the first failed test, which is "Reporting Services Catalog Database File Existence", this is what i get: On …

Read More
Error in SQL script: Only one statement is allowed per batch

I have 4 sql scripts that I want to run in a DACPAC in PostDeployment, but when I try to build the VS project for 3 of them I get this error: Only one statement is allowed per batch. A batch separator, …

Read More
How to properly manage database deployment with SSDT and Visual Studio 2012 Database Projects?

I'm in the research phase trying to adopt 2012 Database Projects on an existing small project. I'm a C# developer, not a DBA, so I'm not particularly fluent with best practices. I've been searching google and stackoverflow for a few hours …

Read More