![]() If Allow inprocess is selected and the provider is instantiated in the SQL Server process, the following error is returned: OLE DB provider "MSOLAP" for linked server "(null)" returned message "The following system error occurred: ". When configuring linked server options, make sure the Allow inprocess option is not selected. Before configuring a linked server connection, be sure to install the latest MSOLAP client library (provider).įor linked server connections to Azure Analysis Services, the MSOLAP provider must be instantiated outside the SQL Server process. ![]() SQL Server can connect to an Azure Analysis Services resource as a Linked server by specifying MSOLAP as the data source provider. Connect as a linked server from SQL Server ![]() To learn more, see Create an Office Data Connection (.odc) file. With older versions of Excel, users can connect to an Azure Analysis Services server by using an Office Data Connection (.odc) file. "Provider=MSOLAP Data Source= Integrated Security=SSPI Persist Security Info=True " Use the Windows account running the current process. Windows authentication (Integrated security) Microsoft Entra authentication with username and password "Provider=MSOLAP Data Source= User ID= Password= Persist Security Info=True Impersonation Level=Impersonate " Integrated authentication picks up the Microsoft Entra credential cache if available. Integrated Microsoft Entra authentication When connecting to Azure Analysis Services using the Tabular Object Model, use the following connection string formats: The protocol for East US 2 region is aspaaseastus2. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |