I am going to answer myself here

What I had forgotten to do was to Rebuild the website locally, with the web.config file modified to suit the GoDaddy database information ie:

Server=p3swhsql-v02.shr.phx3.secureserver.net; ....etc

and then upload the files to GoDaddy.

At this point in time - I am quite amazed to say - everything I have checked so far is working except that I cannot login using the administrator role which I created locally earlier.
 

After the rebuild do you have to do anything other than ftp the files to Godaddy?

 Thank,

CK
 

Here is my working web.cong.  Here are the steps I followed on Go Daddy

1. First, get a copy of the Go Daddy Walkthrough post on this site
2.  Create your DB on Go Daddy using their SQL tool.  Note the user name and password you use to create teh DB
3.  Using the create scripts in the CSK, create your table, sp's, etc. changing the dbo ownership in the scripts to the ID you used to create your DB on Go Daddy.
4.  Use the Go Daddy Walk Through to add your Admin ID
5.  Modify your web.config to use the proper Go Daddy server, etc.
6.  Post your site.  I used VWD and just FTP'd it up.

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

<system.web>

<allow roles="Administrators"/>

</authorization>

</location>

<system.web>

<allow roles="Administrators"/>

</authorization>

</location>

<system.web>

<allow roles="Administrators"/>

</authorization>

</location>

<system.web>

<allow roles="Administrators"/>

</authorization>

</location>

<system.web>

<deny users="?"/>

</system.web>

<location path="member_details.aspx">

<authorization>

</authorization>

</location>

<location path="forum_manage.aspx">

<authorization>

<deny users="*"/>

</system.web>

<location path="forum_editpost.aspx">

<authorization>

<deny users="*"/>

</system.web>

<location path="forum_addpost.aspx">

<authorization>

</authorization>

</location>

<system.web>

<allow roles="Administrators"/>

</authorization>

</location>

<system.web>

<allow roles="Administrators"/>

</authorization>

</location>

<system.web>

<allow roles="Administrators"/>

</authorization>

</location>

<system.web>

<deny users="?"/>

</system.web>

<connectionStrings>

<remove name="LocalSqlServer"/>

</connectionStrings>

<roleManager enabled="true"/>

<compilation debug="true" strict="true">

<add assembly="System.Xml, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

<add assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>

</compilation>

<siteMap defaultProvider="AspNetXmlSiteMapProvider" enabled="true">

<remove name="AspNetXmlSiteMapProvider"/>

</providers>

<customErrors mode="Off" defaultRedirect="ErrorPage.htm"/>

</system.web>

<defaultProxy>

</defaultProxy>

<system.net>

<smtp deliveryMethod="network" from=XXXXXXXXX@XXXXXXXXXX.XXX>

<network

host="relay-hosting.secureserver.net"

port="25"

defaultCredentials="true"

</mailSettings>

<appSettings>

</appSettings>

</configuration>

I"m having trouble launching my site locally as well as accesing the asp.net applications. here's a copy of my web.config. Does godaddy.com allow remote access or not?

thanks,

jay0555

<add name="ClubSiteDB" providerName="System.Data.SqlClient"

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" providerName="System.Data.SqlClient"

</connectionStrings>

No GoDaddy doesn't allow remote access.  To run your site locally you have to change your connection string to connect to your local DB.  To look at/ connect to your live DB you have to use their DB manager tool.  I wish they would chage to allow remote access, it would be a lot easier but also more chance of the DB getting hacked.

ok, how do i connect to my remote database. i'm getting this error:

Line 4: 
Line 5:  void Application_Start(object sender, EventArgs e) {
Line 6:  if (!Roles.RoleExists("Administrators")) Roles.CreateRole("Administrators");
Line 7:  }
Line 8:  

here's my local connection code:

i meant to say, how do i connnect to my local database.

Line 4: 
Line 5:  void Application_Start(object sender, EventArgs e) {
Line 6:  if (!Roles.RoleExists("Administrators")) Roles.CreateRole("Administrators");
Line 7:  }
Line 8:  

here's my local connection code:

Jay,

The connections sometimes are enough to drive you nuts, hope the below info helps. 

Good Luck.

Hi guys

I have a GoDaddy hosting as well. I have set up my ASPNETDB database but my connection string is not working as far as I can tell.

From reading this thread I see that I should NOT use database name but an ID instead? And how important it is to have Trusted_Connection=False or Integrated Security=True in connection string?

I just can't understand why can't this database deployment be simpler?  

Thanks 

*Edit: I went to my database manager and I see that my database doesn't have an ID but only name.

I have no idea why isn't this working !!!!! @#$@#$$$%%^@@#$ !!!!! 

Having Trusted_Connection=False is optional but it won't hurt. But DO NOT have "Integrated Security=True" - that will ensure your connection won't work.

Post your error message so that we can trouble-sho