Wednesday, July 30, 2008

Remote Desktop Console Option

Remote desktop option is limited to the a default of 1 sessions on Windows server a second session which is active is the desktop session when we connect to a remote desktop application we have an option to provide the /console option which will make sure that the desktop session is used and a new session is not started at this stage is there is a user working on the server desktop then he would be logged off.

Configuring SQL Mail

I have been using SLQ mail for sending mails for quite some time and i find it the easiest way to configure notification from SQL server below are some points to be borne in mind while setting it up.
1. The Account being used to start SQL Server Service should be the same account which is used to set up the outlook profile.
2. If domain is configured then domain account should be used for the above step.
3. Log into the server with the account used to start the SQL server, thereafter install and configure Outlook mail account.
4. Assign the outlook mail profile in the SQL mail section and you are done.

The account configured in Outlook should be an exchange account if the account is an internet account then it will require the outlook application to be open on the server as in case of internet accounts there is no local mailbox which can store the mails and maintain a queue.