I would like to use the membership feature of VWD2005 and it works great in debug mode. The problem is after I upload my website by FTP to the server It won't work. Can someone please tell me what files are required to save all of the membership data so
that I can get this to work?
I also would like to know how to add variables to any user like a score on my site. For example, every time you play a game on my site you could get 3 points to your username that could let you acess more games. How do you do this?
You'll need to explain what doesn't work means. For the second question, wher eare you having trouble with doing this? Adding the field in the database? Accessing it?
it comes up with an error message. I dont know what it means. it says there is a "problem on the server." what files are required because I may just not be uploading what it needs.
It works in debug mode but once I try to login actually on my website it fails. It tells me there was an "error on the server" and then lectures me on how to create a custom error page. I'm sorry, that is all it tells me.
Although it does work in debug mode so I would assume it can't find a file because I didn't upload it...
This all that it tells me. It says it would tell you the complete error message on the local computer but when I just click debug it works and an error message doesn't show up!
Server Error in '/' 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".
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
Actually, it tells you to set customErrors mode="Off" to see the error on a remote machine. Which I'm assuming you would have mentioned if you had done this. I'm also assuming that when I said to check the ASP.NET version you also didn't do that since
you don't mention that either.
We'll work with you to help get you past this error, but we can't do that without your help.
I'm sorry I took a while to get back to you on this. I have been trying to find where you can change the custom errors mode to off and I can't in their configurator page or by just editing the page.
Where do you want the vcersion checked? On my website or in my software? The ASP.NET version on my site is 2.0 I think. I use .aspx pages for it if that helps.
I misread it. I thought it ment for me to find that line when it said to create that section. This is the new error message.
Server Error in '/' Application.
The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Configuration.Provider.ProviderException: The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically
create the database file.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[ProviderException: The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.]
System.Web.DataAccess.SqlConnectionHelper.EnsureSqlExpressDBFile(String connectionString) +2466565
System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +87
System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42
System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83
System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160
System.Web.UI.WebControls.Login.AttemptLogin() +105
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
Your database doesn't exist. It can't be autocreated due to the trust level, which often means you're using a domain account on a local IIS or otherwise not using the standard process accounts.
Check out aspnet_regsql.exe for help in creating the database:
I have the same exact problem mentioned above. The problem is that I am not hosting my own site so I can't just go into IIS and mess around. I followed a ton of tutorials/ebooks and videos and they all show off this wonderful feature that is creating a
member website in "seconds" with cool features like drag and drop login controls... Problem is once you upload your site everything breaks. It's quite frustrating actually (especially for newbies like me). Do you have any suggestions for people who don't
have access to IIS and so on?
I also noticed the same sort of thing with the ASP.NET WebSite Administration Tool. Works great locally... not on server. I did however find these instructions but god knows what I'm going to tell a godaddy rep to do??
Create a new virtual directory that references %WINDIR%\Microsoft.NET\Framework\v2.0.50727\ASP.NETWebAdminFiles. I called it ASP.NETWebAdminFiles.
Make sure that the appopriate version of ASP.NET is used. In this case, it should be .NET 2.0.
On the directory security tab, disable anonymous access.
First, the admin tool doesn't work except on a local server, and won't work on GoDaddy.
As for the "exact same problem mentioned above" what happened when you tried the exact same solutions? Do you have an ASP.NET 2.0 account? Does it have SQL Server Express or SQL Server? What did GoDaddy support tell you?
Thanks for your response and assistance with this. I wrongfully assumed I would get the same error as Crazy Engineer Kid... mine appears to be different.
Below is the error i get after about 15-20 seconds of hang time. My account is ASP.NET 2.0 with "10 MySQL Databases" thats all I know at this point. I will be contacting them to see what can be done about this. I had the impression that all I would have
to do is copy the App_Data folder and ASPNETDB.MDF database over and everything would work (including the users I created from the tutorial I followed). Anyways, I think I have some more reading to do.. haha. Thanks for your help.
Server Error in '/' Application.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces,
error: 26 - Error Locating Server/Instance Specified)
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server
does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Below is the error i get after about 15-20 seconds of hang time. My account is ASP.NET 2.0 with "10 MySQL Databases" thats all I know at this point. I will be contacting them to see what can be done about this. I had the impression that all I would have
to do is copy the App_Data folder and ASPNETDB.MDF database over and everything would work (including the users I created from the tutorial I followed).
Your problem is actually quite simple. You have a hosting account that provides you with MySQL databases. The membership database is SQL 2005 Express. Your current hosting account doesn't support SQL Server Express so you need to either change to using
MySQL as the provider database or switch to a hosting account that allows SQL 2005 Express. At your stage of learning it is easier to switch accounts, but Goog;e shpuld find you references to using MySQL as a provider.
The disadvantage to using MySQL, which is not a Microsoft database and is not directly compatible, is that every tutorial will assume you have SQL Server 2003 Express. In addition, unless you configure IIS and MySQL on your local system, you won't be able
to develop against it using VWD.
I'm talking about the post that I put up with complete set of error messages and it just sits there. I'm talking about login and creating users error messages and a web admin tool that won't add users. I've been stuck on this for a week now, and I'm not
making any progress. I'm talking about the following message posted on this same forum:
well that was the full message from inside the web admin tool. If is it locking me out as an administrator from the inside local server location then it is a mystery to me how to fix it.. All my setting are the same as they were before the database
had to be replaced.
I set up a register user page and tried to enter a new user from that end and this is the error message I recieve there:
thanks
Server Error in '/' Application.
Procedure or Function 'aspnet_Membership_CreateUser' expects parameter '@TimeZoneAdjustment', which was not supplied.
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Procedure or Function 'aspnet_Membership_CreateUser' expects parameter '@TimeZoneAdjustment', which was not supplied.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
and
Server Error in '/' Application.
Procedure or function aspnet_Membership_GetPasswordWithFormat has too many arguments specified.
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Procedure or function aspnet_Membership_GetPasswordWithFormat has too many arguments specified.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Crazy Engineer Kid. Let me begin by saying that I am a N00B! However, I did have the exact same problem. Apparantly there are several steps that Godaddy requires you to go through in order to set up ASP 2.0 on your site. Here are some steps that they suggest.
You will find the step by step process here if you want to view the support page:
1. If you plan on using DotNetNuke on the site. It doesn't seem to work. I have spoken with GoDaddy several times and I can tell that the problem is in my webconfig however GoDaddy installs DNN in a virtual directory and I can't seem to figure out what
to do with the webconfig in order to get both coexisting. If anyone else can figure out where my trouble may be, it would be appreciated. But for the time being that portion seems to be broken.
2. If you plan on using the Login feature. You will have to manually set permission in the GoDaddy control panel for EACH account. A lovely little feature from GoDaddy. You will find more instructions on that in the ASP 2.0 section of the help center
on GoDaddy.com.
None
0 Points
19 Posts
login problems
Jul 31, 2006 10:49 PM|Crazy Engineer Kid|LINK
I would like to use the membership feature of VWD2005 and it works great in debug mode. The problem is after I upload my website by FTP to the server It won't work. Can someone please tell me what files are required to save all of the membership data so that I can get this to work?
I also would like to know how to add variables to any user like a score on my site. For example, every time you play a game on my site you could get 3 points to your username that could let you acess more games. How do you do this?
Thanks!
CrazyEngineerKid
All-Star
25749 Points
10436 Posts
Re: login problems
Aug 01, 2006 07:47 AM|jeff@zina.com|LINK
You'll need to explain what doesn't work means. For the second question, wher eare you having trouble with doing this? Adding the field in the database? Accessing it?
Jeff
None
0 Points
19 Posts
Re: login problems
Aug 01, 2006 09:42 AM|Crazy Engineer Kid|LINK
All-Star
25749 Points
10436 Posts
Re: login problems
Aug 01, 2006 11:47 PM|jeff@zina.com|LINK
What is the exact error message? In full.
Jeff
None
0 Points
19 Posts
Re: login problems
Aug 02, 2006 05:34 PM|Crazy Engineer Kid|LINK
It works in debug mode but once I try to login actually on my website it fails. It tells me there was an "error on the server" and then lectures me on how to create a custom error page. I'm sorry, that is all it tells me.
Although it does work in debug mode so I would assume it can't find a file because I didn't upload it...
All-Star
25749 Points
10436 Posts
Re: login problems
Aug 02, 2006 07:55 PM|jeff@zina.com|LINK
When I ask "What's the exact error message" it's becauuse the full and exact error message can help diagnose problems. Vague references can't.
Check the asp.net version.
Jeff
None
0 Points
19 Posts
Re: login problems
Aug 03, 2006 11:38 AM|Crazy Engineer Kid|LINK
This all that it tells me. It says it would tell you the complete error message on the local computer but when I just click debug it works and an error message doesn't show up!
Server Error in '/' 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".
<!-- Web.Config Configuration File --> <configuration> <system.web> <customErrors mode="Off"/> </system.web> </configuration>Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
<!-- Web.Config Configuration File --> <configuration> <system.web> <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/> </system.web> </configuration>All-Star
25749 Points
10436 Posts
Re: login problems
Aug 03, 2006 04:29 PM|jeff@zina.com|LINK
Actually, it tells you to set customErrors mode="Off" to see the error on a remote machine. Which I'm assuming you would have mentioned if you had done this. I'm also assuming that when I said to check the ASP.NET version you also didn't do that since you don't mention that either.
We'll work with you to help get you past this error, but we can't do that without your help.
Jeff
None
0 Points
19 Posts
Re: login problems
Aug 26, 2006 01:52 PM|Crazy Engineer Kid|LINK
I'm sorry I took a while to get back to you on this. I have been trying to find where you can change the custom errors mode to off and I can't in their configurator page or by just editing the page.
Where do you want the vcersion checked? On my website or in my software? The ASP.NET version on my site is 2.0 I think. I use .aspx pages for it if that helps.
All-Star
25749 Points
10436 Posts
Re: login problems
Aug 27, 2006 11:17 PM|jeff@zina.com|LINK
The error message tells you exactly how to set the customErrors to Off. Check the version in IIS, the ASP.NET tab.
Jeff
None
0 Points
19 Posts
Re: login problems
Aug 28, 2006 09:03 PM|Crazy Engineer Kid|LINK
I misread it. I thought it ment for me to find that line when it said to create that section. This is the new error message.
Server Error in '/' Application.
The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Configuration.Provider.ProviderException: The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.Stack Trace:
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
All-Star
25749 Points
10436 Posts
Re: login problems
Aug 29, 2006 07:20 AM|jeff@zina.com|LINK
Your database doesn't exist. It can't be autocreated due to the trust level, which often means you're using a domain account on a local IIS or otherwise not using the standard process accounts.
Check out aspnet_regsql.exe for help in creating the database:
http://msdn.microsoft.com/en-us/library/x28wfk74.aspx
Jeff
Member
34 Points
96 Posts
Re: login problems
Oct 08, 2006 10:45 PM|DiNASTY|LINK
Jeff,
I have the same exact problem mentioned above. The problem is that I am not hosting my own site so I can't just go into IIS and mess around. I followed a ton of tutorials/ebooks and videos and they all show off this wonderful feature that is creating a member website in "seconds" with cool features like drag and drop login controls... Problem is once you upload your site everything breaks. It's quite frustrating actually (especially for newbies like me). Do you have any suggestions for people who don't have access to IIS and so on?
I also noticed the same sort of thing with the ASP.NET WebSite Administration Tool. Works great locally... not on server. I did however find these instructions but god knows what I'm going to tell a godaddy rep to do??
All-Star
25749 Points
10436 Posts
Re: login problems
Oct 08, 2006 11:20 PM|jeff@zina.com|LINK
First, the admin tool doesn't work except on a local server, and won't work on GoDaddy.
As for the "exact same problem mentioned above" what happened when you tried the exact same solutions? Do you have an ASP.NET 2.0 account? Does it have SQL Server Express or SQL Server? What did GoDaddy support tell you?
Jeff
Member
34 Points
96 Posts
Re: login problems
Oct 09, 2006 01:29 AM|DiNASTY|LINK
Jeff,
Thanks for your response and assistance with this. I wrongfully assumed I would get the same error as Crazy Engineer Kid... mine appears to be different.
Below is the error i get after about 15-20 seconds of hang time. My account is ASP.NET 2.0 with "10 MySQL Databases" thats all I know at this point. I will be contacting them to see what can be done about this. I had the impression that all I would have to do is copy the App_Data folder and ASPNETDB.MDF database over and everything would work (including the users I created from the tutorial I followed). Anyways, I think I have some more reading to do.. haha. Thanks for your help.
Server Error in '/' Application.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.Stack Trace:
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
All-Star
25749 Points
10436 Posts
Re: login problems
Oct 09, 2006 06:07 AM|jeff@zina.com|LINK
Below is the error i get after about 15-20 seconds of hang time. My account is ASP.NET 2.0 with "10 MySQL Databases" thats all I know at this point. I will be contacting them to see what can be done about this. I had the impression that all I would have to do is copy the App_Data folder and ASPNETDB.MDF database over and everything would work (including the users I created from the tutorial I followed).
Your problem is actually quite simple. You have a hosting account that provides you with MySQL databases. The membership database is SQL 2005 Express. Your current hosting account doesn't support SQL Server Express so you need to either change to using MySQL as the provider database or switch to a hosting account that allows SQL 2005 Express. At your stage of learning it is easier to switch accounts, but Goog;e shpuld find you references to using MySQL as a provider.
The disadvantage to using MySQL, which is not a Microsoft database and is not directly compatible, is that every tutorial will assume you have SQL Server 2003 Express. In addition, unless you configure IIS and MySQL on your local system, you won't be able to develop against it using VWD.
Jeff
None
0 Points
12 Posts
Re: login problems
Oct 09, 2006 07:53 AM|djchapin|LINK
these guys aren't very helpful, I gave him my custom errors and as of last night still hadn't received an response.
you can find your custom errors switch by right clicking on your My computer icon on the desktop
select manage from the menu
select services and applications
select the IIS manager
select websites
then right click on your website and select properties
this is how you get to your ASP.net admin tool
on that tool select the ASP.net tab and then edit configuration
on the custom errors tab and there is a drop down box to select it
All-Star
25749 Points
10436 Posts
Re: login problems
Oct 09, 2006 12:50 PM|jeff@zina.com|LINK
dchapin:
Did you reply to the wrong post? Or what are you talking about here?
Jeff
None
0 Points
12 Posts
Re: login problems
Oct 09, 2006 04:38 PM|djchapin|LINK
I'm talking about the post that I put up with complete set of error messages and it just sits there. I'm talking about login and creating users error messages and a web admin tool that won't add users. I've been stuck on this for a week now, and I'm not making any progress. I'm talking about the following message posted on this same forum:
<div class="ForumPostContentText" id="_ctl0__ctl1_bcr__ctl0___PostRepeater__ctl3_PostViewWrapper">well that was the full message from inside the web admin tool. If is it locking me out as an administrator from the inside local server location then it is a mystery to me how to fix it.. All my setting are the same as they were before the database had to be replaced.
I set up a register user page and tried to enter a new user from that end and this is the error message I recieve there:
thanks
Server Error in '/' Application.
Procedure or Function 'aspnet_Membership_CreateUser' expects parameter '@TimeZoneAdjustment', which was not supplied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Procedure or Function 'aspnet_Membership_CreateUser' expects parameter '@TimeZoneAdjustment', which was not supplied.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.Stack Trace:
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
and
Server Error in '/' Application.
Procedure or function aspnet_Membership_GetPasswordWithFormat has too many arguments specified.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Procedure or function aspnet_Membership_GetPasswordWithFormat has too many arguments specified.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.Stack Trace:
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
</div>None
0 Points
3 Posts
Re: login problems
Oct 23, 2006 07:52 PM|paul_marshall7|LINK
Crazy Engineer Kid. Let me begin by saying that I am a N00B! However, I did have the exact same problem. Apparantly there are several steps that Godaddy requires you to go through in order to set up ASP 2.0 on your site. Here are some steps that they suggest. You will find the step by step process here if you want to view the support page:
http://help.godaddy.com/article.php?article_id=688&topic_id=216&&
Let me add two additional things.
1. If you plan on using DotNetNuke on the site. It doesn't seem to work. I have spoken with GoDaddy several times and I can tell that the problem is in my webconfig however GoDaddy installs DNN in a virtual directory and I can't seem to figure out what to do with the webconfig in order to get both coexisting. If anyone else can figure out where my trouble may be, it would be appreciated. But for the time being that portion seems to be broken.
2. If you plan on using the Login feature. You will have to manually set permission in the GoDaddy control panel for EACH account. A lovely little feature from GoDaddy. You will find more instructions on that in the ASP 2.0 section of the help center on GoDaddy.com.
Good luck! Hope that helps!
</div>