I am trying to setup a new site based on the Beer House architecture to a Sql Server 2000 so I replaced the below string:

<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspn etdb.mdf" providerName="System.Data.SqlClient"/>

by the below:

<add name="LocalSqlServer" connectionString="server=MyServerPROD01;database=T erra;User ID=test;Password=test" providerName="System.Data.SqlClient"/>


But it doesn't work what can I do?

Thanks

I got it...as is in the readme.txt

   <connectionStrings>
      <remove name="LocalSqlServer"/>
      <add name="LocalSqlServer" connectionString="server=111.222.333.444;Initial Catalog=TheBeerHouse;uid=DBuserName;pwd=SecretPass word"
       providerName="System.Data.SqlClient"/>
   </connectionStrings>


Thanks,

Rick