To mimic a multi-SQL Server environment of one of our clients on a single server, I needed to link the SQL Server to itself. If found several suggestions by googling it, but only this one worked for me:
EXEC sp_addlinkedserver @server=’alias’, –the name of the linked server
@datasrc=’.’,–the data source
The other suggestions I found, used the same approach, but with a different provider. SQLNCLI worked for me.