Microsoft SQL Server and SQL Azure Configuration Profiles
Microsoft SQL Server and SQL Azure Configuration Profiles

When the Microsoft SQL Server / SQL Azure configuration profile is being used, VNC Manager stores all the profile settings in a database. This is the recommended configuration profile for a multi-user scenario.

Local File configuration profile provides limited means to share the configuration data among multiple users. This is done by notifying the user about changes to the files used by the configuration profile. By default, this feature is turned off. Use the Tools \ Options \ Common Settings \ Registered Computers List \ Configuration Files Monitoring \ Monitor Changes To Configuration Files command to turn on the monitoring feature.
SQL Server / SQL Azure Configuration Profile Properties
Microsoft SQL Server Configuration Profile Settings window

To create new Microsoft SQL Server or SQL Azure configuration:

  1. Enter a user-friendly configuration name.
  2. Select the SQL server type: Microsoft SQL Server 2005 or SQL Azure.
    NOTE: In SQL Azure mode, the Create Database button is disabled. This is because SQL Azure platform only allows a user to create a database via the Control Panel.
  3. Enter the IP address or hostname of the computer hosting the SQL server.
  4. Select authentication mode and enter optional logon credentials.
    NOTE: SQL Azure platform supports SQL Server authentication mode only.
  5. Enter the database name.
  6. Click the Create Database button if you want VNC Manager to create a new database.
    Click the Update Database button if you want to update an existing database.
  7. When "auto-refresh" feature is enabled, SmartCode VNC Manager will automatically fetch data from the database at user-configured time intervals.
APPLIES TO: SmartCode VNC Manager v6.0.28.0 or newer