I don't even know if my title is a fair explanation of my problem, sorry if it isn't.
We are on a network using AD, probably a very typical scheme. My SQL Server is 2005 on a Server 2008 Enterprise machine.
My boss had written for him a VBS which will prompt the user for the server name, then Database name and the upload a specific CVS into the proper SQL tables. As a user who is a member of the AD Administrator group, I can run the script no problems. However
the person who needs to run this script on a regular basis gets an error in a "Windows Script Host" dialog box. The error is "Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user 'CC\maurice'."
I thought it may be how the SQL drivers are setup on his machine, but when I log in through his computer, I can run the script fine. Is this a setting my SQL server, or is it actually an AD issue I am dealing with?
Thanks for reading.
View Complete Post