How can I create an IIS provider for SQL Server?

I have a backup (failover) server that is missing a provider in IIS. I have all the provider parameters except the type.  I know the type for the Provider should be MS SQL server, but there must be some specific systax I should use for this to work.  See attached images.

IIS Web Site Properties and ASP.NET SettingsThis image is of the Properties of my web site in IIS.  On the APS.NET tab I click 'Edit Coonfiguration..' which open the ASP.NET Configuration Settings.  Within this window I click 'Authentication' tab.  About the middle of the window is a button 'Manage Providers'.

IIS Authentication Provider SettingsWhen I click 'Manage Providers' a new window opens for 'Provider Settings'. I need to create a new Provider so I click 'Add Provider' and I am prompted for the 'Provider name' and 'Provider Type'  The problem I have is that I don't know the correct systax to refer to the SQL Server for the Provider Type field.  What is the correct syntax for valid values for the Provider Type?

Any help is appreciated.
LVL 9
Michael CarrilloInformation Systems ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

brwwigginsIT ManagerCommented:
Maybe this will help.

http://aspalliance.com/1658_Using_Forms_Authentication_with_Membership_Providers_in_ASPNET_20.5

What your looking at is really a GUI into the web.config file. You should be able to enter a provider name of your choice and put System.Web.Security.SqlMembershipProvider as the type.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Michael CarrilloInformation Systems ManagerAuthor Commented:
Thank You Both, I had spent over a month trying to resolve this issue. Looking at service accounts, SharePoint Central configurations and IIS etc. Ultimately the key phrase that helped me focus my efforts was 'What your looking at is really a GUI into the web.config file.'  

Thank You for your help!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft IIS Web Server

From novice to tech pro — start learning today.