aspnetdb database

arnab-jit · April 30th, 2011, 05:35 AM

I want to implement security in my web project. I am using AspNetSqlMembershipProvider. But I do not want to use the aspnet.mdf database. I want to use all the tables, views and sp of aspnetdb.mdf to my application database. In my application database I have created all the tables, views and sp. But when I try to create a new user then it is throwing an error.'The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version'.Please help me.

Imar · April 30th, 2011, 05:46 AM

Hi there,

You need to do exactly what the error message tells you:

Quote:

You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory),

Cheers,

Imar

arnab-jit · April 30th, 2011, 05:50 AM

I have other tables and store procedure in my database. Is it possible to place all the table, views and store procedures of aspnetdb database in my datatabese?

arnab-jit · April 30th, 2011, 06:06 AM

How to create all the tables, views and store procedures of aspnetdb database to my existing database using aspnet_regsql.exe??

Imar · April 30th, 2011, 06:08 AM

Just run it, and it will guide you through the process with a wizard.

Alternatively, run it from a command prompt and use /? to see the parameters you can pass to it.

Cheers,

Imar

arnab-jit · April 30th, 2011, 06:52 AM

To test the procedure. I have created a new application and attached the Northwnd database in to my application. Now i want to create the same structure in my northwnd database with all the northwnd database objects. So what I am trying to do is in my Northwnd database all the tables, views and store procedures of Northwnd database will be there and all the tables, views and store procedures of aspnetdb database also will be there.

For that i am using aspnet_regsql.exe.

Code:

aspnet_regsql.exe/C Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Arnab's Documents\My Websites\WebSite3\App_Data\NORTHWND.MDF;Integrated Security=True;User Instance=True

But it is giving an error that 'Source=.\SQLEXPRESS;AttachDbFilename="D:\Arnab's' is invalid

Imar · April 30th, 2011, 10:02 AM

Hi there,

See where this breaks? At the space in the path. My guess is that you need quotes around the path.

Also, you probably don't want a quote in your path; this will lead to lots of problems. Store the site in something like C:\Sites\Website3 instead; a lot easier....

Imar