asked on

Users get Login Failure when opening Excel file with External Data Connection to SQL Server

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?

Thanks.

SQL_SERVER_DBA

their gonna need read rights on the tables that refresh the excel file

Saurabh Singh Teotia

Well...Try defining your query through this...

Go to --->Data-->Import External Data-->Import Data...

As soon you click on it...It will take u to your data sources..where u find some options...

Inwhich one of the option will be
"New SQl Connection"...Select that and click okay...

a Window will open which will ask for in step-1 the server name.
and in step-2 u can define the user name and password by which u want to connect to sql..so everytime the query will use this id and password only.......

Hope this helps...

ASKER CERTIFIED SOLUTION

dqmq

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

James Murrell

windows authentication in your connection string

http://support.alphasoftware.com/alphafivehelpv8/Webpub/Create_Database_Connection_String.htm

David Megnin

ASKER

Worked like a champ after the user rebooted her computer.