SQL Server Performance Forum – Threads Archive
Linked ServersDoes anyone know if it possible to create linked servers between sql server 2005 and 2000?
it is same like in SQL 2000
Read sp_addlinkedserver ,sp_addlinkedsrvlogin in BOL From SQL mangement studio Server –>Server Object –>LinkedServer Right Button on Linked Server and follow the instruction Madhu
But is it possible to create linked servers between 2005 & 2000?
Yes, why not.. you can even create linkedserver to Oracle,Mysql,Excel,Access etc…. did u try Madhu
I did, but it keeps coming up with an Error 18452 Login failed message. I can however successfully link it to a 2000 server.
hi Pse read this :http://support.microsoft.com/kb/555332 Madhu
I’ve seen this article. Both servers are configured for mixed authentication
http://sqlserver2000.databases.aspfaq.com/how-do-i-prevent-linked-server-errors.html and also try usign SP_ADDLINKEDSERVER EXEC sp_addlinkedserver
@server = N’srv1′,
@srvproduct = N”,
@provider = N’SQLNCLI’,
@provstr = N’SERVER=xxx.xxx.xxx.xxx;Integrated Security=True’ Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.
I have now managed to solve the problem. I had to switch off the enforce password expirations in sql server 2005 logins to solve the problem.