1
Reply

keyword intergratedsecurity not supported

Cassie Mod

Cassie Mod

Apr 27 2016 12:10 PM
274

 Hi I get the following error. when I try to connect to the SQl Server. The keyword IntergratedSecrity isn't supported. What did I do wrong ?

 

here is my class and method method to create a connectionstring.
 
  1. using System.Configuration;  
  2. using System.Data.SqlClient;  
  3.   
  4.   
  5.   
  6. namespace WindowsFormsApplication1.DataAccessLayer  
  7. {  
  8.     class DatabaseLayer  
  9.     {  
  10.         public static SqlConnection OpenConnection()  
  11.         {  
  12.             var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["customers"].ConnectionString);  
  13.             connection.Open();  
  14.             return connection;  
  15.   
  16.         }  
  17.     }  
  18.   
  19. }  
 and here is my ap.config
 
  1. <?xml version="1.0" encoding="utf-8" ?>  
  2. <configuration>  
  3.     <configSections>  
  4.     </configSections>  
  5.       <connectionStrings>  
  6.             <add name="customers" connectionString="Data Source=\\MAC-CASPER\SQLSERVERCASPER; Initial Catalog=Customer_xxxxx; IntegratedSecurity=True" providerName="System.Data.SqlClient" />  
  7.       </connectionStrings>  
  8. </configuration>  
 

Answers (1)