Use the following sql script to create a linked server
EXEC sp_addlinkedserver
@server=N'RPT_SRV', -------Linked Server Name
@srvproduct=N'', ---- Product dy default blank
@provider=N'SQLNCLI', ----- Provider name for sql server
@datasrc=N'172.16.0.15\SQL2008'; -- Database source name (SQL Server instance)
