October 14, 2009 04:14 PM

Securing Your SQL Server Environment

Protect your databases by following these security best practices
Rating: (0)
SQL Server Magazine
InstantDoc ID #102775
Database security is a topic that affects all DBAs regardless of the size of your business or application. If you're reading this magazine, you need to know how to set up a secure database environment. So let's get started.

I’m not going to spend time on how a developer writes secure code or how to add and secure SQL Server Reporting Services (SSRS) or other ancillary features of your overall data storage solution. Instead, let's look at security items you should consider on the core ...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

The sentence
"The Local System account... doesn't have
access to resources not on the local system,..."
is incorrect.
The Local System account acts as the computer on the network
and this is also true for the Network Service acount.
The Local Service account and the Network Service account
are subsets of the Local System account
as far as permissions are concerned.

############################################################
http://msdn.microsoft.com/en-us/library/ms684190(VS.85).aspx
LocalSystem Account
"It has extensive privileges on the local computer,
and acts as the computer on the network."
"The service presents the computer's credentials
to remote servers."
############################################################
http://msdn.microsoft.com/en-us/library/ms684272(VS.85).aspx
NetworkService Account
"A service that runs in the context of the NetworkService
account presents the computer's credentials
to remote servers."
############################################################
http://msdn.microsoft.com/en-us/library/ms684188(VS.85).aspx
LocalService Account
"It has minimum privileges on the local computer
and presents anonymous credentials on the network."
############################################################

Dimitrios11/19/2009 6:38:10 PM


Nice article about some basics in security. I was expecting some more advanced since security is the cover of the issue.

Take Care!

Marcos11/6/2009 7:19:22 AM


Great article. Appreciate your work in creating it. My lack of knowledge of "The Cloud" will show with my question...but here goes anyway. Will corporate or small business DBAs need to worry about this when the cloud technology is in full swing? Thanks again.

SEAN11/5/2009 3:42:08 PM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS