Here is the simple step-by-step guide to install SSAS (SQL Server Analysis Service 2019) with screenshots. Setup: Before you start installing SSAS: Installing SSAS 2019: If your setup file is ‘.ISO’ then we need to mount the SQL Server setup file We should run the mounted file If your setup file is not ‘.ISO’ then
We are getting an error while installing MSOLE DB driver 19 for SQL Server as it is looking for a ‘Microsoft Visual C++ Redistributable for Visual Studio 2022 ’, We can fix the MSOLEDB driver issue by following the below simple step-by-step procedure. From the above error screenshot, we understand there is a dependency to
Here is a simple step-by-step guide on how to install SQL Server 2022 with screenshots. Before the installation: Installing SQL Server 2022: Mount SQL Server 2022 ‘.ISO’ file Before connecting to the installed SQL Server:
This is the most common issue in generic SQL Server environment and most likely due to Kerberos authentication issue. Just create required SPN’s on all involved SQL Servers and it should be working fine. In our case, we have upgraded (in-place) SQL server from 2019 to 2022. After our successful upgrade of SQL Server to