Jump to content

Move Database - Required Connection String

Recommended Posts


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

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



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.


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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Similar Content

    • By sarj2001
      Would love a way to silently install and run Dell command update utility to Dell endpoints to keep drivers up to date, as Dell are frequently rolling out driver updates.
      Has anyone been able to make this work for them? 
      I've looked into it and found some sample scripts on reddit to try and edit and test. the problem I have is getting dell command update to install first, then getting the configuration file out to the required computers that need it, then running the update silently. 
      If someone has managed to get this working, I would love to see how you did it, or kindly ask for some sample scripts to work with?
      Any assistance would be greatly appreciated.
    • By Martti Nuudi
      I have configured and applied default storage notification policy to all my Windows workstations that is set to send a notification when the system partition has less than 5% with priority elevated.
      But all the notifications I get about storage say: The free space on disk drive C: on computer computername in group groupname - Office - Workstations' is below 15% (ex. 16.24 GB free of 118.18 GB).
      How can I make the applied policy to respect the right percentage specified in the group policy?

    • By BobC
      I have one customer workstation (actually a laptop) that I cannot assign a patch policy.  All of the other systems in this customer group are fine.  When I try to assign it via my mobile, I get "change OS patch policy command failed".  Nor can I assign it via the Pulseway Web app - it shows "no actions available" for that one system.
      I tried remotely restarting the laptop, and I tried repairing the local agent installation, but no joy.
      Any suggestions?
  • Create New...