CodeVerge.Net Beta


   Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums




Can Reply:  No Members Can Edit: No Online: Yes
Zone: > Asp.Net Forum > starter_kits_and_source_projects.personal_site_starter_kit Tags:
Item Type: Date Entered: 12/29/2005 7:25:53 AM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
NR
XPoints: N/A Replies: 1 Views: 26 Favorited: 0 Favorite
2 Items, 1 Pages 1 |< << Go >> >|
"byager" <>
NewsGroup User
How to: move Personal Site from local SQL Express to production SQL Server 200512/29/2005 7:25:53 AM

0

It took a lot of hacking, but I can sum it up fairly easy by following these steps (which I mostly got from the CrystalTech forums and Google):

  • Test and make sure your Starter Kit works properly on your local machine.  This will help us with troubleshooting later.
  • Configure ASP.NET 2.0 Application Services to use SQL Server 2000 or SQL Server 2005 (perfect blog with detailed instructions at http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx).   Make sure to run this against your newly set up SQL 2005 database, as this step replaces the database (ASPNETDB.MDF) that came with your Starter Kit.  Technically it doesn't replace your database, but SQL Server 2000 is referenced instead.  NOTE:  this will place ~20M data into your new database (not good for those of us on the developer plans with small amounts of available server space).
  • Make sure to use MorningZ's suggestion and create the necessary Personal Web Starter Kit tables in your database (http://www.microsoft.com/downloads/details.aspx?FamilyId=2EE85ED4-7613-47E2-8375-17222B150E4F&displaylang=en).  This is the same thing as the database your Starter Kit came with (Personal.MDF).
  • Make some changes in the web.config to accomodate the new database settings.  I made the following changes, but can't promise that it will work the same for you:
    <connectionStrings>
      <add name="Personal" connectionString="Server=[servername];Database=[Database name];User ID=[UserID];Password=[Password];Trusted_Connection=False" />
      <remove name="LocalSqlServer"/>
      <add name="LocalSqlServer" connectionString="Server=[servername];Database=[Database name];User ID=[UserID];Password=[Password];Trusted_Connection=False" />
    </connectionStrings>
    Make sure to replace the brackets and names with values specific to your account; i.e., [servername] for me is SQLB1.webcontrolcenter.com.  Replace [UserID] with your user id, [Password] with your password, and so on.  Yes, it's secure ...
  • And I don't know if I had to do this, but did because I read I was supposed to.  I added a <membership> section to the <system.web> section, right underneath </authorization>.
    <membership defaultProvider="SqlProvider" userIsOnlineTimeWindow="15">
      <providers>
      <clear />
      <add
        name="SqlProvider"
        type="System.Web.Security.SqlMembershipProvider"
        connectionStringName="[connection string name]"
        applicationName="[application name]"
        enablePasswordRetrieval="false"
        enablePasswordReset="true"
        requiresQuestionAndAnswer="true"
        requiresUniqueEmail="true"
        passwordFormat="Hashed" />
      </providers>
    </membership>

    For <connectionstringname> I used LocalSqlServer from above.  Just type in "LocalSqlServer".
  • Publish your *working* Starter Kit (from Visual Studio, Build then Publish) - i.e., it's been tested and runs on your local machine - to your CrystalTech IP address and subdirectory (if applicable).

  • I'm still making tweaks and have come across miscellaneous errors, like directory not found (just create a new one) and stored procedure not found (just republish the solution) ... but at least it's working!Smile [:)]Good luck ... and have fun!
    Brent
    http://www.solvix.com/portal (working site)

"pashaKasim" <>
NewsGroup User
Re: How to: move Personal Site from local SQL Express to production SQL Server 20051/20/2006 3:26:54 PM

0

I did create all the tables and stored proc's on sql 2000. How can I populate my new tables with Personal.mdf data, so I can run my starter kit.

Thank You.

2 Items, 1 Pages 1 |< << Go >> >|


Free Download:













publishing problems

extending the personal web site starter kit

help in using fckeditor

simple chat ?

how do you change "your name here" ?

database schema version

newbie: how to classify links (sitemap)

a little fun with the personal site starter kit. ...

aspnet.mdf read only issue & sseutil

css: has anyone managed to add content to the left hand side of masterpage?

please find out the solution for this error

could not find a non-generic method 'removephoto' that has parameters: original_photoid, photoid

photos do not appear from database - even for asp.net's live demonstration!

sourcecode request.. administratring users on remote website?

can't use webadmin.axd

local install

wow i am clever. got to it to work

error when running pss application.

a comprehensive rating system using asp.net 2.0

ms sql database connection problem!

setting up starter kit on remote server connection string problem

personal website starter kit - problem regarding its databases

help needed with customizing psk...

adding comments to photo album site

image sizes in albums

login code

update it or take it down

personal site and sql2000

extending the notes fields

performance on home page - random image

ie beta reports site as a phishing web site

localized version (now support for polish language)

personal starter kit for ms access

compiler error message: bc30451: name 'sitemap' is not declared.

web.config file question

logging in error

page does not refresh on login/logout

event calendar control

can't run pssk with sql server 2005

how to: unique head (meta, scripts) on .aspx pages

create account button and format document

trouble moving site to iis on same local machine

personal starter kit - localhost running - hosting server error

iis5 and sql express

guestbook or any other tab/link made invisible unless logged in?

need help with connection string

login problem w/ ms access version

deployment of the databases

problems with database security settings

strange error

   
  Privacy | Contact Us
All Times Are GMT