Jump to content

Move Database - Required Connection String


JohnnyJoker
 Share

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
Link to comment
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
Link to comment
Share on other sites

  • Administrators

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

Link to comment
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!

Link to comment
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.

 Share

  • Similar Content

    • By Jamie Taylor
      Pulseway Client Portal now includes a built-in chat function that allows the end user to communicate directly with a technician. This can be started automatically as a step in a troubleshooter, or you can give users the option to start it directly themselves.   A summary of the chat is recorded and can be sent to the technician. Automation Workflows: Run assigned patch policy
      Start patching systems as they get added to Pulseway using the new Run Assigned Patch Policy action, now available for the System Registered workflow trigger.
      Remote Desktop Improvements
      Introducing Adaptive FPS to deliver the optimum resolution for the current network connection, resulting in an enhanced user experience.
       
    • By Jamie Taylor
      BitDefender: In-product trial set-up, purchasing and provisioning now available
      We have made it easier to quickly get the EDR protection you need by making it possible to trial, purchase and provision Bitdefender AV, including EDR, from within the Pulseway RMM. Users can set up a free trial from the AntiVirus section of the WebApp, then purchase directly from the billing section. The new license can than be provisioned directly from the WebApp as well.
      Remote Control for macOS Performance Enhancements
      We have launched an improved Remote Control engine for macOS that delivers speed and performance enhancements. The latest release also introduces support for monitor selection.
    • By Tim Hall
      After receiving a verification on my phone I get this nasty gram.
       
      So far:
      .Net 4.0 install was blocked because a later version was already installed. So I don't think it is a .net version issue.
      Any help would be appreciated.
       
      --Tim

      I blocked out the server name to keep it annonymous
      I blocked out the server name to keep it anonymous. Also, please ignore the localhost:8443 page. It is irrelevant as far as I know.
    • By Jamie Taylor
      You can now trigger workflow executions from Performance Counter notifications and evaluate Name, Category and Instance in conditions to build even more customizable workflows for your IT processes.
    • By Jamie Taylor
      You can now create interactive, conditional troubleshooters that can be used to ask questions, provide answers, and run self remediation scripts and tasks based on user input. Pulseway's Client Portal can be used to standardize IT processes, empower end-users and reduce the workload on your support team.

       

       
×
×
  • Create New...