Sometimes if the sequence is not followed correctly, we might see some weird errors. In this blog, we would learn how to fix always on an error while adding new replica “The specified instance of SQL Server is hosted by a system that is not a Windows Server Failover Cluster(WSFC) node.”
SQL SERVER – SQL Service Not Getting Started Automatically After Server Reboot While Using gMSA Account
This was the first experiment with gMSA account in my lab and I faced an interesting issue. In my lab environment, I have a complete domain server and member servers. Once I configured gMSA for SQL Server service and restarted the machine, SQL Service didn’t start automatically even though it was set for an automatic startup as shown below.
SQL SERVER – Error: 18456, State 149 – Login-based Server Access Validation Failed With an Infrastructure Error. Login Lacks Connect Endpoint Permission
Sometimes while reproducing a situation results in another new error and I get an idea for a new blog. In this blog we would talk about an error Login-based server access validation failed with an infrastructure error. Login lacks connect endpoint permission.
SQL SERVER – FIX: 3637 – A Parallel Operation Cannot be Started From a DAC Connection
This was indeed one of an interesting error which I have never seen earlier and it is about DAC Connection.
Here is the complete error message which my client reported.
SQL SERVER – Upgrade Error – Cannot Drop the Assembly ‘ISSERVER’, Because it Does not Exist or You Do Not Have Permission
A few days back, I published the blog on the same error message and one of the blog reader responded and ask how can I generate the script if I don’t have another SQL Server? In this blog, we would learn how to fix error Cannot drop the assembly ‘ISSERVER’, because it does not exist or you do not have permission.
Why is SQL Server Consolidation Better Than Having a Scattered Environment?
Having a scattered Microsoft SQL Server database platform is cumbersome to maintain, as you continue to accumulate waste capacity to your database servers. Therefore, you should consider consolidating your platform to make it more manageable. Let us learn about Why is SQL Server Consolidation Better Than Having a Scattered Environment?
PostgreSQL – Storing Unicode Characters is Easy
One of the interesting features of PostgreSQL database is the ability to handle Unicode characters. In SQL Server, to store non-English characters, we need to use NVARCHAR or NCAHR data type. In PostgreSQL, the varchar data type itself will store both English and non-English characters.