Sample Header Ad - 728x90

Unable to select "other data source" when creating linked server

0 votes
0 answers
313 views
I am unable to select the option for Other data source when creating a linked server in SSMS, because the option is completely grayed out. I have installed Microsoft OLE DB Driver (MSOLEDBSQL) for SQL Server but nothing shows up under Server Objects > Linked Servers > Providers. !(https://i.sstatic.net/BeDsrIzu.png) The only errors I see in errorlog are about SSISScaleOutMaster160 failing to open the SSISDB database, but we don't have scale out enabled. This is all on an Enterprise Evaluation copy of SQL Server 2022, but I still have 48 days left on my evaluation. I would appreciate any guidance in making the OLE DB drivers work so I can create a linked server using them. Thank you.
Asked by Travis Dean (1 rep)
Jul 3, 2024, 05:25 PM
Last activity: Oct 16, 2024, 08:45 AM