Tuesday, January 18, 2011

How To: Connect to SQL Server Using Windows Authentication in ASP.NET 2.0

Instant Archive Viewer for Microsoft LCS 2005 may be configured to access the SQL server using Windows authentication.  If this configuration is required, typically for security reasons, then take following configuration steps:

1. Add the machine name hosting the Archive Viewer Application as a user to the SQL Server having access to LcsLog database. The username should have the format: domain\MachineName$.



In the above screen shot domain name is INSTANT while the machine name is TEST.

2. Configure the archive viewer to use "Integrated Windows Authentication" mode for SQL server access.


For detailed steps refer the following Microsoft MSDN post:

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

The symptoms of a 'mis configured' connection may be a SQL Server timeout issue when the Archive Viewer attempts to retrieve the contents of a chat session.

No comments: