Linked Servers | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Linked Servers

Does 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 : Madhu

I’ve seen this article. Both servers are configured for mixed authentication and also try usign SP_ADDLINKEDSERVER EXEC sp_addlinkedserver
@server = N’srv1′,
@srvproduct = N”,
@provider = N’SQLNCLI’,
@provstr = N’;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.