use testDB go exec sp_addlinkedserver @server = 'avalanche', --Server for this connection going forward. @provider = 'MSDASQL', @datasrc = 'iAvalanche64', -- DSN Name @provstr = 'Database=cms;user=cms;password=sl33py', --Login information. Suggest ID for ODBC specifically @srvproduct = 'cms_net' -- cms_net if you used that on the DSN or cms_ if you used that. exec sp_addlinkedsrvlogin @rmtsrvname=N'avalanche', @rmtuser = 'cms', @rmtpassword = 'sl33py', @useself=N'False',@locallogin=NULL go