I am trying to get my site to work online and having problems. I was initially using the beta version but just recently downloaded the new version. I am using godaddy and here is what I have done so far:

I downloaded the final version at http://www.asp.net/downloads/starterkits/default.aspx?tabid=62

I followed the directions from http://help.godaddy.com/article.php?article_id=688&topic_id

I used the Query Analyser from the SQL Server Web Admin to install classifieds-add.sql and classifieds-categories.sql from the App_Data folder. Tables, views and stored procedures were all entered.

I have tried several several different connection strings:

<add name="classifiedsConnection" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\classifiedsdb.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

<add name="classifiedsConnection" connectionString="Data Source=SERVER;Database=CLASSIFIEDSDB;User ID=my_username;Password=my_password;Trusted_Connection=False" providerName="System.Data.SqlClient=" />

    <remove name="LocalSqlServer"/>

    <add name="LocalSqlServer" connectionString="Server=SERVER;Database=ASPNETDB;User ID=my_username;Password=my_password;Trusted_Connection=False" providerName="System.Data.SqlClient" />

<add name="classifiedsConnection" connectionString="whsql-v04.prod.mesa1.secureserver.net;Database=DB_79394;User ID=my_username;Password=my_password;Trusted_Connection=False" providerName="System.Data.SqlClient" />

      <remove name="LocalSqlServer"/>

      <add name="LocalSqlServer" connectionString="Server=whsql-v04.prod.mesa1.secureserver.net;Database=DB_79394;User ID=my_username;Password=my_password;Trusted_Connection=False" providerName="System.Data.SqlClient" />

Only the first connection string above will work on my localhoast. The last two will not and I get this error when I debug:

"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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

None of them work online. I will always get the error.aspx page telling me to contact the site administrator.

This is the first time I have ever done this... Please advise.

Thanks,

BB