SQL Server 2005 Express Linked Server - by JBurdie

Status : 


Sign in
to vote
ID 170800 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 7/25/2006 11:59:05 AM
Access Restriction Public


Second try, First feedback did not show in list.
When creating a Linked Server in SQL Management Studio, I cannot get to the Provider Options dialog to set "Allow InProcess" and "Use Index as Access Path" attributed for my 3rd party OLEDB Provider (an Index class provider).  Help sugests right-click on provider name in tree list but I only get a pop-up menu with "Refresh" selection.  In SQL Server 2000 the Provider Options were accessed via a button under the provider selection drop list in Enterprise Manager.
Sign in to post a comment.
Posted by Microsoft on 8/8/2006 at 1:18 PM
Hi Jim,
    Thank you very much for pointing out the problem with SSMS-E connecting to Linked Servers. For the first release of SSMS-E, we made the intentional decision not to support Linked Server dialogs in this free version of SQL Server Management Studio. The behavior you want is in the full version of the SQL Server. We plan to address the additon of these dialogs in the next major release of SQL Server. In the meantime, you will need to use the T-SQL commands for linked servers such as:
- sp_addlinkedserver - you can use the @provstr property to set the connection parameters for the OLEDB provider
- sp_addlinkedsrvlogin - setup the permissions to connect

Thank you,
Bill Ramos