PC Review


Reply
Thread Tools Rate Thread

How to reference a membership database that is not in App_Data SQL Server Express database?

 
 
Keith
Guest
Posts: n/a
 
      2nd Jul 2006
If I understand correctly, the SQL script called "InstallMembership.sql" can
be used to create a membership database that exists in the instance of SQL
Server 2005 used for my main application. Having created such a database,
how can I get the ASP.NET Web Site Administration Tool to reference that
database instead of the one that exists in the App_Data folder SQL Server
Express database? Also, how can I get the membership controls in my
application to reference the newly created database instead of the one that
exists in the App_Data folder SQL Server Express database?
Thanks,

Keith


 
Reply With Quote
 
 
 
 
Keith
Guest
Posts: n/a
 
      3rd Jul 2006
I found the answer to this question in a very good article entitled:
ASP.NET 2.0 and the Provider Model, without SQL Express
located at:
http://weblogs.asp.net/bsimser/archi...x?Pending=true
I followed the instructions and it worked.

Thanks,

Keith

"Keith" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> If I understand correctly, the SQL script called "InstallMembership.sql"
> can be used to create a membership database that exists in the instance of
> SQL Server 2005 used for my main application. Having created such a
> database, how can I get the ASP.NET Web Site Administration Tool to
> reference that database instead of the one that exists in the App_Data
> folder SQL Server Express database? Also, how can I get the membership
> controls in my application to reference the newly created database instead
> of the one that exists in the App_Data folder SQL Server Express database?
> Thanks,
>
> Keith
>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Membership Provider deployment/App_Data directory just wont die!!! :-) Jeppe Jespersen Microsoft ASP .NET 3 10th Jul 2007 10:58 PM
App_Data Path and ASP.NET Membership PinkBishop Microsoft ASP .NET 0 26th Apr 2007 05:23 AM
Any solution for error message "Could not attach file 'App_Data\Database.mdf' as database 'Database'."? ornit_sagy@yahoo.com Microsoft ADO .NET 0 8th Jan 2007 09:34 PM
Any solution for error message "Could not attach file'App_Data\Database.mdf' as database 'Database'."? ornit_sagy@yahoo.com Microsoft ADO .NET 1 8th Jan 2007 09:12 PM
Add new SQL Database to App_Data need SQL Server Express installed? Michael Microsoft ASP .NET 1 16th Jan 2006 03:44 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:30 AM.