If you're only doing read-access to the other server, create a specific user on the server and redirect all access to that new user. For an even more secure environment, make the new user a member of the db_datareader fixed database role.
-Mike
>Michael,
>
>Thanks, it looks like that might help us. I am still getting:
>
>Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
>
>when I try to run a query such as:
>
>SELECT * from OpenQuery(STL_KF, 'SELECT * FROM hd WHERE file_num = ''FORKEARS''')
>
>so I guess I need to work on the security aspect some more.
>
>As it turns out, I may not need to access a different database. I haven't completely figured out how the guy before me accessed the data, though it looks like a very complex object-oriented framework utilizing ADO.
>
>If you have any ideas about the above error I am getting and how to resolve the security issues, I would be very appreciative. Thnaks for your help so far!
>
>Thanks,
>JoeK