Running SQL Anywhere on Windows Vista

SQL Anywhere supports the Windows Vista operating system. Following are some considerations relating to running SQL Anywhere software on Vista:

  • Vista security   Vista incorporates a new security model called User Account Control (UAC). UAC is enabled by default and may affect the behavior of programs that expect to be able to write files, especially when the computer supports more than one user. Depending on where and how files and directories are created, a file created by one user may have permissions that do not allow another user to read or write to that file. If you install SQL Anywhere into the default directories, then files and directories that require read/write access for multiple users are set up appropriately.

  • SQL Anywhere elevated operations agent   In Vista, certain actions require privilege elevation to execute when run under UAC. The following programs may require elevation in SQL Anywhere:

    • dbdsn.exe
    • dbelevate11.exe
    • dblic.exe
    • dbsvc.exe
    • installULNet.exe
    • mlasinst.exe
    • SetupVSPackage.exe
    • ulcond11.exe

    The following DLLs require elevation when they are registered or unregistered:

    • dbctrs11.dll
    • dbodbc11.dll
    • dboledb11.dll
    • dboledba11.dll

    On a Vista system with UAC activated, you may receive an elevation prompt for the SQL Anywhere elevated operations agent. The prompt is issued by the Vista User Account Control system to confirm that you want to continue running the identified program (if logged on as an administrator) or to provide administrator credentials (if logged on as a non-administrator).

  • Deployment considerations   The program dbelevate11.exe is used internally by SQL Anywhere components to perform operations that require elevated privileges. This executable must be included in deployments of SQL Anywhere.

  • ActiveSync support   The Microsoft ActiveSync utility is not supported in Vista. It is replaced by the Windows Mobile Device Center. You can use the SQL Anywhere ActiveSync Provider Installation utility with Windows Mobile Device Center.

  • SQL Anywhere executables signed   SQL Anywhere executables on Vista are signed by iAnywhere Solutions, Inc.

  • Windows services   Vista-compliant services are not allowed to interact with the desktop. On Windows Vista, no SQL Anywhere services interact with the desktop (even if Allow Service To Interact With Desktop is enabled in the service definition). SQL Anywhere database servers can be monitored from Sybase Central or the dbconsole utility. See SQL Anywhere Console utility (dbconsole).

    Sybase Central disables the option to allow services to interact with desktop when running on Windows Vista.

  • Using an AWE cache   To use an AWE cache on Vista, you must run the database server as administrator. Starting a non-elevated database server with an AWE cache results in a warning that the database server must be run as an administrator to use AWE. See -cw server option.