Matthew Clifford (10/12/2010)
Does the SQL Server you are trying to reach on the server or is it on another server?
If it is on another server I bet you are getting into a kerberos problem.
If you want to check your Keberos for a web server I found this utility great for troubleshooting my problems.
http://www.iis.net/community/default.aspx?tabid=34&g=6&i=1887%5B/quote%5D
"Is it a web application" - Kind of. The part of the application that is trying to do the linkedserver query IS a web page.
The application runs from multiple application servers, then there is a SQL Server on a different server, then there is a 2nd SQL Server which is where my data resides (hence the linkedserver query). So I'm guessing it's the kerberos thing that you said, since the application and database are on different servers...I'll try your link.
Thanks