Deepak Bhardwaj

IT Consultant of almost 10 years of experience with various business vertical in IT Infrastructure Service, methods, processes, strategic technology infrastructure planning, and developing cost effective solutions to meet customer business requirements.

Author's posts

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

MySQL 1032 and 1062 Error

I have updated the MYSQL using “mysql_upgrade” command and after that getting  error “1032 and 1062”. We can ignore it, until replication has continued without error: Refer the below steps :- Edit the my.conf file Vi /etc/my.cnf 2. Than enter the below parameter in the My.cnf file. slave-skip-errors=1062 slave-skip-errors=1032 3. Save the file and restart the MYSQL service. …

Continue reading

The “Cluster Service” service terminated unexpectedly. It has done this 6 time(s). The following corrective action will be taken in 960000 milliseconds: Restart the service.

Environment: Windows Server 2008 R2 “2” Node cluster configured on 2 physical server with Network teaming. Problem: The Cluster Service “service” terminated unexpectedly. It has done this 6 time(s). The following corrective action will be taken in 960000 milliseconds: Restart the service. Event ID : 7031 Solution: Step 1. Generate the cluster log to understand …

Continue reading

SQL Server 2012 Cluster Deployment Steps!!

Friends refer the below document link for SQL Server 2012 cluster deployment. SQL Server 2012 Cluster Enjoy SQL Cluster..   Incase if you face any issue mail me i will help you.

Microsoft announcing SQL Server on Linux

Friends Microsoft announcing SQL server on Linux which will be introduced soon… http://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/#sm.00001vvqr6zhrid71ptal9tx85one    

Windows 2012 cluster Fails with Error message Receive : There are currently no logon servers available to service the logon request

While Creating Windows 2012 cluster getting Error Message: “There are currently no logon servers available to service the logon request”   After troubleshooting the issue, Problem was identified that port 445, 464 “TCP/UDP” is blocked at firewall end from database Node and Active Directory. Role of 465 and 464 port “Replication, User and Computer Authentication, …

Continue reading

Database Mirroring cannot be Enabled!!

One of my college is trying to configure database mirroring in SQL Server 2008R2 instance and getting the error message. Error Msg 1469 “Database mirroring cannot be enabled because the database is an auto close on one of the partners.” Solution: Based on the error message I asked to check the Properties of Database and parameter “auto-close” …

Continue reading

WP2Social Auto Publish Powered By : XYZScripts.com