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.
The following DLLs require elevation when they are registered or unregistered:
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.
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.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|