If you're using a DSN then take a look at what credentials it uses. Control
Panel|Administrative Tools|Data Sources

If you use Integrated Windows authentication then you can ADD 'Domain Users'
or 'Authenticated Users' as db_datareader on your SQL Server .....
Security|Logins

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Elbmag" wrote:
| The SQL Server uses "SQL Server and Windows" authentication. This server
and
| the users using the workbook are all on the same domain.
|
| I'm not sure what connection string I'm using. I set the query up within
| Excel using the data menu-import external data-new database query. I then
| choose a data source I had set up previously for that SQL Server.
|
| When I open the query editor and look at the SQL Statement that is
generated
| I do not see a connection string just the joings and so forth of the
tables.
|
| I appreciate any help or assistance you can provide.