Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 27, 2012 07:33 AM by molly_c
Feb 12, 2012 04:47 AM|LINK
I am getting this error "The underlying provider failed to open while connecting with SQL Server Windows Authentication Mode From IIS"
I have done setup of sqlexpress in windows authentication mode. If i change it to mixed mode its working fine. I have used entity framework.
Now i have some idea that need to provide iis user rights from sql server. But i don't have any management studio installed on clients machine.
Is there any direct query so that i can provide rights to iis users. or any other solution for this?
Feb 12, 2012 06:34 AM|LINK
If i change it to mixed mode its working fine. I have used entity framework.
What is your connection string?
Feb 13, 2012 02:20 AM|LINK
Thanks. Yes it's working perfectly in mixed mode authentication, but i need it to run in windows authentication mode.
my connection string is as below
<add key="OnlineExamEntities" value="Data Source=.\SQLEXPRESS;Initial Catalog=OnlineExam;Integrated Security=SSPI;Trusted_Connection=Yes;" />
or is there any query where i can directly convert windows authentication mode to mixed mode authentication? Because client don't want management studio.
Feb 17, 2012 06:50 AM|LINK
Maybe these two links are useful to you:
Change Windows Authentication To Mixed Mode In SQL Server
Access SQL Server Using Windows Integrated Security
Feb 27, 2012 05:37 AM|LINK
Your connection string need to run in the mixed authentication mode. And you can't convert window authentication mode to mixed mode without SQL Server. I suggest you to install SQL Server Express, and then you can change the authentication.
Or you need to do something in your IIS ? Just a idea..
Feb 27, 2012 05:44 AM|LINK
Try to put your connection string in below mentiion manner
for more detail check the link
Feb 27, 2012 07:33 AM|LINK
Maybe this thread will help you to solve your problem.