In my web.config I have:
[Code]....
If I just have ADProvider1 it works, when I add ADProvider2, even though for testing I only use ADProvider1 I get an error: "Unable to establish secure connection with the server" Am I adding the second provider to the membership section incorrectly?
We're having an error similar to the one detailed here. We get the error noted above when trying to do AD authentication from our .net (3.5) mvc 2 app. This is our first .net mvc app ...
http://forums.asp.net/t/1161047.aspx
- We are re-using a forms auth library written for a .Net 2 app
- that library/app/config used a service account with min. privileges for binding to AD
- This error occurs in VS 2008, have not tried deploying the app to a server yet (a little early for that)
- like the other user at the previously referenced thread, I can get the 'unable to establish ...' error to go away and display the log on page by putting *MY* credentials in instead of the service account (but not successfully authenticate)
- moving the service account into the same AD OU as my account does not seem to change it ... only using my account credentials does.
- trust level is set to full
Is this some odd permissions trick that is new with .Net 3.5 (even though the ADmembershipProvider is still a 2.0 libary)? This should have nothing to do with MVC itself.
Config looks like this (very standard, like every one else's)
[Code]....
The line/portion highlighted in the debug/stacktrace is:
type="System.Web.Security.ActiveDirectoryMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
IIS 6 installed on Vista (Virtual PC) not member of domain, Visual studio 2008 based website. Active Directory Membership configured in web.config.
Trust level set to Full. Using Login control to authenticate.
[Code]....
I cannot get a successful connectiong to the active directory when logging onto a web form. Here is the code I have in the web.config:
<configuration>
<appSettings/>
<connectionStrings>
[code]...
In my web application am using ASP.Net Membership for authentication ann role management.But now i have a situation where i need to authenticate multiple clients against different DB based upon the URL request being send. Below is my web.Config Details.
<authentication>
<forms loginUrl="Login.aspx" defaultUrl="Login.aspx" />
</authentication>
<membership defaultProvider="QuickStartMembershipSqlProvider">
<providers>
<clear/>
<add connectionStringName="MEMBERSHIP_AND_ROLES" minRequiredPasswordLength="5"
minRequiredNonalphanumericCharacters="0"
enablePasswordReset="true"
requiresQuestionAndAnswer="false"
applicationName="SecurityQuickStart"
requiresUniqueEmail="true" passwordFormat="Hashed" name="QuickStartMembershipSqlProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
</providers>
</membership>
<roleManager enabled="true" defaultProvider="QuickStartRoleManagerSqlProvider">
<providers>
<clear/>
<add connectionStringName="MEMBERSHIP_AND_ROLES" applicationName="SecurityQuickStart" name="QuickStartRoleManagerSqlProvider" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
</providers>
</roleManager>
ConnectionString.Config:
<add name="MEMBERSHIP_AND_ROLES" connectionString="Data Source=x.x.x.x;Initial Catalog=xxx;User ID=xxx;Password=xxx" providerName="System.Data.SqlClient"/>
Am using form authentication for user authentication. In my login page am using Membership.ValidateUser(username,password),which is using default membership provider. Now my situation is i need to override the default DB and connect to multiple DB based on URL request send to my web server.
I want to know if we can use multiple membership providers simultaneously in a single ASP.net application.
View 1 RepliesI am building a web site and am trying to run the web site administration tool.
I have reinstalled SQL Server 2008 express and have run the command line administration utilites. When I try to run the administration tool, get the following error when I click on the security tab is
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
I have ensured that I have user instances are enabled
When I click on Choose Data Store I get the following error
Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
i have a web application that is using a https webservice and for accessing this webservice i have installed the PFK file into the mmc console in the personal storage folder and also installed in IIS. After installing the PFK file the properties of the installed PFK file shows a warning that "Windows does not have enough information to verify this certificate" but the installation is done with success. After this i go to add the wsdl to my project as service reference, but it shows the error "Could not establish trust relationship for the SSL/TLS secure channel with authority". What is the solution for this?
View 17 RepliesI know this question is asked (and answered) a lot already, but I believe my situation is unique.
We are using the ASP.NET SqlMembershipProvider. However, we also have some less-secure content we would like to secure by adding users directly to the web.config, like so...
<forms loginUrl="login.aspx" defaultUrl="default.aspx">
<credentials passwordFormat="Clear">
<user name="user1" password="123" />
<user name="user2" password="456" />
</credentials>
</forms>
Is it possible to use this method alongside a SQL Membership Provider? If so, how?
I know it's bad practice to do this. This is only a stepping stone as we move parts of our website into the asp.net application. We would like some of those password to be easily editable without going to the database.
I've created an ASP.Net 4.0 web application. It uses Forms Authentication. I have an ASPNETDB.mdf file in my App_Data folder courtesy of SQLEXPRESS. I have appropriate settings in my web.config for connection strings and providers (since I know it will be asked for:
<add name="ApplicationServices" connectionString="data source=.SQLEXPRESS;Integrated Security=SSPI;
AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>).
I have roles and users setup. I have been running this with absolutely no problems in both my dev environment (i.e. Cassini) and on a "production" (not really, but a machine that was published to). And the "production" machine still has no problems.
So, everything has been working perfectly fine until early this afternoon and all of a sudden it all stopped. The only things I did from when it worked until it stopped was: I connected to and checked in all my code to a TFS server (2010) and then I updated namespaces all around. I have not made any changes to my web.config since it worked, nor to the database. I'm really not sure what happened. Oh, and the "production" machine never got the namespace updates. But, it did get a publish immediately before I uploaded everything into TFS.
It started with me getting a login failure in my app. I know the login is correct (it still works on the published system). So, I went into the Website Admin Tool and clicked onProvider Configuration -> Select a single provider... -> Click on Test next to AspNetSqlProvider (only option). I get back an error: "Could not establish a connection to the database." So, this tells me that for some reason, it can't see my database. All my roles and users still show up though in Security.
Since these two actions, I have wiped out all my code locally and refreshed from the first changeset in TFS. Still no workie. I still get the "Could not establish..." in WAT. Every post I can find online keeps talking about connectionStrings and database configuration (i.e. aspnet_regsql). However, since this was just working with no issues, I'm pretty sure none of these are my problem. Especially since I refreshed my code to an earlier "working" state (prior to namespace changes) to no effect.
I am not yet at the point that I'm willing to wipe my database and start over. Again, because this was working before. I have noticed and read several posts by Sukumar Raju among others (including his blog posts, one here) and none of them helped or were quite related to my specific issue. Good information, but not what I needed.
I'm sure something went offline somewhere and I can't see it. I did check to make sure that the SQLEXPRESS services (including Browser, etc.) were started. Even restarted them to no avail. I'm sure it has to be something simple and I'm just missing it somewhere.
Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
I don't know where to go next as this error message does't give many leads. I have already configured that database with the aspnet_regsql tool. In SQL Mngt. Studio I can see that the database aspnetdb has been created. I'm not sure where to go from here. The only connection string in my web.config file is the one for connecting to my content database.
Currently I'm learning on one of Joe Stagner video "SEC-009-CreateMembershipSchema" I followed exactly as told except for that Joe's is building the database in his JoeStagner server and not JoeStagnerSQLEXPRESS. But in my case I built my database in my MACHINENAMESQLEXPRESS. Another different thing is Joe's using SQL Management 2005 and I'm using the free version of SQL management 2008.
So I followed every step, inch by inch but when I tried to run a test on the AspNetSqlProvider, I'm getting this error Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
here's the connection string I added in just like in Joe's video
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="data source=.SQLEXPRESS;DataBase=AspNetServicesDB;Uid=AspNetServicesUser;Pwd=password"/>
</connectionStrings>
I have VS 2010 professional. I am trying to open "ASP.Net Configuration" through Project -> ASP.Net Configuration.
It pops up the Notification about the ASP.Net Development Server localhost but doesn't open ASP.Net Configuration in the default browser.I clicked on the Root Url (by double clicking on the 'development server' at the right bottom from Notification Manager).
It throws following error
"An error was encountered. Please return to the previous page and try again."
Clicking on "How do i use this tool".It opened page with error.
Tool Has Timed Out
I have created two custome membership providers that I would like to add to my web.config. The first one would be the default that the asp.net application would use. The second would be called by a WCF service that I have in the same application.
The providers in the membership section of my web.config looks like the following:
<add name="SiteProvider" type="MyNameSpace.SiteProvider, MyNameSpace" ApplicationName="Si2" EnablePasswordReset="true" PasswordStrengthRegularExpression="(?=[w$#_ ]{8,})(?=.*?d)(?=.*?[A-z])[w$#_ ]*" ResetPasswordMinimumLength="8" ResetPasswordPattern="USL9SLU9SLU9SLLLL" ResetPasswordAllowDuplicateCharacters="false" />
<add name="WCFProvider" type="MyNameSpace.WCFProvider, MyNameSpace" ApplicationName="Si2" EnablePasswordReset="true" PasswordStrengthRegularExpression="(?=[w$#_ ]{8,})(?=.*?d)(?=.*?[A-z])[w$#_ ]*" ResetPasswordMinimumLength="8" ResetPasswordPattern="USL9SLU9SLU9SLLLL" ResetPasswordAllowDuplicateCharacters="false" />
I receive the error "Item has already beed added. Key in dictionary: 'SiteProvider' Key being added: 'SiteProvider'" any time I browse to the site.
This doesnt make sense to me sense they have unique names. If i remove the second provider the site is browseable.
How to fix this error,
"The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required. Learn more at"
[URL].....
I have sql server 2008 express edition. I'm trying to use the wsat to set up the provider but I keep getting the error:
Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
[code]....
I am writing a login routine that uses a .NET login control and I have a membership provider as well and set it all up in the config file. But I don't plan on using a connection string as I will be calling a web service in my ValidateUser function. Do I need the connection string in the config because it seems to throw an error if I don't have it.
In that case if you need it then wouldn't it be better to treat this membership provider class more as a normal class and just make calls to it directly like any class and not put any setting on my login control and remove the entry from my web.config
I'd like to know if its possible to use two membership providers within a single application. I need to have a membership provider "power users" and administrators on a site and a different one for clients and customers who will want to register on the site. I'd like to know if its possible to have two different membership providers to handle these two different sets of users. If it is, how do i go about it?
View 4 RepliesI have a question with this tool. I have a database listed in the App_folder, and the database has a connection in Server explorer. The connection string is listed in the web.config file, and I am able to add users and roles with the Web Admin Tool. However,when in the Web Admin Tool, under Configuration tab, I receive an error when I click on the "test" button. The error reads " Could not establish a connection to the database.If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider."
View 6 RepliesI'd like to know how membership providers works under the hood, if it uses cookies, session, the principal and identity thread objects, etc.. etc.. where can I find information?
View 3 RepliesI am new to using the membership provider. I have been working in a small shop that has very focused programming and we are starting to venture out as our needs have grown. My question is the following:
Once I have created the asp schema and I set up users. How do I perform database access using those user accounts? I know how to perform access using a database account (schema), but do not understand how to use a user that only exists in a user table to access data tables.
Do I use an anonymous account and control access on the front end?
How to I track audit fields?
I am now using SQL Server 2008 EXPRESS x64 on a PC running WINDOWS 7 ULTIMATE x64 bit.
how to configure ASP.Net Membership Providers because I can't attach a database created after this example :
http://aquesthosting.headtreez.com/doc/29423088-74cd-4d51-b2ee-3cb958f08d1a
(I have created runproviders.sql with my Visual Studio x64 Win64 Command Prompt (2010) )
Still now working...
Every time I run ASP.NET Configuration -> Provider -> Select a single provider for all site management data and TEST for
AspNetSqlProvider
I get the following error every time :
"Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider."
I can tell you for sure that my new created database is working because i used a web page with a CreateUserWizard1 control and I can create new users.Even I can see the new creted user with ASP.NET Configuration -> Security.
After running the aspnet_regsql.exe tool, i notice a bunch of different tables pertaining to the ASPNET security (e.g. aspnet_Applications, aspnet_Membership, aspnet_Paths, aspnet_Personalations, aspnet_Profile, aspnet_Roles, aspnet_SchemaVersion, aspnet_Users, aspnet_UsersInRoles). Do the different providers (AspNetSqlMembershipProvider, AspNetSqlProfileProvider, AspNetSQLRoleProvider) relate or associated with certain aspnet_xyz tables? I imagine the AspNetSQLProfileProvider is responsible for the aspnet_Profile table correct? The AspNetSQLRoleProvider probably is tied to the aspnet_Users, aspnet_Roles, aspnet_UsersInRoles table? Any links documenting the relationship between teh providers and the aspnet_xyz tables?
View 1 RepliesThis is the first time i would be using .net membership providers and i need to add some extra columns and chage a couple of existing datatypes of the exising columns.
my Q is:
1)can i do this without having to suffer down the road.
2)can i modify the existing sp's in sql08 or would i need to use additional sp's for the new columns that i add.
I m getting error while running page(.aspx)
"Login failed for user 'HOME-D6A8A84CE4ASPNET'." and at the same time i m also getting error
Firefox can't establish a connection to the server at localhost:1452.
although the the pages(website was running properly as before)
