Ravikanth's Blog

Happenings around Me

Disclaimer

India MVP Blogs

Mugh blogs

My

My Favorites

My Network Places

February 2006 - Posts

Privilege level of SQL Server Services

SQL Server Engine/MSSQLServer
Run as a Windows domain user account with regular user privileges. Do not run as local system, local administrator, or domain administrator accounts.

SQL Server Agent Service/SQLServerAgent
Disable if not required in your environment; otherwise run as a Windows domain user account with regular user privileges. Do not run as local system, local administrator, or domain administrator accounts.

Important: SQL Server Agent will need local Windows administrator privileges if one of the following is true:

>SQL Server Agent connects to SQL Server using standard SQL Server Authentication (not recommended).

>SQL Server Agent uses a multiserver administration master server (MSX) account that connects using standard SQL Server Authentication.
SQL Server Agent runs Microsoft ActiveX® script or CmdExec jobs owned by users who are not members of the sysadmin fixed server role.

Lastly

How to change the SQL Server or SQL Server Agent service account

The New Face of Phishing Attack

An interesting phishing scam is described in the linked-to article below. The phishers used a real certificate.

http://blog.washingtonpost.com/securityfix/2006/02/the_new_face_of_phishing_1.html

More Posts