Monday, February 13, 2012

AD Startup script - Integrated Auth SQL 2000

I have a VB Script that will be running on all workstations on a
domain from the AD Startup script Global Policies. The script uses ADO
integrated authentication.
This script needs access to a database on SQL Server 2000
I added "Domain Computers" computer group to the DB for access but the
script fails.
Error Opening Connection
Error Description: Login failed for user 'NT AUTHORITY\ANONYMOUS
LOGON'.
Is it possible to use integrated authentication from a startup script?
The script works fine when I use a sql username/pass but its sensitive
info so I want don't want the username/pass passing clear text.
We will be setting up two way encryption, but would feel safer with
integrated.Once the user has logged onto the machine, if they run this particular
script does it also fail?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

No comments:

Post a Comment