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
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
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.
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.
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
Paggy4u
-----------------------------------------
Working with Dynamic Languages
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.
codydecker
Member
105 Points
21 Posts
Personal Site Start Kit Installation Process - Summary
Oct 16, 2005 11:03 PM|LINK
codydecker
Member
105 Points
21 Posts
Re: Personal Site Start Kit Installation Process - Summary
Oct 17, 2005 01:49 AM|LINK
codydecker
Member
105 Points
21 Posts
Re: Personal Site Start Kit Installation Process - Summary
Oct 17, 2005 02:56 AM|LINK
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
aabruzzese
Contributor
2806 Points
759 Posts
Re: Personal Site Start Kit Installation Process - Summary
Oct 17, 2005 01:29 PM|LINK
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.
junderwood
Member
5 Points
1 Post
Re: Personal Site Start Kit Installation Process - Summary
Oct 19, 2005 08:07 PM|LINK
Yes, i agree, can you share the SQL script file you generated so I can create the SQL tables as well??
Thanks
Undie
aabruzzese
Contributor
2806 Points
759 Posts
Re: Personal Site Start Kit Installation Process - Summary
Oct 21, 2005 01:39 PM|LINK
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.
aabruzzese
Contributor
2806 Points
759 Posts
Re: Personal Site Start Kit Installation Process - Summary
Oct 21, 2005 05:33 PM|LINK
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?
aabruzzese
Contributor
2806 Points
759 Posts
Re: Personal Site Start Kit Installation Process - Summary
Oct 22, 2005 04:02 PM|LINK
The initial release is viewable at www.angeloabruzzese.com/personal/default.aspx
paggy4u
Contributor
3017 Points
774 Posts
Re: Personal Site Start Kit Installation Process - Summary
Oct 29, 2005 10:07 AM|LINK
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
-----------------------------------------
Working with Dynamic Languages
joseas
Member
11 Points
6 Posts
Re: Personal Site Start Kit Installation Process - Summary
Oct 29, 2005 05:07 PM|LINK
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.