Surya R. Balusu 
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 successfully configuring alwayson availability groups with a listener name in SQL server 2022, we got a situation where we should change the listener name. Let’s check our setup before changing the listener name. Our Setup: Our existing listener name is ‘DBLIS’ and we should change this to ‘SECDBLIS’. There is no way we can
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?
Our SSRS reports failing with the following error. Authentication failed because the remote party has closed the transport stream. We have recently upgraded SQL Server Reporting Services (SSRS) from 2016 to 2022 and all the subscriptions both data-driven and standard are failing with authentication failure errors (SSRS Reports failing). This upgrade we did as part