Your remote connection string should look something like this:
<add name="LocalSqlServer"
connectionString="Data Source=whsql-vXX.prod.mesa1.secureserver.net; Initial Catalog=YOUR-DB-ID; User ID=YOUR-USER-ID; Password=YOUR-PASSWORD;"
providerName="System.Data.SqlClient"/>
I'm looking back at your previous posts and noticed you posted the actual DB# for your remote connection-you should never post that information for security reasons. I would strongly suggest (since it looks like you're not live yet) deleting
that remote DB and adding a new one so that you have a diff DB id.
MarValUS
Member
74 Points
29 Posts
Re: GoDaddy
Jul 18, 2007 01:02 AM|LINK
Jay,
The connections sometimes are enough to drive you nuts, hope the below info helps.
The local connection should be:<add name="ClubSiteDB" connectionString="Data Source=.\SQLExpress;Integrated Security=true;AttachDBFileName=|DataDirectory|ClubDB.mdf;User Instance=True" providerName="System.Data.SqlClient"/>
Your remote connection string should look something like this:
<add name="LocalSqlServer" connectionString="Data Source=whsql-vXX.prod.mesa1.secureserver.net; Initial Catalog=YOUR-DB-ID; User ID=YOUR-USER-ID; Password=YOUR-PASSWORD;" providerName="System.Data.SqlClient"/>
I'm looking back at your previous posts and noticed you posted the actual DB# for your remote connection-you should never post that information for security reasons. I would strongly suggest (since it looks like you're not live yet) deleting that remote DB and adding a new one so that you have a diff DB id.
Good Luck.
connection string club.mdf ClubSite Club Starter Kit GoDaddy