After installing VS2008 and SQL Server 2005 Developer edition I removed the SQL Server 2005 express instance from my computer, thinking that I don’t need it anymore.
 
There were numerous problems with using VS2008 database connection fucntionalities.
It kept on complaining that it needed SQL Server 2005 express to function correctly.
 
Apparently, connection strings such as:
 
<connectionStrings>
<clear />
<add name=”LocalSqlServer” connectionString=”Data
Source=.\SQL2005;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;user
instance=true;Integrated Security=True;Initial Catalog=ASPNETDB;”
providerName=”System.Data.SqlClient” />
</connectionStrings>
 
don’t work with SQL Server 2005 Developer edition because it has to be a real instance and be attached
 
So, for example:
 
<connectionStrings>
<remove name=”LocalSqlServer” />
<add name=”LocalSqlServer”
connectionString=”server=localhost;database=Articles;uid=sa;pwd=1234″
providerName=”System.Data.SqlClient” />
</connectionStrings>
 
is needed
 
  
In short… Do not remove SQL Server 2005 Express for now. Express and Developer run perfectly fine together so just keep both instances.

Advertisements