Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Starting and connecting to your database » Using SQL Anywhere database servers


SQL Anywhere on Windows Vista, Windows 7, Windows Server 2008, and Windows Server 2008 R2

The following considerations apply when running SQL Anywhere software on Vista, Windows 7, Windows Server 2008, and Windows Server 2008 R2:

  • Security   These operating systems incorporate a 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   Certain actions require privilege elevation to execute when run under UAC. The following programs may require elevation in SQL Anywhere:

    • dbdsn.exe
    • dbelevate12.exe
    • dblic.exe
    • dbsvc.exe
    • installULNet.exe
    • mlasinst.exe
    • SetupVSPackage.exe
    • ulcond12.exe

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

    • dbctrs12.dll
    • dbodbc12.dll
    • dboledb12.dll
    • dboledba12.dll

    If UAC is activated, you may receive an elevation prompt for the SQL Anywhere elevated operations agent. The prompt is issued by the 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 dbelevate12.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.

  • Microsoft ActiveSync support   The Microsoft ActiveSync utility is not supported in Vista, Windows 7 or Windows Server 2008. 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 are signed by iAnywhere Solutions, Inc.

  • Windows services   Services that are compliant with Windows Vista, Windows 7, and Windows Server 2008 are not allowed to interact with the desktop. On these operating systems, 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 SQL Anywhere Console utility (dbconsole).

    Sybase Central disables the option to allow services to interact with desktop when running on these operating systems.

  • Using an AWE cache   To use an AWE cache, 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 dbeng12/dbsrv12 server option (deprecated).


    The use of AWE is deprecated. It is recommended that you use the 64-bit version of the SQL Anywhere database server on a 64-bit Windows operating system if you require a large cache.