Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Synonym to a linked server

Author  Topic  JNunes Starting Member 1 Post Posted - 2009-01-09 : 04:11:25 I´m using a synonym to a table in a linked server. All work great on SSMS but with any application that was developed in Win32 i can´t get it to work, it returns "Communication link failure". I´m using SQL 2008 Express, where I created the linked server and the synonym. This linked server points to a Database in a Server running Sql Server 2005 Express. The linked server is called PRIREMOTE and the Synonym PRIClient. The funny thing is that with a select like "select * from PRIREMOTE.pribeltiga.dbo.clientes" all works fine but with the synonym PRIClient "select * from Priclient" returns the message above. Can anyone please help me on this or give a clue how to fix this. Many thanks in advance