Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post May 27, 2008 12:29 AM by phamster
Feb 16, 2008 03:40 PM|LINK
Did you get the answer to your post yet?
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.
<add name="ClubSiteDB" connectionString="Data Source=Your connection string from the first database [don't forget to put in the password];"/>
<add name="LocalSqlServer" connectionString="Data Source=Your connection string from the second database [don't forget to put in the password];"/>
Fire it up and it should work
Here is the temporary link to the one I just got working.
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.
Club Starter Kit
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
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.
Good luck and let us know.
club Starter Kit medium trust
Feb 18, 2008 02:03 AM|LINK
Something's wrong in your zipped file, it says Nothing to Extract when I try. Please upload again. Thanks
Feb 18, 2008 02:13 AM|LINK
It's good now - sorry for not having anything in the zip file.
May 13, 2008 07:43 PM|LINK
Thanks for posting the updated DLL. It fixed my issues with getting CSK 3.0b1 up and running on Network Solutions.
May 14, 2008 04:01 AM|LINK
club Starter Kit medium trust
May 27, 2008 12:29 AM|LINK
Try this from scratch:
With new text
Change <customErrors mode="Off" /> (optional)
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
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.