• State Suggested Answer
  • Replies 3 replies
  • Answers 2 answers
  • Subscribers 65 subscribers
  • Views 1415 views
  • Users 0 members are here
Options
Related

Change Active Roles 6.9 SQL Server

stephen rayment
1 month ago

We're looking to change the SQL server attached to our Active Roles Server 6.9 to a new SQL server.

Are there any instructions on how to do this or has anyone done this before? I know this is an old AR version, and am struggling to find any information related to this version.

We can export/import the SQL database OK, but changing the AR connection is a mystery at the moment.

Parents Reply Children
  • 0 29 days ago in reply to stephen rayment

    I found the answer in the documentation "Replication: Best Practices and Troubleshooting" where it says "You can modify connection settings by running the Administration Service executable file from a command prompt. The file name is arssvc.exe. The file is located in the Quest One ActiveRoles installation folder, %ProgramFiles%\Quest Software\Quest One ActiveRoles by default".

    This modifies the registry settings so can double check there, though passwords are encrypted.