Two SQL Server2000 servers Access to the implementation of the link server, recently upgraded the A server to Windows Server 2003, and then allowing a storage task, which has always appeared as follows:
Perform user: NT Authority / System. OLE DB Provider 'Sqloledb' error. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE DB Error Trace [OLE / DB Provider 'Sqloledb' IDBinitialize :: Initialize Returned 0x80004005:]. [SQLSTATE 01000] (Error 7300). Step failed.
The configuration of the two servers is as follows:
A: Windows2000 Server SQL Server 2000 (After upgrading to 2003)
B: WINDOW 2000 Adv Server, SQL Server 2000
For 2 years, it has been running normally, and the stored procedure that is automatically executed after upgrading to 2003 has an error, which is the above error. The solution is to select "Use this Security Conclusion" on the "Security" page of the Properties page of the link server, and set "Remote Login" and "Use Password".
