SQL services failing to start

Here is a weird scenario which my client faced where the SQL services failed to start. Tried to start it from SQL server configuration manager and services but the request timed out. Later tried using the command prompt (admin privilege) by entering the executable path and here is the exception that was thrown, Tried to…

0

Encountered issues getting the SQL server and SQL agent cluster resources online

A couple of days back, when I was troubleshooting an issue related to SQL Fail-over cluster instance upgrade I encountered this strange issue of not able to get the newly added SQL server and SQL agent resources online. This scenario was observed on a SQL 2014 clustered over a Windows Server 2012 R2 operating system….

0

Public certificates vs Private certificates vs Self-signed certificates

Do review this information to give you a better understanding on the different types of certificates and also to determine which type of certificate best suits your business needs. The choices that you have for obtaining your certificates include: Public Certificates – Purchasing your certificates from a public Internet Certificate Authority (CA). Private Certificates – Operating…

0

Facing issues with applying SP2/SP3 for SQL 2008 R2 FCI

One of my clients happened to encounter an issue upgrading the SQL server 2008 R2 instance from SP2 to SP3. We were able to pass the major part of the wizard and at the final Installation Progress bar stage we faced issues and the upgrade failed for us with the below error recorded in the…

0

Troubleshooting SQL Server Upgrade Issues

Recently, one of my partners, were facing issues upgrading SQL server 2008 from Service Pack 2 to Service Pack 3.  On checking the summary.txt in the setup bootstrap logs found the following error information : —————— Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the log…

0

Installation of SSDT for BI on SQL 2014

A few days back, I was working with one of our partners who had a requirement of installing SQL Server Data Tools (SSDT) for Business Intelligence on their SQL server 2014 instance. When it comes to the same scenario in SQL 2012, the installation of SSDT is a straight forward procedure by selecting it on…

0

How to PREVENT TRUNCATION of TABLES?

One of my clients’ requirement to prevent the TRUNCATION of tables on the database by their applications led me to the research on this topic. We helped them with the information related to the DELETE of records by configuring SQL server audit where we get the data related to the DELETE operation in the Audit…

0

SSL on SQL – Troubleshooting

It is one of the pre-requisites for the KEY-SPEC value of the SSL self-signed certificate to be set to 1, for it to be loaded to the SQL server. Due to the glitches during the creation of the certificate there may be scenarios arising where in this value might not be set to 1. If…

0

SSL on SQL – Foundation

A few days back, I was working with one of our partners who had a requirement of creating a SSL self-signed certificate through MMC console. As we are already aware that it is a complex and a tedious procedure, tried developing a script to ease the task for us. Also found that there were a…

0