When using Remote Desktop Client for Mac to connect to a Windows Server 2003 machine, you can hold down the Command key while pressing Connect to connect to the server's console session.
If you want to save your connection settings to a file, however, there is no option in the GUI to automatically use the console session. To do this, you will need to open up the saved connection file in your favorite text editor, and add the following line:
The next time you load the connection file, it will automatically connect to the console session!
connect to console:i:1
Mac OS X Hints