SQL Server 2017

SQL Server 2017/2019 Reporting Services Edition Upgrade

by

Few days back, one of our customer reported that his SQL Server 2019 reports were not accessible. We had a look at SQL Server Reporting Services logs. We observed below error messages in log: We checked edition for database engine as well as reporting service. We were not surprised to know that it was evaluation … Read more

Always ON Group Failover not happening in SQL Server 2017

by

We had one activity planned which was related to windows hostname and SQL server name change. DB Servers Setup Information: It was a 2 node windows cluster, Node1 & Node2. SQL server Always On was configured on this setup. 4 Synchronous Always On Groups (AG1, AG2,AG3,AG4) were setup and Node1 was acting as Primary. Always … Read more