Monday, March 26, 2012

Membership database installation SQL Express

I am trying to run one SQL Express database for two separate applications that will also use the Membership framework. My database is set up fine and works between both applications 100% as needed with the exception of Membership which I am fairly new to.

From my understanding given the following link

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/PAGHT000022.asp

I need to install membership on the database. So I did the following

(allow remote connections with TCIP/IP and named pipes)

Started SQL and even re-booted

Ran: aspnet_regsql.exe -E -S localhost -A m

I even tried to run it by replacing localhost with MSSQL$SQLEXPRESS

All attempts gave me an error saying it could not connect and most likely because remote connections is disabled.

I think the reason for all this is because I don't actually have the "real" IIS installed but rather I am using the instantiated version that automatically comes up when starting a ASP.NET 2.0 application.

I am assuming I need to set everything up such that I am using the real IIS rather then the default one in visual studio.

Is this correct? Or do I have something else?

Use only aspnet_regsql.exe and create membership services for your database through the wizard.

Hope that helps!

|||I am using aspnet_regsql.exe only regardless of what i do aspnet_regsql.exe says it cant connect and most likely becuase of remote connections being disabled even thought it explicitly turned remote connections on.sql

No comments:

Post a Comment