By Garth Jones
When you setup your SSRS reporting services point for ConfigMgr, you need to verify the database details.
After clicking the verify button (green arrow) you may get an error (red arrow). What do you do?
Hover over the error icon to see the actual error message. The error message will look similar to the following screenshot, and it reads:
Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was – [Pre-Login] initialization=21016; handshake=6;
In our case we determined that it was a firewall issue and opened the SQL ports.
If you think you have a similar issue, simply turn off the firewall on your SQL server and try the verification again. You will need to restart the Wizard in order to do this, but if the verification works, you know it is a firewall issue, so you need to open the appropriate SQL ports. If the verification doesn’t work, then you will need to dig deeper in order to understand the problem.