32-bit ole db provider “msolap” cannot be loaded in-process on a 64-bit sql server

msolap cannot be loaded
The issue occurs if you rebuild index sometimes due to registry corruption

For this issue you need to deregister and register the dll files again. This will basically overwrites the 32 bit dll with the 64 bit dll.

Deregister Steps:

regsvr32 /u “C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\110\msolap110.dll”

regsvr32 /u “C:\Program Files\Microsoft Analysis Services\AS OLEDB\110\msolap110.dll”

Register Steps:

regsvr32 “C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\110\msolap110.dll”

regsvr32 “C:\Program Files\Microsoft Analysis Services\AS OLEDB\110\msolap110.dll”

32-bit ole db provider “msolap” cannot be loaded in-process on a 64-bit sql server was last modified: October 1st, 2017 by Justin Antony

How to create proxy for SSIS Job?

create proxy SSIS Job
This involves multiple steps when creating the Proxy

Step 1 : Create a proxy login
Server Role : BulkAdmin, Public
Select the needed databases in user mappings including ssisdb,msdb
securables: Add the server to run proxy account
Permission : Connect SQL -> Sa(Grantor) -> Select the tick mark for Grant
Effective:
Administrater Bulk Operations
Connect SQL
View Any Database
Step 1: Create the credential
Right click Credentials -> New credentials
Select the login (proxylogin) and provide password
1. Go to Proxies – > ActiveX Script (Right Click) -> New Proxy
2. Give Proxy name
3. Select the Credential
4. Select the following

Active X script
Operating System (CMDEXEC)
SQL SERVER Analysis Services Command
SQL Server Analysis Services query
SQl Server Integration services PAckages
PowerShell.

  1. Select Principle
    Add the principle account

 

Regards

Author.

 

How to create proxy for SSIS Job? was last modified: October 1st, 2017 by Justin Antony