Thursday, February 26, 2009

Creating SQL Server Projects in Visual Studio 2008

For the last couple of weeks I've been unsuccessfully trying to create a SQL Server Project within Visual Studio 2008, until now, that is.

In order to create an SQL Server Project in Visual Studio 2008 several things need to be properly configured:

  1. An instance of SQL Server needs to be installed locally (remote servers are not allowed)
  2. The SQL Browser service must be running
  3. The database instance must be blank (or pointing to a valid local instance) at the following configuration path: Tools \ Options \ Database Tools \ Design-time Validation Database \ SQL Server Instance Name
Only after all this is set up and running is that the SQL Server Project can be created within Visual Studio 2008.


Post a Comment