I am running a linked server using windows authentication. WHen I run a query against the linked server it runs fine. However when I try to connect that to my ASP page and run that query i get an error. Everything else in the ASP site linked to this database runs fine, just not the linked server based query. I am getting the following error. I have impersenation set to true in my web.config as well.
This is ASP.NET 2.0, SQL 2005 linked to a SQL 2000 instance and Windows Authentication.
Here is my errors: any help?
TCP Provider: An existing connection was forcibly closed by the remote host.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.