This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

My boss's question

FormerMember over 9 years ago

We are upgrading to the new environment of SAM and NPM I believe, at least SAM I know that much for sure. My boss want to know if SAM 5.2 is capable of running on SQL Server 2012. He also want's to know if our production 5.2 and our test 6.1.1 is capable of communicating with the back-end database using an SSL connection. If anyone knows this or can point me in the right direction I would be much appreciative.

Top Replies

HolyGuacamole over 9 years ago +1

SQL 2012 should be supported since SAM 5.2 Windows 2012, SQL 2012, SQL 2014 and SolarWinds products SAM+NPM use the native SQL client to communicate with the SQL database. If you turn on the encryption…

Parents

0 mharvey over 9 years ago

I don't believe SAM 5.2 supported SQL 2012. I think that came along with 6.0. In regards to the DB connection, it already uses a secure connection to the database, it's not setup to use SSL though. The communication is encrypted however.
Cancel
Vote Up 0 Vote Down

Cancel
0 FormerMember over 9 years ago in reply to mharvey

Do you know if SSL can be enabled and solarwinds encryption can be shut off?
Cancel
Vote Up 0 Vote Down

Cancel
0 mharvey over 9 years ago in reply to FormerMember

No, the ADO connection that's used is in the code. I don't know of a way to change it.
Cancel
Vote Up 0 Vote Down

Cancel
0 FormerMember over 9 years ago in reply to mharvey

I appreciate your insight.
Cancel
Vote Up 0 Vote Down

Cancel
0 FormerMember over 9 years ago in reply to mharvey

I had to open a ticket with SolarWinds, the boss still wanted to know more. He said that SAM 5.2 is compatiable with SQL 2012 and enababling the SSL connection is possible and should be no issue as long as the port and SQL permission is set properly. This all comes from an enterprise standard that my company uses, lots of odd questions and little documentation of their answers. I still appreciate your insight.
Cancel
Vote Up 0 Vote Down

Cancel
0 mharvey over 9 years ago in reply to FormerMember

Not a problem. I'm a bit curious on how they said you can use SSL with SQL. How did they say you could enable SSL for SQL? Are they saying to use port 443 as the SQL connection rather than 1433?
Cancel
Vote Up 0 Vote Down

Cancel
0 FormerMember over 9 years ago in reply to mharvey

Well the guy retracted his statement and said that SAM 5.5 and later is compatible with SQL Server 2012. And they didn't tell me how to do it, just that it was possible. The link they sent me for it is here. http://www.solarwinds.com/documentation/Orion/docs/SolarWindsPortRequirements.pdf I have yet to read it for valuable content.
Cancel
Vote Up 0 Vote Down

Cancel

Reply

0 FormerMember over 9 years ago in reply to mharvey

Well the guy retracted his statement and said that SAM 5.5 and later is compatible with SQL Server 2012. And they didn't tell me how to do it, just that it was possible. The link they sent me for it is here. http://www.solarwinds.com/documentation/Orion/docs/SolarWindsPortRequirements.pdf I have yet to read it for valuable content.
Cancel
Vote Up 0 Vote Down

Cancel

Children

0 mharvey over 9 years ago in reply to FormerMember

That doc just tells you the ports that need to be opened for each server and app last time I checked. I'm not aware that it mentions anything on how to change the connection from SW and the DB server from a secure ADO connection to using SSL. Now, you can use SSL with the website. I'm wondering if that's what he's referring to.
Cancel
Vote Up 0 Vote Down

Cancel