Desktop Authority and Firewall issues

We have installed ScriptLogic Desktop Authority on a server and needed to install a short cut on our workstation so that we don't have to log in to the server each time we need to work on the application. After we create the shot cut and tried to launch the Desktop Authority Console we got the following message:
"The Desktop Authority Manager requires that the 'Desktop Authority OpsMaster Service' is running."

Checked the service on the server and it was running and we were able to launch the application on the server, so we turned-off Windows Firewall on the server and launched the application without any issues. So, we used TCPView tool to find which port we need to open on the firewall. The output from the tool showed the following:

It shows the remote port 8017 on the server is blocked. So, we went back to the server and created an exception for port 8017 and enabled the firewall again, and we were able to launch Desktop Authority from the workstation.

ScriptLogic "A connection to the database could not be created. would you like to select s different database?"

I was assigned a task to install and configure ScriptLogic Enterprise Security Reporter 3. Everything seemed to go well until we launched the Discovery Console from the start menu. Every time we launch the console we get the following dialog box:

If we click on Yes then a new dialog box open for us to select the database in order to connect to it:

This becomes annoying, and it seems that something is blocking the connection. So, in the process of troubleshooting, we disabled the firewall on the SQL box and  everything worked fine and we no longer got the dialog box that we need to connect manually to the database. However, disabling firewall is not recommended and we determined to find which port needs to be opened on the SQL machine, so we downloaded Sysinternal Suite from Microsoft site and used TCPView and got the following output:

As we see from the previous screen shot that we need to open port 50972 on SQL firewall, and once we did that everything worked fine and we no longer get the dialog box.

Here is a good TCPView output:

You gotta love Systinternals Suite

That's all