Review these issues related to running SAP Sybase IQ on Windows 2008.
Windows 2008 incorporates a new security model. User Account Control (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 SAP Sybase IQ in the default directories, files and directories that require read/write access for multiple users are set up appropriately.
Certain actions require privilege elevation to execute when run under User Account Control. The programs dbelevate11.exe and iqdsn.exe may require elevation in SAP Sybase IQ.The following dll files require elevation when they are registered or unregistered: dbodbc16.dll and dboledb16.dll.
Certain actions require privilege elevation to execute when run under User Account Control. The following programs may require elevation in SAP Sybase IQ: SybaseIQservice16.exe, dbelevate11.exe, and iqdsn.exe.The following dlls require elevation when they are registered or unregistered: dbodbc16.dll and dboledb16.dll.
On a system with User Account Control activated, you may receive an elevation prompt for the SAP Sybase IQ 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).
The program dbelevate16.exe is used internally by SAP Sybase IQ components to perform operations that require elevated privileges. This executable must be included in deployments of .SAP Sybase IQ Administrator privileges are required to run dbelevate.
To use an AWE (Address Windowing Extensions) cache on Windows 2008, 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.
Samples now correctly handle SAP Sybase IQ installation path names that contain one or more spaces.
Windows 2008-compliant services are not allowed to interact with the desktop. SAP Sybase IQ services do not interact with the desktop (even if Allow Interaction with Desktop is enabled in the service definition). SAP Sybase IQ database servers can be monitored using the dbconsole utility or SAP Sybase IQ Control Center.