The underlying provider failed to open while connecting with SQL Server Windows Authentication Mode From IIS RSS

• • Reply
  

  NJ

  Member

  47 Points

  86 Posts

  The underlying provider failed to open while connecting with SQL Server Windows Authentication Mo...

  Feb 12, 2012 04:47 AM|LINK

  Hello All,

  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? 

  Nikunj Prajapati.
  Software Engineer.
  • Moved by tmorton on Feb 17, 2012 07:42 PM
• • Reply
  

  ignatandrei

  All-Star

  135204 Points

  21687 Posts

  Moderator

  MVP

  Re: The underlying provider failed to open while connecting with SQL Server Windows Authenticatio...

  Feb 12, 2012 06:34 AM|LINK

  NJ

  If i change it to mixed mode its working fine. I have used entity framework.

  What is your connection string?

  My .NET blog : http://msprogrammer.serviciipeweb.ro/ |2012 Programmer tools
• • Reply
  

  NJ

  Member

  47 Points

  86 Posts

  Re: The underlying provider failed to open while connecting with SQL Server Windows Authenticatio...

  Feb 13, 2012 02:20 AM|LINK

  Hi,

   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.

  Nikunj Prajapati.
  Software Engineer.
• • Reply
  

  Frank Jiang ...

  All-Star

  16006 Points

  1728 Posts

  Microsoft

  Re: The underlying provider failed to open while connecting with SQL Server Windows Authenticatio...

  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

  Please mark the replies as answers if they help or unmark if not.
  Feedback to us
  
  Develop and promote your apps in Windows Store
  
  
• • Reply
  

  molly_c

  Participant

  1590 Points

  401 Posts

  Re: The underlying provider failed to open while connecting with SQL Server Windows Authenticatio...

  Feb 27, 2012 05:37 AM|LINK

  Hi,

  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.

  Method:http://msdn.microsoft.com/en-us/library/ms188670.aspx 

   

  Or you need to do something in your IIS ?  Just a idea..

  Best Regards.
  Molly
  
  It's time to start living the life you are imagined.
  • Edited by molly_c on Feb 27, 2012 05:37 AM
  • Edited by molly_c on Feb 27, 2012 05:40 AM
  • Edited by molly_c on Feb 27, 2012 05:40 AM
  • Edited by molly_c on Feb 27, 2012 05:40 AM
• • Reply
  

  vinay13mar

  Star

  7756 Points

  1626 Posts

  Re: The underlying provider failed to open while connecting with SQL Server Windows Authenticatio...

  Feb 27, 2012 05:44 AM|LINK

  Hi,

  Try to put your connection string in below mentiion manner

  <add name="MyDbConn1" 
         connectionString="Server=MyServer;Database=MyDb;Trusted_Connection=Yes;"/>

  for more detail check the link

  http://msdn.microsoft.com/en-us/library/ff647396.aspx

  Thanks
  V.K.Singh
  
  
  
  • Edited by vinay13mar on Feb 27, 2012 05:44 AM
  • Edited by Ming Xu - MSFT on Feb 28, 2012 12:18 PM
  • Edited by Ming Xu - MSFT on Feb 28, 2012 12:18 PM
• • Reply
  

  molly_c

  Participant

  1590 Points

  401 Posts

  Re: The underlying provider failed to open while connecting with SQL Server Windows Authenticatio...

  Feb 27, 2012 07:33 AM|LINK

  Hi,

  Maybe this thread will help you to solve your problem.

   http://forums.asp.net/t/1771860.aspx

  Best Regards.
  Molly
  
  It's time to start living the life you are imagined.