SQL Anywhere server log in the windows tray.

[Former Member]

BH Hi, in the old windows 2003 server, whenever the SQL ANYWHERE Server is started, the window in the task-bar appeared. It showed like a log of the connections and status (ex. "Now accepting requests", etc.) However, in the Windows 2008 Server, i don't see that log window in the tray. Is there a way to pull it up manually? Thanks Aron

[MarkCulp]

You must be running your server as a service.

When the database server (or any other process) is running as a service the process is no longer allowed to interact with the desktop - This is a change that Microsoft has made as of Windows7/Server 2008.

So unfortunately there is no method to get the old behaviour when running on Windows 2008 Server.

[ian_mchardy]

FYI - this change was actually first made my Microsoft in Windows Vista.

[former_SQLA_member1694903]

At our site, I changed the startup params for the database to write a log file of the console messages, and use baretail to watch them go by. It seems to work pretty well.

-o C:\\Logs\\MyDBServer.TXT
-os 2m

Get baretail here: http://www.baremetalsoft.com/baretail/

[VolkerBarth]

FWIW: Running the database server with the -o console.log parameter is very common and recommended - independent of the OS and mode (normal application vs. service).

Cf. this related question:

How to access the network server console on Server 2008.