I made a report in Excel 2003 with an External Data Connection to our SQL Server 2000. The data connection is set to refresh when the file is opened. It works fine for me because I have full access to the SQL Server and databases.
But when a user opens the worksheet it asks if they want to refresh external data and when they say "OK" they get a Login Failure.
How can I fix the Connection String or whatever I need to do so users can refresh the data?