IF the EXISTS (SELECT * from sys. The servers WHERE name='jkMssql')
The exec sp_dropserver 'jkMssql', 'droplogins'

The exec sp_addlinkedserver 'jkMssql', ' ', 'SQLOLEDB', '192.168.1.22';
Exec sp_addlinkedsrvlogin 'jkMssql', 'false', null, 'SD', '12345678'.

Select * from jkMssql. Test. The dbo. Tebz


I so keyed server is established, at the time of two databases are 2008 r2 is normal, but when it comes to link the server is ms2005, local server is ms2008 occurs when

Link server "jkMssql" OLE DB access interface "SQLNCLI10" returned message "login timeout expired",
Link Server "jkMssql" OLE DB access interface "SQLNCLI10" returned message "to establish connection with SQL Server, the network related or specific instances of error, can not find or unable to access the Server, please check whether the instance name is correct and the SQL Server is configured to allow remote connections, for details please refer to the SQL Server books online,",
Message 5, level 16, state 1, row 0
A named pipe provider: unable to open connection with SQL Server [5].

Do I want to do?