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

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

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.

Guest
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 TechSolutionLLC
      Hello,
      I would like to see the ability to run dual screens viewable at the same time on the remote control. That way customers who need to run dual screens and have to work from home arent stuck playing swap between screens. I think either opening a second connection to the computer with one of the separate screen would be fine, but maybe there is a better way like how Remote Desktop works or Google Chrome Remote Desktop works. 
    • By Martin Stevnhoved
      Hi.
      If it is possible I would like to exclude full automation scripts from the diagnostics log "trace.log".
      In normal situations it is fine with just an indication of the execution with the script name.
      I guess you could add one more checkbox like "Include full Automation Scripts" in settings, and let it be disabled as default.

      Best Regards,
      Martin.
    • By CurryTheDemon
      Hello there, I just got Pulseway today as of 5/1/20 and am intending to use it to mainly be able to remote control access my PC from my phone when away from the house. I am installed all the appropriate applications needed and went through the Pulseway Remote Access application along with Pulseway Manager application and have enabled Remote Access. But for some reason I still can not access it from my phone. Perhaps I am missing a step? It would be amazing if someone would be able to help me troubleshoot this situation. Thank you for your time.
    • By Kyle
      I love the fact that we can now use the android app to remote into managed devices.  It works well when the user is already logged in...
      The problem I'm experiencing is when I remote control a Windows device and have to login.  I bring up the keyboard no problem and try typing the password to that computer.  What I am typing on my keyboard isn't typing in the password box on the PC.  In other words, it never seems to respond and type the password letters as I am typing, hence I cannot login (invalid password).  I suspect it has something to do with how Android on Samsung deals with autofill.  Ironically, I don't have this problem when using the Team Viewer app on the same phone.  That fact leads me to believe that it is a problem with the Pulseway Android App.
      Using a Samsung Galaxy Note 9 running Android 10.
    • By Martti Nuudi
      Hi,
      I use high CPU notification to notify me when the CPU usage has been over 90% for the last 30 minutes.
      Even though I have added more minutes to the time period, I still get a lot of these notifications. I would really like to know what is causing these long periods of high CPU usage but the content of the notification always displays processes with very low CPU usage. Can something be done to get this list sorted by the highest CPU using process?
      Here is an example of the latest notification:
      The CPU usage on computer 'XXX' in group XXX -XXX -XXX' is above 90% for the last 30 minutes
       
      Top Processes:
      Windows Explorer (Explorer.EXE): 0.04%
      Host Process for Windows Services (svchost.exe): 0.03%
      Microsoft Outlook (OUTLOOK.EXE): 0.03%
      Desktop Window Manager (dwm.exe): 0.02%
      SkypeApp (SkypeApp.exe): 0.02%
      WMI Provider Host (wmiprvse.exe): 0.02%
      Host Process for Windows Services (svchost.exe): 0.01%
      Host Process for Windows Services (svchost.exe): 0.01%
      Host Process for Windows Services (svchost.exe): 0.01%
      Microsoft Excel (EXCEL.EXE): 0.01%.
×
×
  • Create New...