Connecting This Software to SQL Server

When using SQL Server authentication

Install the Manager of this software.
On the [SQL Server Settings] screen displayed during installation, enter the information of the database you created.
[Database]
Select [Use the current database].
[Server Name]
If SQL Server is installed in a different computer to that of the Manager of this software, enter the IP address and port number of that computer.
Example: 192.168.100.200,1433
If SQL Server is installed in the same computer as the Manager of this software, enter 'localhost'.
[Instance Name]
Enter the instance name of SQL Server.
[Authentication Mode]
Select [SQL Server Authentication].
[User Name]
Enter the login name configured in "Creating the Database for This Software".
[Password]
Enter the password configured in "Creating the Database for This Software".
For information on the procedure for installing the Manager of this software, see the following.
Installing the Manager

When Using Windows Authentication

Install the Manager of this software, then configure the settings for connecting to SQL Server.

Installing the Manager of This Software

Install the Manager of this software.
On the database selection screen during installation, select [SQLite].
Installing the Manager

Configuring the Account for Executing the Manager of This Software

1.
Log on to the computer as a user with administrator privileges.
2.
Specify the Active Directory user as the account for executing the Manager of this software.
From the Start menu, open [Windows Administrative Tools] > [Services].
Stop the services in the following order.
Canon Management Console Agent (only when the Manager and Agent are running on the same computer)
Canon Management Console Manager
Right-click Canon Management Console Manager, then select [Properties].
Select the [Log On] tab.
Select [This account], then configure the Active Directory user created in "Configuring Windows Authentication".
Click [OK].
3.
Start the services in the following order.
Canon Management Console Manager
Canon Management Console Agent (only when the Manager and Agent are running on the same computer)

Copying the Data of SQLite to SQL Server

Use a tool to switch from SQLite to SQL Server.
1.
Log on to the computer where the Manager of this software is running as the Active Directory user.
Log on as the user configured in "Configuring Windows Authentication".
2.
Start the tool for migrating the database.
Double-click the following file.
%ProgramFiles%\Canon\EMC\Manager\SQLite2SqlServerGui.exe
3.
Enter the information for the destination instance of SQL Server.
In [Database Name], select [Use the current database].
In [Server Name], enter the server name and port number.
If SQL Server is installed a different computer to that of the Manager of this software, enter the IP address and port number of that computer.
<IP address of the computer where SQL Server is running>,<port number>
Example: 192.168.100.200,1433
If SQL Server is installed in the same computer as the Manager of this software, enter 'localhost'.
Enter the instance name in [Instance Name].
In [Authentication Mode], select [Windows Authentication].
4.
Click [Connect].
5.
Click [OK].
6.
Delete the SQLite database files that are no longer required.
Delete the following files.
%ProgramFiles%\Canon\EMC\Manager\App_Data\managementconsole.db