This issue occurs due to the values mismatch in the RSWebApplication.config Go to path : C:\Program Files\Microsoft SQL Server\\Reporting Services\ReportServer Edit the above mentioned file. Add these 2 values: 1. http://Server/ReportServer/
2. Change the value for SecureConnectionLevel to 0 Issue resolved!!!
1. Go to HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command
2. Double click default
3. Change value from
"C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE" /dde
"C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE" /e "%1"
Repeat the above for Excel.Sheet.12 Thanks: https://www.youtube.com/watch?v=xhtRoIP33H0 https://support.microsoft.com/en-in/kb/3001579
Fix/WorkAround/Solution: Try all the suggestions one by one.
Suggestion 1: Make sure that on Mirror Server the database is restored with NO RECOVERY option (This is the most common problem).
Suggestion 2: Make sure that from Principal the latest LOG backup is restored to mirror server. (Attempt this one more time even though the full backup has been restored recently).
Suggestion 3: Check if you can telnet to your ports using command TELNET ServerName Ports like “telnet SQLServerName 5023”.
Suggestion 4: Make sure your firewall is turned off.
Suggestion 5: Verify that the endpoints are started on the partners by using the state or state_desc column the of the sys.database_mirroring_endpoints catalog view. You can start end point by executing an ALTER ENDPOINT statement.
Suggestion 6: Try the following command as one of the last options.
GRANT CONNECT ON ENDPOINT::Mirroring TO ALL
Suggestion 7: Delete the end points and recreate them.