Login Controls and an SQL Server 2005 Database

[GavW]

Hey all!

I am currently in the process of converting all of the membership features on my websites to incorporate the all new login controls in visual studio 2005.

Setting this up results in the "ASPNETDB" SQL Express Database being created to store the information. However I would like the information to be stored within a table that I have present on my SQL Server 2005 database. This would not be a big problem if it wasn't that my web server does not accept SQL Express databases.

How can this be done?

Thanks

 

[Catadmin]

Sounds like you have an issue with whatever connection manager or connection string you have set up in Visual Studio. Check that and see if it is pointing to a SQL Server Express db or connection manager.

Converting the information from Express to the regular (standard/enterprise/etc.) SQL Server is as simple as doing a Select...Into from one server to another using four dot notation (Server.Database.Owner.Table). However, this doesn't do you any good if the login controls are looking at the Express instance trying to get the information needed.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"