Do I need SQL Express

I am trying out a Starter Kit which uses SQL Express. I have SQL 2005 Developer and .Net 2.0 framework installed on my XP machine. Do I need to install SQL Express as well? Can't the application work with the full blown version of SQL?

This is my connection string:

<add name="ClubSiteDB" connectionString="initial catalog=ClubDB;Data Source=.\SQLExpress;Integrated Security=true;AttachDBFileName=|DataDirectory|Club.mdf;User Instance=True" providerName="System.Data.SqlClient"/>

This is the error I get: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)

Thanks

You can use your installed SQL but you'll need to modify the connection string and initialize the membership tables in it.

Jeff

|||

Thanks for the response Jeff. What would be the Connection string?

|||

NO. you don't need to install sql express.

Make sure your club.mdf has been attached into your sql server 2005 developer version and then modify your connection string like this:

<add name="constrname" connectionString="Data Source=(local);Initial Catalog=club;Integrated Security=True"
providerName="System.Data.SqlClient" />

Hope my suggestion helps