Jump to content
JohnnyJoker

Move Database - Required Connection String

Recommended Posts

Hello,

we'd like to move our pcmonitor database from the current SQL Server (2014 Standard) in one Domain to another SQL Server (2016 Enterprise) in a different domain. The Pulseway Enterprise/Admin Server won't change and is already a member of the target domain.

As far as I remember the process would be:

  1. Stop Pulseway Services
  2. Backup DB on old SQL Server
  3. Create SQL Login for the Service on the new SQL Server
  4. Restore DB on new SQL Server
  5. Edit the connectionstring in the Registry (HKLM\SOFTWARE\MMSOFT Design\PC Monitor Admin\DatabaseConnectionString)
    1. The connection string is encrypted - what would be the required format?
  6. Edit the connectionstring in the Hosting folder for the follwing web.config files
    1. ..\Hosting\Service\web.config
  7. Start Pulseway Services

Did I miss anything important? If not, all I'd need would be the format of the connectionstring in the registry :)

Cheers, Jonathan

Edited by JohnnyJoker

Share this post


Link to post
Share on other sites

Hi Johny,

You simply need to update the connection string in the Admin\PCMonitorAdmin.exe.config and Service\web.config.

And then if you will open the app, then it will update the database connection string in the registry.

Share this post


Link to post
Share on other sites
Posted (edited)

Thanks for the tip - would've been quite easy but sadly I get a fatal error:

image.thumb.png.65eb4754e5e8bb30e344d652078088ec.png

 

The target SQL Server resides on a Windows Server 2016 - maybe that's a new one?

I don't see any failed login attempts in the target SQL Server's Error Logs nor any errors regarding this process in the Windows Event Log.

With SQLCMD the Connection succeeds and I can query tables.

Any ideas?

 

Edit: After some thinking - Server 2016 out of the box has different cipher suites and protocols active than 2012R2 and I have the idea to run IISCrypto (https://www.nartac.com/Products/IISCrypto) on the SQL Server and to try best-practices but it would be better if someone knows what to (de-)activate ;)

Edited by JohnnyJoker
Idea about Server 2016 - Cipher/Crypto

Share this post


Link to post
Share on other sites

Hi Johnny,

Use IIS Crypto to set the same cipher suite from one server to another. The error says that the SQL Server has no matching SSL ciphers / protocols with the source machine.

-Paul

Share this post


Link to post
Share on other sites

Thanks for the confirmation Paul!

I've snapshotted the server (just in case), applied IISCrypto Best-Practices and restarted.

The (previously) only database on the server and the corresponding application still work and the Pulseway database server switch went without a hitch.

Thanks everyone!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By ElasticIT
      Hi Guys,
       
      Not sure if this has been requested before so apologies in advance if it has. I had a customer with a slow PC and wanted to add the Disk Queue Length performance counter to see if that was causing the slowness however didn't want to have to log into her machine. Normally I would go via the Dashboard -> Edit Computer Settings and make whatever changes were necessary. However Performance Counters can't seem to be added this way as there is no Add button:

       
      Is this a bug or missing feature? If it's missing, it would be handy to have as you can pretty much do everything else from here and it's not always convenient having to log into the users machine
      Cheers
    • By Aspect
      I'm reasonably new to PW. I've just on-boarded 50 endpoints, and it automatically monitors Automatic services. That great, but Services like Bio-metric and Remote Registry; whilst configured as automatic, aren't always started.. So constant notifications.
      I know how to remove the service monitor, but is there an easy way to exclude certain services from being monitored globally?
    • By Aspect
      New Server - Win Srv 2012 R2
      SQL Server 2016
      Installation as per instructions.
      Seemed to go through without any errors. 
      Just no web service. Nothing in IIS.. Nothing.. 
      Turned off Firewall, just to test...
      No idea where/what to check.. Any ideas?
       
×