4 versions of aspnet_regsql, which one to use? or all?

Jeenyusx10
Jeenyusx10 used Ask the Experts™
on
I am running windows 7 64 bit.

I recently had to deal with a bad install of SQL Server and just wiped the hard drive and started fresh. So i don't want to repeat any mistakes I might have made, one of which might have been running multiple versions of aspnet_regsql.

This file exists. in 4 places on my computer. 2 for 32 bit and 2 for 64 bit.. and within those, one is for 2.0, 3.0 and 3.5 and one is for 4.0

So should I run each one? Do I need each one?



Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Kyle AbrahamsSenior .Net Developer

Commented:
http://msdn.microsoft.com/en-us/library/ms229862(VS.80).aspx

I would run the 64 bit version with whatever version of .net you're programming in.

Author

Commented:
Thats what I was thinking. However, currently I am targeting 3.5.. But Once i start working with 4.0 am I going to run into compatibility issues when I install aspnet_regsql 4.0?
Carl TawnSenior Systems and Integration Developer

Commented:
I assume this means you are intending to use the aspnet membership database, otherwise there's no need to run aspnet_regsql at all.

If you are using it then you need to run whichever version matches the version of .Net you are targeting. Aspnet_regsql only creates a membership database, so i'm not sure what "compatibility issues" you are running in to.
Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

Kyle AbrahamsSenior .Net Developer

Commented:
You could always create the 4.0 later and copy over the data from the 3.5

Author

Commented:
@ged325:

Im going to run the 64 bit version of 3.5 since thats what I am working in.

@carl_tawn:

I have no compatibility issues now, but as I said, later on...if i should happen to start targeting 4.0, will I run into any compatibility issues being that both 3.5 and 4.0 versions of aspnet_regsql are installed...
will I have two aspnetdb's in MSSQLSERVER?
Senior Systems and Integration Developer
Commented:
Well, no you won't have two aspnetdb's because SQL won't let you. You can however use aspnet_regsql to add the membership stuff to a preexisting database instead.

The schemas for the different versions will be slightly different, which is why you have to use the version specific version of aspnet_regsql. But at the end of the day you are only creating a database schema, they are completely isolated from one another.
Kyle AbrahamsSenior .Net Developer
Commented:
http://stackoverflow.com/questions/835124/how-do-i-change-my-asp-net-membership-database-from-express-to-standard-sql

I believe you can have more than 1 Membership DB . . . just name it something unique and point in your web config to whichever you need.

Author

Commented:
Thanks you both!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial