Friday, 13 November 2015

SQLSvr 2012 Enterprise Failover cluster installation fails with error "Could not find the Database Engine startup handle"


While doing the 2012 SQL Failover Cluster Installation , received the below error in the last stage and not able to start your DB Engine and Agent Services .

SQL Svr 2012 Enterprise EN\ Failover cluster installation fails with error "Could not find the Database Engine startup handle"

In the SQLServer Error Log , we could see the below error message ,

TDSSNIClient initialization failed with error 0x80090331, status code 0x80. Reason: Unable to initialize SSL support. The client and server cannot communicate, because they do not possess a common algorithm

FIX: You cannot use the Transport Layer Security protocol version 1.2 to connect to a server that is running SQL Server 2014 or SQL Server 2012


Resolution

1. Enable TLS 1.0 & SSL 3.0 under [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\ in windows registry .
2. In case you want to use any other protocol e.g. TLS 1.2 then you have to apply Cumulative Update 6 for SQL Server 2012 SP2 .


Reference 



Thursday, 16 July 2015

Reporting Services Configuration Tool unable to connect Instance error - In windows 2012 server having SQLServer 2008/R2 named instance

When opening the Reporting Services Configuration Manager attempting
to connect to a named instance, no instances are available in the Report Server Instance drop down list, and when the find button is pressed the error

 "No report servers were found.
 Details:
 Invalid Namespace"

Resolution
Go to the path -Microsoft SQL Server\MSRS10.SQL2008\Reporting Services\ReportServer\bin\reportingservices.mof .
Take a backup of the file before modifying
Replace the the instance name in all places with your correct instance 
name in the .mof file . your named instance is SQL2008
//Name = "RS_SQL2008" change to Name = "SQL2008"//
Next Step : Open cmd as Administrator and Run the below command
mofcomp.exe "C:\Program Files\Microsoft SQL Server\MSRS10.SQL2008\Reporting Services\ReportServer\bin\reportingservices.mof"



                                  

After doing this , Please Restart WMI Services from Services.msc
and open Report Service configuration Manager console.
This time you will be able to see the Server and Instance details .
Good Luck