Personal Site Start Kit Installation Process - Summary

Hello, I'm seeing so many different solutions for various problems, which is understandable. However, could someone please list the general process to create and publish the Personal Site Starter Kit using Visual Studio Web Developer 2005 Express and SQL 2005 Express? My thoughts: 1) Download and install Visual Studio Web Developer Express and SQL 2005 Express. 2) Create website in C:\Documents and Settings\DevAccount\My Documents\Visual Studio 2005\WebSites\ 3) Test website on local host to verify it is working correctly. 4) Download Photo Album database SQL file from: http://www.microsoft.com/downloads/details.aspx?FamilyId=2EE85ED4-7613-47E2-8375-17222B150E4F&displaylang=en 5) Run: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50215\aspnet_regsql.exe for ASPNETDB to create the users database. 6) Use SQL Enterprise Manager to turn the ASPNETDB database into a SQL script. 7) Combine ASPNETDB SQL script and Personal-add into one SQL file. 8) Create a database on host web site (I only have access to one MS SQL database). Within the host database, execute the combined SQL files (from aspnetdb and personals-add). This should create all necessary tables, stored procedures, etc. for the Personal Site Starter Kit. 9) Modify web.config file to use the newly created database on the host server. 10) Use Visual Studio Web Developer Express to "Copy Site" to host FTP site. Could someone please comment on this plan? Is there anything I'm forgetting? Any suggestions/hints? Thanks! Cody

Re: Personal Site Start Kit Installation Process - Summary

Ok. I've made quite a bit of progress I think. Website and database is uploaded; however, the Stored Procedures apparently did not upload to the host database. How should I go about transferring the remote procedures? Thanks! Cody

Re: Personal Site Start Kit Installation Process - Summary

Ah ha,

The website is working now-- http://www.codydecker.com and the Photo Album stored procedures are copied over; however, the stored procedures for the administration (aspnetdb I assume) are not there. The tables for aspnetdb are present, however.

Any suggestions?

Thanks!
Cody

Re: Personal Site Start Kit Installation Process - Summary

Hi cody,

Would it be possible for you to share the SQLscript file you generated so I too can create the SQL tables on my hosted server.

I don't have all the components installed so basically I am working totally from a remote perspective.

Re: Personal Site Start Kit Installation Process - Summary

Hi cody,

Yes, i agree, can you share the SQL script file you generated so I can create the SQL tables as well??

Thanks
Undie

Re: Personal Site Start Kit Installation Process - Summary

Hi Cody.

Did you have to make any changes to your web.config beyond the database connection settings?

Also were you able to set it on your root web folder or did you have to set it on a subdirectory.

I have modified the site on my local machine to use the remote hosted database and it works fine, I can manage the roles,users and
perform the management functions localy and they are applied to my hosted database.

I publish the site using the copy site function in VS2005 to my root folder and try to view the site, I get an error.

<code>

Server Error in '/personal' Application.

Runtime Error

Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".

</code>

It as though the web.config file is being rejected, I changed the settings for the debug mode to "Off" and set the trace to "true"

Just wondering if this is a host issue as opposed to a problem with the site.

Re: Personal Site Start Kit Installation Process - Summary

Hi Cody,

Did you have to make any changes to the web.config file beyond the database connection settings?

I have it working on a local copy that is pointing to the hosted sql database but when I publish it I keep getting the dreader
application error.

I tried publishing it to the root dir and also to a subdirectory, I am at a loss as to why it will not work.

Is there an issue of compatability here in so far as the web.config file is concerned?

Re: Personal Site Start Kit Installation Process - Summary

Well I got it up and running,

The initial release is viewable at www.angeloabruzzese.com/personal/default.aspx

Re: Personal Site Start Kit Installation Process - Summary

Can any friend help us by giving us the generated SQL scripts for both aspnetdb and personal starter kit.

Have you merged both in one and then uploaded. I request a good script so that others can start working too.

A full solution for immediate start is welcome, since enough time is spend on discovery, without any solution. This solution will help us in other projects too.

Pl. help us with solutions not just suggestions, as suggestions takes more time without a result.

thanks

Re: Personal Site Start Kit Installation Process - Summary

Just found these files:
Directory of C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

09/23/2005 07:28 AM            24,603 InstallCommon.sql
09/23/2005 07:28 AM            55,833 InstallMembership.sql
09/23/2005 07:28 AM            52,339 InstallPersistSqlState.sql
09/23/2005 07:28 AM            34,950 InstallPersonalization.sql
09/23/2005 07:28 AM            20,891 InstallProfile.SQL
09/23/2005 07:28 AM            34,264 InstallRoles.sql
09/23/2005 07:28 AM            52,123 InstallSqlState.sql
09/23/2005 07:28 AM            53,895 InstallSqlStateTemplate.sql
09/23/2005 07:28 AM             6,457 InstallWebEventSqlProvider.sql

The first 6 files may well be what you are looking for.