EXEC sp_dropserver 'IdealServer','droplogins';
exec sp_addlinkedserver 
@server='IdealServer', 
@srvproduct= '', 
@provider='SQLOLEDB', 
@datasrc='70.147.196.205,1433', 
@location='', 
@provstr ='DRIVER={SQL Server};SERVER=70.147.196.205,1433,2433;UID=sa;PWD=Ideal';
EXEC sp_addlinkedsrvlogin 'IdealServer', 'false', NULL, 'sa', 'Ideal';