If you are using OLE DB Provider for SQL server, put 'SSPI' on the Integrated Security property of your connection.