Hi All,
Can any one tell
whats the differnce between Windows integrated authenticaton ?
can we use windows integrated authentication connection string on .net application when login remotely?
In the above case whats the connection string? Can anybody send me a sample.
Thanks
Connecting Through Windows Authentication
When a user connects through a Windows user account, SQL Server validates the account name and password using the Windows principal token in the operating system. This means that the user identity is confirmed by Windows. SQL Server does not ask for the password, and does not perform the identity validation. Windows Authentication is the default authentication mode, and is much more secure than SQL Server Authentication. Windows Authentication uses Kerberos security protocol, provides password policy enforcement with regard to complexity validation for strong passwords, provides support for account lockout, and supports password expiration. A connection made using Windows Authentication is sometimes called a trusted connection, because SQL Server trusts the credentials provided by Windows.
http://msdn.microsoft.com/en-us/library/ms144284.aspx
Conection String
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;