Linked server conncetion error

Hi All,
I created a linked server from sql 2008 to sql 2000 server with a local login pn sql 2008 with impersonate to slq 2000 server.

but I'm gettgin this error when that ID I used there is trying to make connection using linked server to sql 2000.

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

how to fix this, can some one help me plz?

Who is Participating?
Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
Please remove impersonate and add credentials in boxes.
msdbaAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.