I have two SQL Server 2008 located in different cities.
I have physical access to one of them and I can exec SQL Server Management Studio there.
For second server I have following parameters:
- remote domain name
- remote port
With these parameters I can connect to second server with SQL Server Management Studio.
But now, I have to create cross server queries. It is possible? How? :)
Do I have to add
Linked Server? How?
I see only this window, but where do I writer domain/port/login/password info?