OLEDB

Get-DbaOleDbProvider

Get-DbaOleDbProvider View Source Chrissy LeMaire (@cl) Windows, Linux, macOS Synopsis Retrieves OLE DB provider configurations registered with SQL Server for linked servers and distributed queries Description Returns the OLE DB providers that SQL Server knows about and can use for external data connections like linked servers, distributed queries, and OPENROWSET operations. This is essential for auditing your server’s connectivity capabilities and troubleshooting linked server connection issues. The function shows provider details including security settings like AllowInProcess and DisallowAdHocAccess, which control how SQL Server can use each provider.