Connection string using Windows Authentication

Question

I am creating a website  but in the database I use windows authentication   I know that you use this for SQL authentication   lt connectionStrings gt        lt add name  NorthwindContex          connectionString  data source localhost         initial catalog northwind persist security info True          user id sa password P ssw0rd          providerName  System Data SqlClient    gt    lt  connectionStrings gt    How do I modify this to work with windows authentication

User · Answer

For connecting to a sql server database via Windows authentication basically needs which server you want to connect , what is your database name , Integrated Security info and provider name.

Basically this works:

<connectionStrings>      
<add name="MyConnectionString"
         connectionString="data source=ServerName;
   Initial Catalog=DatabaseName;Integrated Security=True;"
         providerName="System.Data.SqlClient" />
</connectionStrings>

Setting Integrated Security field true means basically you want to reach database via Windows authentication, if you set this field false Windows authentication will not work.

It is also working different according which provider you are using.

SqlClient both Integrated Security=true; or IntegratedSecurity=SSPI; is working.
OleDb it is Integrated Security=SSPI;
Odbc it is Trusted_Connection=yes;
OracleClient it is Integrated Security=yes;

Integrated Security=true throws an exception when used with the OleDb provider.

User · Answer

For the correct solution after many hours    Open the configuration file Change the connection string with the following    lt add name  umbracoDbDSN  connectionString  data source YOUR SERVER NAME database nrc Integrated Security SSPI persist security info True   providerName  System Data SqlClient    gt    Change the YOUR SERVER NAME with your current server name and save Open the IIS  Manager Find the name of the application pool that the website or web application is using Right-click and choose Advanced settings From Advanced settings under Process Model change the Identity to Custom account and add your Server Admin details  please see the attached images       Hope this will help

User · Answer

This is shorter and works   lt connectionStrings gt         lt add name  DBConnection               connectionString  data source SERVER INSTANCE         Initial Catalog MyDB Integrated Security SSPI                providerName  System Data SqlClient    gt   lt  connectionStrings gt     Persist Security Info not needed

User · Answer

Replace the username and password with Integrated Security SSPI   So the connection string should be    lt connectionStrings gt    lt add name  NorthwindContex      connectionString  data source localhost     initial catalog northwind persist security info True      Integrated Security SSPI       providerName  System Data SqlClient    gt    lt  connectionStrings gt

[.net] Connection string using Windows Authentication

Examples related to .net

Examples related to asp.net-mvc

Examples related to connection-string

Examples related to windows-authentication