Jul 22, 2010

Sql connection Using Windows Authentication

sometimes, We get error in sql connection on local machine,this problem occur due to the authentication level of the server(Ms Sql server).

so we trying to open connection by using windows authentication...


SqlConnection conn = new SqlConnection( "Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI");

SSPI to make connection with user's Windows login User ID Name of user configured in SQL Server

No comments:

Post a Comment