Tuesday, January 13, 2009

Windows user to connect to SQL Server

To allow a particular Windows user to connect to sqlserver using Windows Authentication,
use sp_grantlogin.
Ex:- EXEC sp_grantlogin 'Domain\WindowsUser'

No comments: