error 18456: login failed for user on a SQL Server 2000 reading from SQL Server 2005 RRS feed

  • Question

  • Hi,

    I have an issue where the following has occured:

    (1) Migrated databases from SQL Server 2000 to a SQL Server 2005 db server;
    (2) Kept the collations the same;
    (3) Security is the same;
    (4) Using Mixed mode authentication
    (5) Am able to link SQL2000 databases while within the SQL2005 server;
    (6) But get the 'error 18456: login failed for user' while trying to view tables/views fom the created linked server in SQL2000.

    Any ideas?

    Friday, March 27, 2009 5:00 PM

All replies