Category: SQL Database

SQL SERVER – None of the IP addresses configured for the availability group listener can be hosted by the server Either configure a public cluster network. Error: 19456

Requirement: Add a node to availability alwayson group. It’s an multi-subnet and the node is a DR node on a different subnet. It is a three node cluster two in same data center (US East) and third node is in DR (US Central). Node A – 172.28.76.12 Node B – 172.28.76.13 Node 3 – 172.29.77.14 …

Continue reading

Microsoft SQL Server 2016 Cluster installation

Step by Step installation of SQL Server 2016 cluster. SQL Server 2016 Cluster is similar to SQL Server 2008R2 but in SQL Server 2016 you can configure the TEMPDB during installation.   Please download the PDF version. SQL Server 2016 Cluster.   Enjoy the SQL cluster Installation in case any issue you can reach me …

Continue reading

Important Points before backing up the SQL Server Databases

Important Points before backing up the SQL Server Databases. Backing up SQL Server databases is one of the important job to protect the data. Consider the below points while planning and backing up the databases. 1. One of the important step is the Backup plan. Most of the DBA only consider the user database backup …

Continue reading

Windows server 2012 failover cluster Error:There are currently no logon servers available to service the logon request

Getting below Error while building windows 2012 failover cluster. ……………………………………………………………………………………………………………………………………………………….. Checking for account information for the computer object in the ‘UserAccountControl’ flag for CN=SQLDBCLU,CN=Computers,DC=abc,DC=co,DC=in. Set password on SQLDBCLU. There are currently no logon servers available to service the logon request. Unable to successfully cleanup. An error occurred while creating the cluster and the nodes will …

Continue reading

InnoDB: WARNING: over 67 percent of the buffer pool is occupied by lock heaps or the adaptive hash index! Check that your transactions do not set too many row locks.

Today one of my friend reported error message in one of his MySQL 5.6.35 Community Version. InnoDB: WARNING: over 67 percent of the buffer pool is occupied by lock heaps or the adaptive hash index! Check that your transactions do not set too many row locks. InnoDB: Your buffer pool size is 127 MB. Maybe you should …

Continue reading

SQL Server Agent service failed to come Online on the Active Node in a 2 Node Fail-over cluster.

SQL Server Agent service failed to come Online on the Active Node in a 2 Node Fail-over cluster. Error Messages in the Event-logs. [sqagtres] OnlineThread: ResUtilsStartResourceService failed (status 435) [sqagtres] StartResourceService: Failed to start SQLSERVERAGENT service. CurrentState: 1 [sqagtres] OnlineThread: Error 435 bringing resource online. To understand the problem, we have to check the AgentError …

Continue reading

Error 1530, User Profile Service in Event Viewer

Problem: Getting below messages frequently in Event Logs. Windows detected your registry file is still in use by other applications or services. The file will be unloaded now. The applications or services that hold your registry file may not function properly afterwards. DETAIL – 16 user registry handles leaked from \Registry\User\S-1-5-21-2838966446-1611402468-3389684964-82091: Process 604 (\Device\HarddiskVolume2\Windows\System32\lsass.exe) has …

Continue reading

SQL Server 2008R2 Setup “Error 0x80070490”

Getting below error while installing SQL Server 2008 R2 in cluster. …………………………………………………………………………………………………………………………………………………………………… SQL Server Setup has encountered the following error: Element not found. (Exception from HRESULT: 0x80070490) ……………………………………………………………………………………………………………………………………………………………………   Solution: The above error usually come, if there is offline disks in the custer which you can see when you connect to Failover Cluster Manager and than go …

Continue reading

How to find SQL Server License type!

I got  question from one of my friend that “How to check the license type in Microsoft SQL Server 2012 via SQL server.”   Solution: There are multiple methods in SQL Server to find the license type in SQL server. Before SQL Server 2008 R2 there used to be properties maintained  but in SQL Server 2012,  you can …

Continue reading

Initializing the FallBack certificate failed . TDSSNIClient initialization faile

Getting below error while doing failover of database in Active Passive cluster. Error: 17190, Severity: 16, State: 1. Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0. Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate. …

Continue reading

WP2Social Auto Publish Powered By : XYZScripts.com