Microsoft Query - datasources - SQL Server error. 1

[brialex]

I created a query within SQL that I am trying to use as an external datasource within excel. I made my connection to the SQL server and told it which table I wanted to use. Everything seems to work just fine under my login but when someone else tries to open the file that is not a domain adminstrator they get the following message:

Connection Failed:
SQL State '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user 'OGDENPUBS\shorton'.

What am I doing wrong that is causing this error? Any suggestions?

 

[xlbo]

do they have access to the table in question ??

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[brialex]

Yes the should have access to the table. The table has permissions set to all users. I have other reports that are pointing to the same server just a different table and they are working fine.

Trisha

 

[xlbo]

Well, that error message means that for whatever reason, that person's user ID does not have the required permissions on either the database or the table - either that or they DO have permissions but require a password - which is either not being passed or is being passed incorrectly

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[brialex]

Thanks!