Uploading ASPNETDB.MDF security configs

I uploaded my ASPNETDB.MDF which contains my local server's security configurations. When I went to see the results of the upload, none of my settings were in the tables. I am confused as to how to get my ASPNETDB.MDF onto the remote server. I know that your servers don't support ASPNETDB.MDF, so does this mean that all of the tables in an ASPNETDB.MDF file should be made part of my application's database? Please refer to my attached jpg for command that I used as explained in your article ID #337 (How to configure the ASP.NET Membership/Roles Provider to use SQL 2005).

 

Thanks for Suggestion, will try

Thanks for the suggestion I will try that later on tonight. However, I'm still not clear as to whether all the tables in ASPNETDB.MDF become part of my web database? Please confirm.

Thanks,
Peter

 

Still Cannot Upload My Tables

I am getting increasingly frustrated with this problem. I cannot upload my tables to my SQL2K801 DiscountASP.Net server. I've followed the instructions you sent me and it continually FAILS. There is no description of the problem, it simply says contact technical support. Can someone simply give me step-by-step instructions on how to upload my database?

One further thing I've noticed is that SQL2K801 is a version 10.0.5766 and my local SQL Server 2008 R2 is a version 10.0.1600. Could this be a problem?

My initial database was created using SQLExpress. Is a database created in SQL Express incompatible with the DiscountASP.Net database? If so, how does one convert it?

At this point I'm pulling what's left of my hair out!!!!

Peter

 

SQL Server 2008 R2 .mdf database and .bak database backup files are not file format backward compatible with SQL Server 2008

 

Successful, But How Do I Incorporate ASPNETDB.MDF?

How do I incorporate the security tables without recreating them from scratch? Do I have to consolidate them locally with my data tables first before uploading them to DASP? What's the easiest way?

Peter

 

Combined ASPNETDB.MDF with Database

I successfully combined databases and uploaded to DASP. However now I get this error message:

Server Error in '/Paragon6' Application.

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

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: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

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:


[SqlException (0x80131904): Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2073502
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5064460
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +215
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +178
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
System.Web.Util.SecUtility.CheckSchemaVersion(ProviderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) +392
System.Web.Security.SqlRoleProvider.CheckSchemaVersion(SqlConnection connection) +64
System.Web.Security.SqlRoleProvider.GetRolesForUser(String username) +847
System.Web.Security.RolePrincipal.IsInRole(String role) +182
System.Web.Configuration.AuthorizationRule.IsTheUserInAnyRole(StringCollection roles, IPrincipal principal) +132
System.Web.Configuration.AuthorizationRule.IsUserAllowed(IPrincipal user, String verb) +264
System.Web.Configuration.AuthorizationRuleCollection.IsUserAllowed(IPrincipal user, String verb) +201
System.Web.Security.UrlAuthorizationModule.OnEnter(Object source, EventArgs eventArgs) +9024573
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +148
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

What's wrong? Any suggestions appreciated.

Peter

 

This means that at least part of application services schema is missing or can't be accessed due to a permissions problem. How did you create the schema in the db?

 

Created Schema Locally

I created the schema locally before uploading to DASP. Is it possible to change the schema once it's uploaded? Sorry for my newbieness.

Peter

 

This is the recommended method for installing the application services schema into a database: https://support.discountasp.net/KB/...rshiproles-provider-to.aspx?KBSearchID=353692
The idea is you execute this command line locally but it can be directed to execute against a remote sql server db via it's command line options. More info here http://msdn.microsoft.com/en-us/library/x28wfk74.aspx

 

I`m sorry, but I`ve read this knowledgebase article several times and it`s not clear to me what comes first. Creation of the aspnet security tables on the remote server and then insertion of my tables or vice versa. Can you clarify?

 

This tool installs the application services db schema to a target db and that's where it's responsibility ends. It doesn't care whether existing application level db tables / sprocs etc are present in the db or not..unless you're unlucky enough to having an object naming collision which is unlikely. In short you're free to do it in the order that suits you.

 

Thanks I'll Try That

Ok, thanks I'll try that and I'll let you know if I'm successful. Thanks for your kind assistance.

Peter

 

Can't access restricted pages

I successfully uploaded the ASPNETDB.mdf using the technique you suggested. My web site works to an extent, but it still doesn't access the restricted pages, namely the two middle pages, "Edit Properties" and "View Properties". These 2 pages should open if the user enters a valid username and password. I've attached my web.config file for anyone who can tell me what I'm doing wrong. I'm stumped. I've masked my password in the file and zipped the file for upload.

Thanks,
Peter

 

Does anyone have any idea how to resolve this???

Need help!

 

I am trying to upload application with sqlexpress database do my developer acc at DASP (user387.webmatrix2rc.discountasp.net)

Now I see that sqlexpress wont work so I have to upsize it t ofull SQL

HOw I accomplish that. Do I have access to the upsize tool you are mentioning here in forum
Please give some advice..

 

OK I see . ATM I am only trying to publish my test ASP.NET site.
Will I be able to do that after I conver my SQLEXPRESS database manually at my PC ?