Checking the reachability of SQL Server is one of the key points. After successfully installing the SQL server, the DBA job is to make sure the server is reachable to other required servers such as application servers. Ideally, to check the reachability, we can use SSMS to connect to that SQL instance, but it is
Changing tempDB location from the C drive to another drive or location in SQL Server 2022 or any SQL version Here, in our case, from C Drive to D drive Solution: Step 1: script out – script To move the location of the tempdb database, we must make a script with all logical names and
After installing SQL Server 2022, it is time to configure alwayson availability groups for high availability. Let us understand our setup: Before starting the process of Configure alwayson: Configure AlwaysOn in SQL Server 2022: How to enable Always on High Availability Feature in SQL Server 2022?
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
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: