I would be really grateful to anyone who can provide some assistance as to how to successfully upload a Personal Website Starter Kit to a remote ISP's Server.
I can create the website on my local computer successfully, I have followed all the setup instructions I can find on the MS help topics, but when I copy the files across to my ISP's hosting server things go wrong.
I do not seem to be able to access any of the web pages, and I get the following error -
Server Error in '/' Application.
Runtime Error
This is not particularly helpful, and nor have my ISP been either. I have no idea why I am getting this error, and I am unable to access any of the pages within the website.
The files are within the root folder of my hosting website.
I have trawled through the MS support site, and googled my problem, but do not seem to be able to find the answers.
Thank you for responding to my note, unfortunately I am encountering a number of problems and inconsistencies when trying to follow the instructions in the tutorial. If you have the time I would be grateful for some additional information to help me.
In Step 2 - There is only an installation script for the Personal.MDF database, what about the ASPNETDB.MDF? My ISP advised that only Microsft Access DB's can run within local folders on in the root directory. Does this mean another SQL database needs to
be created on the ISP's server?
In Step 3 - I am not sure how to create the Connection Script to my ISP's DB server. My Web.config file looks different to the example you provide.
My ISP gave me the following information for connection, but I am not sure of the correct syntax for accessing it.
Look for my post in this thread: http://forums.asp.net/thread/1223717.aspx it will tell you how to generate the script for the aspnetdb database objects. Both the personal and the aspnetdb should be combined into one database,
the scripts for both will do this if you run them against a single database. Your connection string should look something like this frow what info you gave, you will have to change the user id and password to what your ISP gave you.
Step 4: these two lines not right next to each other. Sorry if I confuse you. just comment it out when you see it. Please leave the XmlSiteMapProvider the way it is.
Thanks for your help. I have managed to import the SQL scripts to the SQL server of my ISP. I now have a single database which combines both the Personal.mdf and the ASPNETDB.MDF.
I am now able to access the pages on the web, but find I am getting the following error.
Server Error in '/' Application.
Configuration Error
Description:
An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Default Membership Provider could not be found.
Source Error:
Line 18: <globalization requestEncoding="utf-8" responseEncoding="utf-8"/>
Line 19: <roleManager enabled="true"/>
Line 20: <membership defaultProvider="AspNetSqlMembershipProvder"/>
Line 21: <siteMap defaultProvider="XmlSiteMapProvider" enabled="true">
Line 22: <providers>
\web\content\web.config Line:
20
</div>
Also now that the ASPNETDB database is on the remote server, how do I administer it. I don't have myself set up as an Administrator in the Database and therefore cannot
"Log In" to the Website.
My ISP provides a control panel for administering your databases, but I have no idea how you go about adding data to them.
I can view most of the pages, but I cannot log into the website for full access (i.e. upload Albums etc).
I tried to create a SQL connection (as in Step 5) to the database on my ISP's SQL, but I don't seem to to be able to do this from my local PC.
Apparently the only way to access the database server is via their provided Web Control Panel. I don't know how to create an initial administrator user in the database without using the ASP.NET configurator web application provided with Visual Studio.
Does this mean I need to import the user data into the remote database?
Without that initial Admin user, I can't log in to the site for full access and administer the user accounts.
That means you double click aspnet_regsql.exe file from your computer C drive on path C:\WINDOWS\Microsoft.NET\Framework\
v2.0.50727\aspnet_regsql.exe the version number most likekly is
v2.0.50727
you will see a pop up window asked for information. enter your remote sql server address, database name, user name and password as prompt.
adamstoc
Member
40 Points
8 Posts
Problems uploading Personal Website Starter Kit to Remote Server
May 02, 2006 04:09 PM|LINK
Hi,
I would be really grateful to anyone who can provide some assistance as to how to successfully upload a Personal Website Starter Kit to a remote ISP's Server.
I can create the website on my local computer successfully, I have followed all the setup instructions I can find on the MS help topics, but when I copy the files across to my ISP's hosting server things go wrong.
I do not seem to be able to access any of the web pages, and I get the following error -
Server Error in '/' Application.
Runtime Error
This is not particularly helpful, and nor have my ISP been either. I have no idea why I am getting this error, and I am unable to access any of the pages within the website.
The files are within the root folder of my hosting website.
I have trawled through the MS support site, and googled my problem, but do not seem to be able to find the answers.
Any help is greatfully appreciated.
Regards,
Adam S
suegooge
Participant
1180 Points
235 Posts
Re: Problems uploading Personal Website Starter Kit to Remote Server
May 02, 2006 05:41 PM|LINK
there were plenty threads regarding this issue. Or you can check out the step by step tutorial in my blog
http://www.edream.org/BlogArticle.aspx?RecordID=115
adamstoc
Member
40 Points
8 Posts
Re: Problems uploading Personal Website Starter Kit to Remote Server
May 03, 2006 11:32 AM|LINK
Hi Sue,
Thank you for responding to my note, unfortunately I am encountering a number of problems and inconsistencies when trying to follow the instructions in the tutorial. If you have the time I would be grateful for some additional information to help me.
In Step 2 - There is only an installation script for the Personal.MDF database, what about the ASPNETDB.MDF? My ISP advised that only Microsft Access DB's can run within local folders on in the root directory. Does this mean another SQL database needs to be created on the ISP's server?
In Step 3 - I am not sure how to create the Connection Script to my ISP's DB server. My Web.config file looks different to the example you provide.
My ISP gave me the following information for connection, but I am not sure of the correct syntax for accessing it.
Server: ATLAS-SQL-02
Database: burrenviewcom_25194_db1
<
connectionStrings><
add name="Personal" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Personal.mdf" providerName="System.Data.SqlClient" /><
remove name="LocalSqlServer"/><
add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf" /></
connectionStrings>In Step 4 - My Web.config file looks different
<roleManager enabled="true"/>
<siteMap defaultProvider="XmlSiteMapProvider" enabled="true">
<providers>
<add name="XmlSiteMapProvider"
description="SiteMap provider which reads in .sitemap XML files."
type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
siteMapFile="web.sitemap"
securityTrimmingEnabled="true"/>
</providers>
I appreciate any help you can give!
Regards,
Adam S
whighfield
Star
11721 Points
1859 Posts
Re: Problems uploading Personal Website Starter Kit to Remote Server
May 04, 2006 02:56 AM|LINK
Look for my post in this thread: http://forums.asp.net/thread/1223717.aspx it will tell you how to generate the script for the aspnetdb database objects. Both the personal and the aspnetdb should be combined into one database, the scripts for both will do this if you run them against a single database. Your connection string should look something like this frow what info you gave, you will have to change the user id and password to what your ISP gave you.
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=ATLAS-SQL-02;Initial Catalog=burrenviewcom_25194_db1;User ID=<YOUR_USER_ID>;Password=<YOUR_PASSWORD>;database=burrenviewcom_25194_db1"/>
</connectionStrings>
Hope this helps some
Blog | I need more space:DropBox Referral
suegooge
Participant
1180 Points
235 Posts
Re: Problems uploading Personal Website Starter Kit to Remote Server
May 04, 2006 12:18 PM|LINK
adamstoc ,
Step 5: will take care of aspnetdb.mdf creatation.
Step 3: Just get rid of the conenction string in your web.config, replace with the string provided by Will or by me.
These lines should be gone:
<connectionStrings>
<add name="Personal" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Personal.mdf" providerName="System.Data.SqlClient" /> <remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf" /> </connectionStrings>
Replace with and update the username and password provided by your host.
<connectionStrings>
<add name="Personal" connectionString="Data Source=ATLAS-SQL-02;Initial Catalog=burrenviewcom_25194_db1;Persist Security Info=True;UID=UserName;PWD=PassWord" providerName="System.Data.SqlClient" />
</connectionStrings>
Step 4: these two lines not right next to each other. Sorry if I confuse you. just comment it out when you see it. Please leave the XmlSiteMapProvider the way it is.
<roleManager enabled="true"/>
<membership defaultProvider="AspNetSqlMembershipProvider"/>
Hope this helps
Sue
adamstoc
Member
40 Points
8 Posts
Re: Problems uploading Personal Website Starter Kit to Remote Server
May 04, 2006 01:17 PM|LINK
Hi Sue/Will,
Thanks for your help. I have managed to import the SQL scripts to the SQL server of my ISP. I now have a single database which combines both the Personal.mdf and the ASPNETDB.MDF.
My Web.config file now looks like this.
<div class=Section1>
<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=ATLAS-SQL-02;Initial Catalog=burrenviewcom_25194_db1;Persist Security Info=True;UID=<UID>;PWD=<PWD>" providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>
<pages styleSheetTheme="White"/>
<customErrors mode="Off"/>
<compilation debug="true"/>
<authentication mode="Forms">
<forms loginUrl="Default2.aspx" protection="Validation" timeout="300" />
</authentication>
<authorization>
<allow users="*"/>
</authorization>
<globalization requestEncoding="utf-8" responseEncoding="utf-8"/>
<roleManager enabled="true"/>
<membership defaultProvider="AspNetSqlMembershipProvder"/>
<siteMap defaultProvider="XmlSiteMapProvider" enabled="true">
<providers>
<add name="XmlSiteMapProvider"
description="SiteMap provider which reads in .sitemap XML files."
type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
siteMapFile="web.sitemap"
securityTrimmingEnabled="true"/>
</providers>
</siteMap>
</system.web>
<location path="Admin">
<system.web>
<authorization>
<allow roles="Administrators"/>
<deny users="*"/>
</authorization>
</system.web>
</location>
</configuration>
I am now able to access the pages on the web, but find I am getting the following error.
Server Error in '/' Application.
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Default Membership Provider could not be found.
Source Error:
\web\content\web.config Line: 20
</div>Also now that the ASPNETDB database is on the remote server, how do I administer it. I don't have myself set up as an Administrator in the Database and therefore cannot "Log In" to the Website.
My ISP provides a control panel for administering your databases, but I have no idea how you go about adding data to them.
Regards,
Adam S
suegooge
Participant
1180 Points
235 Posts
Re: Problems uploading Personal Website Starter Kit to Remote Server
May 04, 2006 01:27 PM|LINK
You miss step 4 :-)
http://www.edream.org/BlogArticle.aspx?RecordID=115
adamstoc
Member
40 Points
8 Posts
Re: Problems uploading Personal Website Starter Kit to Remote Server
May 04, 2006 03:18 PM|LINK
Ok Sue,
Step 4 completed!
I'm close now...I can almost taste success!
I can view most of the pages, but I cannot log into the website for full access (i.e. upload Albums etc).
I tried to create a SQL connection (as in Step 5) to the database on my ISP's SQL, but I don't seem to to be able to do this from my local PC.
Apparently the only way to access the database server is via their provided Web Control Panel. I don't know how to create an initial administrator user in the database without using the ASP.NET configurator web application provided with Visual Studio.
Does this mean I need to import the user data into the remote database?
Without that initial Admin user, I can't log in to the site for full access and administer the user accounts.
Adam S [:)]
Abe
Member
10 Points
2 Posts
Re: Problems uploading Personal Website Starter Kit to Remote Server
May 05, 2006 01:02 AM|LINK
Hi, Sue
I have been following your guide and article regarding problems with connecting to remote server
I have made the necessary changes to web.config , I think I have done it right but I am not sure,
now the last thing I need to do is to have Preconfigured my SQL Server Provider,
you have mentioned under step 5 to how to find
remote sql server address, user name, password and database name .
Run aspnet_regsql.exe from this location
C:\WINDOWS\Microsoft.NET\Framework\<versionNumber>\aspnet_regsql.exe
but I am not sure how to follow this link
thanks for your help
suegooge
Participant
1180 Points
235 Posts
Re: Problems uploading Personal Website Starter Kit to Remote Server
May 05, 2006 02:03 AM|LINK
Abe,
That means you double click aspnet_regsql.exe file from your computer C drive on path C:\WINDOWS\Microsoft.NET\Framework\ v2.0.50727\aspnet_regsql.exe the version number most likekly is v2.0.50727
you will see a pop up window asked for information. enter your remote sql server address, database name, user name and password as prompt.
Hope this helps
Sue