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

What is Azure ?

Azure is a Microsoft public cloud computing service. This is a world wide network and providing services like Compute, Analytic, Storage, data management, Network and security. They can run the applications on the internet also providing the BI tools to explore. In Azure you can Build, Test and Deploy application. You can ensure your data safety in the Azure cloud network. The platform is mainly helpful for saving money and having High speed interface no matter where they are accessing. Advanced services like predictive analysis are integrated in the environment.
Using the BI Tool of SSIS we can import or export data to the Azure cloud service.

What is Azure ? was last modified: October 1st, 2017 by Justin Antony

Tabular Model in SSAS

Tabular Model SSAS

Tabular models are in-memory databases in Analysis Services. The xVelocity in-memory analytics engine (VertiPaq) delivers fast access to tabular model objects and data by reporting client applications such as Microsoft Excel and Microsoft Power View.

Tabular models support data access through two modes: Cached mode and DirectQuery mode.
In cached mode, you can integrate data from multiple sources including relational databases, data feeds, and flat text files.
In DirectQuery mode, you can bypass the in-memory model, allowing client applications to query data directly at the (SQL Server relational) source.

Tabular Model in SSAS 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

What is a KPI in SSRS ?

SSRS KPI

               SQL Server Reporting Services allows you to embed indicators and Gauges in your report to analyze the data and its state. Indicators are minimal gauges that convey the state of a single data value at a glance and are mostly used to represent state value of Key Performance Indicator (KPI). Dragging an indicator to report designer will bring up a dialog box where you need to choose the type of indicator that you want to add to your report. There are several indicator types to choose from like Directional, Symbols, Shapes and Ratings and you can customize them all with different colors (other than their default color)
What is a KPI in SSRS ? was last modified: October 1st, 2017 by Justin Antony

SSRS Report giving the ERROR Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 500.

SSRS Report giving ERROR Sys.WebForms.PageRequestManagerServerErrorException

To resolve this issue go to the following path

C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportManager

Open web.config file

Original
< httpRuntime executionTimeout=”9000″ />
Modified
< httpRuntime executionTimeout=”9000″ maxRequestLength = “50000” />

 

Add below code inside the Report Manager and Report Server folder

</system.web>

<appSettings> <add key=“aspnet:IgnoreFormActionAttribute” value=“true” />

<add key=“aspnet:MaxHttpCollectionKeys” value=“100000” />

</appSettings>

<runtime>   Note: We need to add before Run time and after Sytem.web file

 

Regards

JA.

 

 

SSRS Report giving the ERROR Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 500. was last modified: October 1st, 2017 by Justin Antony