This support note applies to:
- AO Corporate Compliance (AU)
- AE Corporate Compliance (AU)
In MYOB Corporate Compliance (CC) you may need to determine what the correct server and instance name being used for CC.
There are a number of ways to check what the current server and instance name is of the CC database.
- On the server Open Corporate Compliance on the Server and follow the menu path: Help > About Corporate Compliance > Application details. The Corporate Compliance Application Details window appears with the details of the Corporate Compliance server and instance name.
- On a workstation Open Corporate Compliance on a Workstation and follow the menu path: Help > About Corporate Compliance > Application details. The Corporate Compliance Application Details window appears with the details of the Corporate Compliance server and instance name.
- MS Server Management Studio
If you are unable to open Corporate Compliance on the Server or Workstation, you can use MS Server Management Studio to view and connect to the installed SQL instances on the server and look within these instances for the Corporate Compliance database.
- Installation log files
You can use installation log files such as C:\Program Files (x86)\MYOB\Corporate Compliance\Install\S6CCINSTALL.log. This file details the options that were selected during the server\client installation.
In the situation where there is more than one CC database identified you can view the modification date of the database files to determine which one has been updated most recently.This may occur when a server migration is performed and the old server has not had the SQL databases removed.
If CC has been installed to an MYOBACCT instance, the path to these files is usually: C:\Program Files\Microsoft SQL Server\MSSQL10_50.MYOBACCT\MSSQL\DATA
The 2 files that comprise of the CC database are