Linked Server Configuration

When Im going to configure Linked server Its giving the error massege asying that

"Error 15028: The server 'JOY' already exists.

How can i solve this?

Thanks

It seams the server is already exsits..

Try the following query to check the server is alreay exist or not..

Select * from Sysservers

And check the column isremote, to test the server is remote or logical server.

If the name is already listed on this table, try to use the different....

|||

I had a similar situation. I ended up just wrapping a TRY-CATCH around procedure. Something along the lines of...

BEGIN TRY

EXEC sp_addlinkedserver {whatever}

END TRY

BEGIN CATCH

PRINT 'Server already linked.'

END CATCH