Post date: Apr 26, 2011 3:07:29 AM
It depends on how you are doing the linked server. If you do it via the SQL Server or Other Data Source option.
Try using SQL Server, and the linked server name should be in the form of
ServerName\InstanceName
An example is attached.
Linked Server
Here is the security settings and also the select statement to show that it is working with the linked server.
Security
Results
-Courtesy amenkes: