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 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:
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.
Basically when you setup the .net 2.0 schema for the users and roles go daddy puts everything in your DB_79394 database, and then I'm assuming you ran the classifieds sql scripts in that database as well.
Now, if you try and connect to that database from your local machine, you will get that error message. Go Daddy will not allow you to access their sql servers from a remote machine. So you will either need to use the sql express connection string when developing
on your local machine and switch your connection strings when you upload the application to go daddy's server. Or you can develop the app, then upload it and test it that way which is time consuming
You are right by running those sql scripts, but can you post the actual error message you are getting?You may need to change your custom errors tag in your web.config to this:
Ok I turned that off and now it gives me the following error. Did I not set up my database right?
Server Error in '/' Application.
Keyword not supported: 'whsql-v04.prod.mesa1.secureserver.net;database'.
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentException: Keyword not supported: 'whsql-v04.prod.mesa1.secureserver.net;database'.
BB
Member
20 Points
4 Posts
What am I doing wrong?
Aug 14, 2006 02:51 PM|LINK
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
justin0501
Member
705 Points
138 Posts
Re: What am I doing wrong?
Aug 14, 2006 04:16 PM|LINK
Your first connection string works as it is for sql express which is intalled locally on your machine.
GoDaddy allows one database, unless you have purchased another. So the third set of connection strings seem correct:
<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" />
Basically when you setup the .net 2.0 schema for the users and roles go daddy puts everything in your DB_79394 database, and then I'm assuming you ran the classifieds sql scripts in that database as well.
Now, if you try and connect to that database from your local machine, you will get that error message. Go Daddy will not allow you to access their sql servers from a remote machine. So you will either need to use the sql express connection string when developing on your local machine and switch your connection strings when you upload the application to go daddy's server. Or you can develop the app, then upload it and test it that way which is time consuming
BB
Member
20 Points
4 Posts
Re: What am I doing wrong?
Aug 14, 2006 06:03 PM|LINK
I still get the error.aspx page with this connection string when I try to access online.
<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" />
Should I have not entered the classifieds-add.sql or the classifieds-categories.sql into the query analyser? What am I not doing right?
justin0501
Member
705 Points
138 Posts
Re: What am I doing wrong?
Aug 14, 2006 06:11 PM|LINK
You are right by running those sql scripts, but can you post the actual error message you are getting?You may need to change your custom errors tag in your web.config to this:
<customErrors mode="Off"/>
BB
Member
20 Points
4 Posts
Re: What am I doing wrong?
Aug 15, 2006 12:46 AM|LINK
Ok I turned that off and now it gives me the following error. Did I not set up my database right?
Server Error in '/' Application.
Keyword not supported: 'whsql-v04.prod.mesa1.secureserver.net;database'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentException: Keyword not supported: 'whsql-v04.prod.mesa1.secureserver.net;database'.
Source Error:
Source File: App_Code.bmauaqv3.11.vb Line: 1470
Stack Trace:
justin0501
Member
705 Points
138 Posts
Re: What am I doing wrong?
Aug 15, 2006 02:08 AM|LINK
I missed this before but it looks like you have a typo in your connection string. Currently you have:
<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" />
The ClassifiedsConnection is missing the Server keyword. It should look like:
<add name="classifiedsConnection" 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" />
Give that a try and let me know
BB
Member
20 Points
4 Posts
Re: What am I doing wrong?
Aug 15, 2006 02:41 AM|LINK
I can't thank you enough! That works! I can't login as the administrator but I saw other postings on this topic. I will trouble shoot first.
Thanks for all the help,
BB