This is the same problem that many of us have been having. I have a club site up and running on one of my domain names which are hosted by GoDaddy. Here's what I see.
The database connection is most likely this issue. In your web.config I see that the connection string is set for running on the local computer during the build phase. When you set up the hosting plan, make sure that you have the Deluxe Plan because it
provides 2 SQL Server DBs. Set them up on the site and name them. Remember the password for each. I copied all of the information to Word and printed it out so that I could remember it for later steps. When you are finished, you will see the databses click
on the edit button, (on the right near the delete button.) Chose configuration and look for the :SQL Connection .NET. This is the connection string you need to put into the web.config. There is one for each of the databases you set up. (I copied them to
the word file with the passwords so that I didn't confuse them.
Next, I followed
Scott Guthrie's Blog on the Database Publishing Wizard step by step. I saved the resultant .SQL files in /My Documents.
Next, I logged in at GoDaddy, and accessed the first database. I went to Query Manager found the .sql file "Club.mdf.sql" I uploaded it and then ran the query. I logged out of that database, and into the second one then found, uploaded and ran the ASPNET.MDF.sql
file. then I modified the web.config file with the proper connection string.
<connectionStrings>
<add name="ClubSiteDB" connectionString="Data Source=Your connection string from the first database [don't forget to put in the password];"/>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=Your connection string from the second database [don't forget to put in the password];"/>
You do not need to spend the extra money for deluxe hosting as you can merge both databases into one. Basically the one DB is the ASP.Net DB and the other is the classifieds or club (whichever). If you're using the SQL files instead of connecting directly
you just need to run that against the ASP.NET DB that should have installed when you selected ASP.NET 2.0 in your hosting account. The club SQL is setup for one DB anyway not 2. It's the classifieds that you had to merge the 2 DB into 1.
All my sites run on 1 DB not 2 and you can even run multiple sites out of the same DB if you don't have a lot of activity.
I'll be posting the .dll later today and will post the link.
Create your site locally. Include AT LEAST 1 local admin account.
Run site using CTRL-F5.
Log into your GoDaddy hosting account and open the control panel.
Click on ASP.Net runtime and select 2.0
Click Databases > SQL Server > Create New Database.
</div>
Select
Check DSN (optional?)
Enter UserName (this will become the database name NOT your hosting login)
Enter Password (again, database password NOT hosting password)
Check "Install Schema Features"
Click Continue > Create Database (it WILL take some time for the database to create itself, you can refresh by clicking the SQL button in the left menu)
Once setup finishes, Click Pencil icon under actions > print this page.
Click Computer icon under actions > record the SQL Connection (.NET) strings
Click Open Manager
Click Connection > Enter the Username and Password from 6 above.
Once connected, expand Tools menu > Click Query Analyzer
Cut & Paste all text from club-add.sql into the Query Analyzer window
Click Submit (you should see many "command(s) completed successfully" below)
Go back to VWD and edit default.aspx
Go to Edit > Find & Replace > Quick Replace
Find dbo. (NOT Dbo. big difference)
Replace with <blank> (nothing, nada, zip, zero)
Look in: Current Document
Click Replace All (should be 12 or more) > Save default.aspx
Run CTRL-F5 again. (it will bring up a window with a server error, what you want is to look in the lower left corner of the VWD window for "Build Successful")
Click Website > Copy Web Site > Connect
Input your hosting username and password (NOT you database uid and pwd)
Highlight all files from the left side and click right arrow to transfer.
Go to your public website and create an account for each admin you created on your local database. (make sure the usernames and passwords are the same!!!)
Log back into Query Analyzer
Input
SELECT RoleId FROM aspnet_Roles WHERE RoleName="Administrators"
Copy bracketed response into a text document and include the brackets
<div class=MsoNormal>Reset QA and Input</div>
SELECT UserId FROM aspnet_Users WHERE UserName="username"
Copy each bracketed response to your text document.
Reset QA again and Input
INSERT INTO aspnet_UsersInRoles (RoleId, UserID) VALUES ('copied text from 29', 'copied text from 31')
badfire2625
0 Points
1 Post
Re: GoDaddy
Feb 16, 2008 03:40 PM|LINK
Did you get the answer to your post yet?
If not:
This is the same problem that many of us have been having. I have a club site up and running on one of my domain names which are hosted by GoDaddy. Here's what I see.
The database connection is most likely this issue. In your web.config I see that the connection string is set for running on the local computer during the build phase. When you set up the hosting plan, make sure that you have the Deluxe Plan because it provides 2 SQL Server DBs. Set them up on the site and name them. Remember the password for each. I copied all of the information to Word and printed it out so that I could remember it for later steps. When you are finished, you will see the databses click on the edit button, (on the right near the delete button.) Chose configuration and look for the :SQL Connection .NET. This is the connection string you need to put into the web.config. There is one for each of the databases you set up. (I copied them to the word file with the passwords so that I didn't confuse them.
Next, I followed Scott Guthrie's Blog on the Database Publishing Wizard step by step. I saved the resultant .SQL files in /My Documents.
Next, I logged in at GoDaddy, and accessed the first database. I went to Query Manager found the .sql file "Club.mdf.sql" I uploaded it and then ran the query. I logged out of that database, and into the second one then found, uploaded and ran the ASPNET.MDF.sql file. then I modified the web.config file with the proper connection string.
<connectionStrings>
<add name="ClubSiteDB" connectionString="Data Source=Your connection string from the first database [don't forget to put in the password];"/>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=Your connection string from the second database [don't forget to put in the password];"/>
</connectionStrings>
Fire it up and it should work
Here is the temporary link to the one I just got working. http://www.the-elias-family.com/
MarValUS
Member
74 Points
29 Posts
Re: GoDaddy
Feb 16, 2008 05:46 PM|LINK
You do not need to spend the extra money for deluxe hosting as you can merge both databases into one. Basically the one DB is the ASP.Net DB and the other is the classifieds or club (whichever). If you're using the SQL files instead of connecting directly you just need to run that against the ASP.NET DB that should have installed when you selected ASP.NET 2.0 in your hosting account. The club SQL is setup for one DB anyway not 2. It's the classifieds that you had to merge the 2 DB into 1.
All my sites run on 1 DB not 2 and you can even run multiple sites out of the same DB if you don't have a lot of activity.
I'll be posting the .dll later today and will post the link.
Hosting Club Starter Kit classifieds DB
mm17498
Member
30 Points
27 Posts
Re: GoDaddy
Feb 18, 2008 12:28 AM|LINK
Hi I would appreciate you posting your rebuilt dll soon, I am in bind. Thanks.
CLUB Starter Kit 3.0
Teacher
MarValUS
Member
74 Points
29 Posts
Re: GoDaddy
Feb 18, 2008 01:48 AM|LINK
Sorry, it's been a crazy weekend.
Here's the link the the recompiled dll along with instructions on what to do with it.
http://www.marvalus-domains-hosting.com/Club-Site-Starter-Kit/Downloads/Club-Site-Medium-Trust.aspx
Good luck and let us know.
club Starter Kit medium trust
mm17498
Member
30 Points
27 Posts
Re: GoDaddy
Feb 18, 2008 02:03 AM|LINK
Hi MarValUS
Something's wrong in your zipped file, it says Nothing to Extract when I try. Please upload again. Thanks
Teacher
MarValUS
Member
74 Points
29 Posts
Re: GoDaddy
Feb 18, 2008 02:13 AM|LINK
It's good now - sorry for not having anything in the zip file.
club Starter Kit medium trust
riscfl
Member
4 Points
6 Posts
Re: GoDaddy
May 13, 2008 07:43 PM|LINK
MarValUs,
Thanks for posting the updated DLL. It fixed my issues with getting CSK 3.0b1 up and running on Network Solutions.
MarValUS
Member
74 Points
29 Posts
Re: GoDaddy
May 14, 2008 04:01 AM|LINK
You're welcome! Glad it helped you out! If I can help you with anything else, just let me know.MarValUS-Domains-Hosting medium trust club Starter Kit medium trust
phamster
Member
107 Points
342 Posts
Re: GoDaddy
May 27, 2008 12:29 AM|LINK
Try this from scratch:
<div mce_keep="true">- Create your site locally. Include AT LEAST 1 local admin account.
- Run site using CTRL-F5.
- Log into your GoDaddy hosting account and open the control panel.
- Click on ASP.Net runtime and select 2.0
- Click Databases > SQL Server > Create New Database.
</div><add name="ClubSiteDB" connectionString="Data Source=.\SQLExpress;
Integrated Security=true;
AttachDBFileName=|DataDirectory|Club.mdf;
User Instance=True" providerName="System.Data.SqlClient"/>
With new text
<add name="ClubSiteDB" providerName="System.Data.SqlClient"
connectionString="server=whsql-v04.prod.mesa1.secureserver.net;
database=DB_12345;
uid=myusername;
pwd=mypassword"/>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" providerName="System.Data.SqlClient"
connectionString="server=whsql-v04.prod.mesa1.secureserver.net;
database=DB_12345;
uid=myusername;
pwd=mypassword"/>
Change <customErrors mode="Off" /> (optional)
Save!!!
Run CTRL-F5 again. (it will bring up a window with a server error, what you want is to look in the lower left corner of the VWD window for "Build Successful")
Click Website > Copy Web Site > Connect
Input your hosting username and password (NOT you database uid and pwd)
Highlight all files from the left side and click right arrow to transfer.
Go to your public website and create an account for each admin you created on your local database. (make sure the usernames and passwords are the same!!!)
Log back into Query Analyzer
Input
SELECT RoleId FROM aspnet_Roles WHERE RoleName="Administrators"
Copy bracketed response into a text document and include the brackets
SELECT UserId FROM aspnet_Users WHERE UserName="username"
Copy each bracketed response to your text document.
Reset QA again and Input
INSERT INTO aspnet_UsersInRoles (RoleId, UserID) VALUES ('copied text from 29', 'copied text from 31')
Repeat 28-32 for each admin account.