SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Visual Studio Team System - Database Professionals: Database Connection Error

If you're like me, you don't have SQL Server 2005 sitting on the default instance because SQL Server 2000 is sitting on the default instance. I actually have several instances installed, one of which is a SQL Server Express instance. I finally got around to downloading and installing Visual Studio Team System - Database Professionals this weekend. When I first tried to open up a new database project, I received the following error:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error locating Server/Instance Specified).

I quickly go up to Tools >> Options >> Database Tools >> Data Connections and set the SQL Server Express instance name. I then immediately tried to create a new SQL Server 2005 database project and received the same error. Thinking the computer name might need to be specified, I include it in the normal computer\instance format. Again, the same error. At this point, I decided not to waste any more time and search online. There I came across the following thread on the MSDN forums:

CTP4 Problem

Here's what needs to be done if you don't have SQL Express or a SQL Server 2005 instance as the default instance (it must be SQL Server 2005):

  1. Go to Tools >> Options >> Database Tools >> Data Connections
  2. Set the instance name to whichever instance you want it to use. Do note, this is just the instance name itself, not the full computer\instance. So if you're running an instance called SQL2K5Express on MyDevSystem, you just want SQL2K5Express. You do not want MyDevSystem\SQL2K5Express.
  3. Exit out of Visual Studio 2005 completely and come back in.
This last step is key. Leave it out and it won't notice your new setting for data connection. That was what was getting me before I did the search.

Technorati Tags: | | |

K. Brian Kelley - Databases, Infrastructure, and Security

IT Security, MySQL, Perl, SQL Server, and Windows technologies.


No comments.

Leave a Comment

Please register or log in to leave a comment.