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 :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
http://www.SQL-Server-Performance.Com
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.

---

]]>