Hi..

I can't work on the book as I have problems in connecting the db to an SQL server 2005 default istance

I have attached tha database to teh sql server and changed the web config connection string as follow

Data Source=(local);Initial catalog=WroxUnited;Integrated Security=True;

I also allowed remote connection and enabled tcp/ip and statred sqlbrowser etc....

still error 26 as the remote connection is not enabled.

what can I do ?

I found a solution bya dding this line into the machine.config file

<connectionStrings>
   <add name="LocalSqlServer" connectionString="data source=mylocaldatasource;Integrated Security=SSPI;Initial Catalog=aspnetdb" providerName="System.Data.SqlClient"/>
  </connectionStrings>

then in the web.config file I changed the connection string as follow

<connectionStrings>
   <add name="wroxUnited" connectionString="data source=mydatasource;Integrated Security=SSPI;Initial Catalog=WroxUnited" providerName="System.Data.SqlClient"/>
  </connectionStrings>

apparently the machine.config was not retrieving the aspnetdb

However is still a strange behaviour and if anyone as a more generic solution (e.g. reinstal asp.net) I would be happy to know about it

by the way..

would be a problem to have sqlexpress running together with sql on the same machine..

Hi brillox,

No there shouldn't be a problem running SQL Standard\developer on the same box as SQL Express as long as they have different instance names. For example (local)\SQlExpress and (local)\SQLStd. After that, it would be up to you to make sure that you know which version of SQL you are using and give the web site the correct connection string and permissions as relevant. Please have a look at the new appendix b for more on those. Download it from http://www.hmobius.com/downloads.aspx

Thanks, Dan

Dan Maharry
Read the feed at http://feeds.feedburner.com/dansarchive