443 Chapter4.Designing Database Server Security Policies

Designing Database Server Security Policies
Lesson 1:  Enforcing SQL Server Security through Group Policy
1. What is Group Policy
(1) Group policy is a framework that administrators use to control the configuration of users and computers in an Active Directory domain.
 Security options affecting passwords policies
 Software settings affecting application availability
 Desktop configuration settings affecting the start menu appearance
(2) Group policy settings are contained in Group Policy Objects (GPOs), which in turn are associated with selected Active Directory objects: sites, domains, or organizational units.
(3) Local computer policy
Every computer running Windows 2000 or later includes a Local Computer policy, sometimes call a local GPO.
Command name: gpedit.msc; if the GPO, MMC—group policy editor—scope: Default domain policy
get the local GPO
(4) Order of policy processing
No Order Description
1 Local GPO, Each computer has exactly one GOP that is stored locally.
2 Site, Any GPOs that have been linked to the site are processed next. Processing of multiple site-linked GPOs is applied sequentially and in the order specified by the administrator
3 Domain, Processing of multiple domain-linked GPOs is applied sequentially and in the order specified by the administrator
4 OUs, GPOs that are linked to the OU that is highest in the Active Directory hierarchy are processed first, then GPOs that are linked to its child OU, and so on. Finally, the GPOs that are linked to the OU that contains the user or computer are processed.
(5) Administrative templates, enables user to control the registry settings for users and computers through Group Policy.
(6) Configuring Windows Server Update Services (WSUS)
2. Password Policy
(1) In Windows, we can configure password policies either in a local GPO or in a GPO in Active Directory
(2) Enforcing password policy
(3) Enforcing password expiration
(4) Password Complexity, password complexity requirements are designed to deter brute force attacks by eliminating common passwords and by increasing the number of possible passwords
 The password cannot contain all or part of the user’s account name
 The password is at least eight characters long
 The password contains characters from three of the following four categories
  Latin uppercase letters (A-Z)
  Latin lowercase letters (a-z)
  Base 10 digits (0-9)
  Non-alphanumeric characters (!, @, #, $, %)
(5) Password policies and Domain-level GPOs, policies take effect only when they are applied to domain-level GPOs.
3. Practice: Enforcing password policy
4. Practice: add the logon script in the Active Directory
(1) Create logon script file
set oNet = CreateObject("wscript.Network")
userid = oNet.UserName
domian = oNet.UserDomain
msgbox "hello: " & domian & "/" & userid

(2) Call the logon script when user logon
 
 
Lesson 2:  Encrypting SQL Server Traffic
1. Server-Level encryption
2. IPSec policies
(1) You can use IPSec policies encrypt traffic to and from Windows-based computers. IPSec requires no configuration within SQL server itself, but both endpoints of the encrypted channel must be authenticated by a common authentication system: a trusted CA or an Active Directory domain.
(2) Windows 2003 include the following three default IPSec policies, all of which you can deploy through local security policy or group policy
 Client (Response Only)
 Server (Request Security)
 Secure Server (Require Security)
3. Compare the Force Encryption Option and IPSec
(1) Deploy environment: Encryption – Outer of the company; IPSec – Active Directory

4. Practice: IIS SSL & Encrypting traffic to and from SQL Server

(1) IIS SSL
 
get a cert.txt file, and the request a cert from a cert publisher.
 
Issue the certification
 
Download the issued certification
 
Install the cert to IIS
 
After installation, you should set the request need the SSL
 
Then, you can visit the web site through https
 
(2) SQL Server SSL
on one SQL Server, you request a and install one certificate from the publisher
 
The last page presents you with a certificate to install hyperlink, click to install this certificate
Check whether the certificate is stalled or not?
 

Set the SSL for SQL server
 
 
To make SSL active, you please restart the SQL Server service

If you want to disable SSL: first, change the Force Encryption to false; then clear the value for the register key
LOCAL-MACHINE\SOFTWARE\MICROSOFT SQL ERVER\MSSQL.1\MSSQLSERVER\SUPERSOCKETNETLIB

Lesson 3:  Reducing the Attack Surface of SQL Server 2005
1. Disabling unneeded services
You can use the SQL Server Surface Configuration tool to enable, disable, or stop features, services, and remote connectivity of you SQL Server 2005 installations
Component Description
SQL Server Database Engine Database engine, the core service for sorting, processing, and securing data; replication; full-text search; and tools for managing relational and xml data
Analysis Services Includes the tools for creating and managing OLAP and data mining application
Reporting Services Includes server and client components for creating, managing, and deploying tabular, matrix, graphical, and free-form reports. Reporting services is also an extensible platform that you can use to develop report applications
Notification Services Notification services is a platform for developing and deploying application that send personalized, timely info to subscribers on a variety of devices
Integration Services A set of tools and programmable objects for moving, copying, and transforming data

Services Description
SQL Server SQL Server Database Engine
SQL Server Agent Executes jobs, monitors SQL Server, fires alerts, and enables automation of some administrative tasks
Analysis Services Provides OLAP and data mining functionality for BI application
Report Services Manages, executes, renders, schedules, and delivers reports
Integration Services Provide management support for integration services package storage and execution.
SQL Server Browser Provide SQL server connection info for client computers. If you have named instances, you must turn on this to resolve them. Otherwise, you can turn it off
Full-Text Engine for SQL Create full-text indexes on content and properties of structured and semi-structured data to allow fast linguistic searches on this data
SQL Server Active Directory Helper Publisher and manages SQL Server services in AD
SQL Writer Enables backup and restore app to operate in the Volume Shadow Copy Service (VSS) framework.

2. Service Accounts
According to the principle of lease privilege, user should be granted the minimum rights and permissions necessary to do their jobs.
(1) Using a domain user account. Using a domain user account as service account is preferable when the service in question needs to interact with other services on the network. The following services all require server-to-server connections and are handled by domain user accounts
 Remote procedure calls
 Replication
 Backing up to network drives
 Heterogeneous join that involve remote data access
(2) Using the local service account. The local service account is a special built-in account whose default rights and access permissions are equivalent to those of a member of the users group.
 The minimal privileges
 Can access network resources only as a null session with no credentials
(3) Using the network service account. The network service account is a special built-in account whose default rights and access permissions to local objects are equivalent to those of a member of the users group.
 Can access network resources by using the credentials of the local computers’ computer account
(4) Using the local system account. The local system account is a built-in user account with the most powerful set of rights and permissions on the system and is a common target for exploitation by attackers. For increased security, run SQL Server services under a Windows account with the lowest required privileges.
(5) Groups for SQL Service Accounts. After you specify an account for each SQL Server service, SQL Server Setup creates Windows group accounts for the different SQL Server services and adds the service accounts to these group accounts.
Services Group Account Privilege
SQL Server SQLServer2005MSSQLUser$WIN0301 Log on as a service.
Log on as a batch job
Replace a process-level token
Bypass traverse checking
Adjust memory quotas for a process
Permission to start SQL Server AD Helper
Permission to start SQL Writer
SQL Server Agent SQLServer2005SQLAgentUser$WIN0301$MSSQLSERVER Log on as a service
Log on as a batch job
Replace a process-level token
Bypass traverse checking
Adjust memory quotas for a process
Analysis Server SQLServer2005SQLAgentUser$WIN0301$MSSQLSERVER Log on as a service

Report Server SQLServer2005ReportServerUser$WIN0301$MSSQLSERVER Log on as a service

Notification Services SQLServer2005NotificationServicesUser$WIN0301 N/A
Integration Services SQLServer2005DTSUser$WIN0301 Log on as a service
Permission to write to application event log
Bypass traverse checking
Create global objects
Impersonate a client after authentication
Full-Text Search SQLServer2005MSFTEUser$WIN0301$MSSQLSERVER Log on as a service

SQL Server Browser SQLServer2005SQLBrowserUser$WIN0301 Log on as a service

SQL Server AD Helper SQLServer2005MSSQLServerADHelperUser$WIN0301 None
SQL Writer N/A none

3. Security beast practices
(1) Enhance physical security. You should consider the following recommendations:
 Place the server in a room that is inaccessible to unauthorized persons
 Place computers that host a database in a physically protected location – ideally a locked computer room with monitored flood detection and fire detection or suppression systems.
 Install database in the secure zone of the corporate internet and never directly connected to the internet.
 Back up all data regularly and store copies in a secure offsite location
(2) Use firewalls
 Put a firewall between the server and the internet
 Divide the network into security zones separated by firewalls. Block all traffic and then selectively admit only what is required
 Always block packets addressed to TCP 1433 and UDP port 1434 on your perimeter firewall. If named instances are listening on additional ports, block them, too.
 In a multitier environment, use multiple firewalls to create screened subnets.
 When you are installing the server inside a Windows domain, configure interior firewalls to permit Windows Authentication.
 Open ports used by Kerberos or NTLM authentication.
 If your application uses distributed transactions, you might have to configure the firewall to allow MS DTC traffic to flow between separate MS DTC instances, and between the MS DTC and resource managers such as SQL Server.
(3) Use antivirus software
(4) Isolate services
 Avoid installing SQL Server on a domain controller
 Run separate SQL Server services under separate Windows accounts
 In a multitier environment, run web logic and business logic on separate computers.
(5) Configure a secure file system
 Use NTFS
 Use a redundant array of inexpensive disks (RAID) for critical data files
(6) Disable NetBIOS and server message block
 

 
(7) Authentication settings
 Authentication mode: Require Windows authentication for connections to SQL Server.
 String password: Increase security by following these practices.
  Enforce password policies and require passwords to meet complexity requirements.
  Always assign a strong password to the SA account, even when using Windows authentication.
  Always use strong passwords for all SQL Server accounts.
4. Practice: Reducing the attack surface of a Server
(1) Using the surface area configuration tool
 
(2) Configuring a service account for SQL Server
 
 

 

转载于:https://www.cnblogs.com/yang_sy/archive/2009/04/16/1437387.html

SpringBoot+Vue+MySQL 高校学科竞赛平台 完整可运行版(源码+文档) 本项目基于SpringBoot+Vue+MySQL构建高校学科竞赛管理平台,覆盖学生、教师、领队教师、管理员四大角色,实现竞赛发布、报名、刷题、评分、公示等全流程闭环管理。系统架构清晰,技术主流,配套完整源码、数据库脚本、万字论文、开题报告、答辩PPT及部署文档,支持一键运行,适用于毕业设计、课程设计及院系二次开发,真正实现“开箱即用”。 阅读详情

相关推荐

stm32教程之三重ADC交错采样

ps:本文基于stm32F407ZGT6单片机 stm32F4单片机单通道采集的最大采样率为2.4M,所以有时会难以满足较高频率的采样,于是查阅芯片手册,发现stm32F4支持多重ADC采集,利用每个通道的转换时间,错位采样,从而提高采样率,最大把采样率开到2.4*3=7.2M. (去年初学ADC时研究的,基于cube和HAL库的三重ADC交错采样参考资料不多,我也是研究了一段时间,写下这篇博客希望可以帮助到更多人。) 示意图如下: 以下是官方例子的说明, In this ex...

weixin_52178036的博客 8878

windows 组策略

通过 Windows 组策略,实现登录启动指定脚本。 1、快捷键 win+R,输入 gpedit.msc,点击 ok 2、在 Local Group Policy Editor 对话框中选择:Local Computer Policy --> User Configuration --> Windows Settings – > Scripts,然后点击右侧 Logon; 3...

xuyunquan 2522

unity 腾讯地图sdk移动和缩放代码

unity 腾讯地图sdk 实现移动端 缩放 和 移动

。。。。。 1283

Windows 更改密码策略

Windows 更改密码策略 Windwos跳过欢迎界面,直接进入桌面

m0_46517962的博客 2662

新手必看:Infineon Memtools烧录配置全流程(附常见错误解决方案)

本文为嵌入式开发新手提供了Infineon AURIX开发环境搭建与Memtools烧录的全流程实战指南。详细解析了ADS、DAS和Memtools三大核心工具的角色与协同关系,并重点讲解了Memtools的图形界面配置步骤、烧录操作流程,以及针对“无法连接设备”、“编程失败”等常见错误的系统性排查与解决方案,帮助开发者快速上手并规避典型陷阱。

weixin_29189377的博客 638

硬件工程师八大细分岗位详解:从芯片到整机的技术分工与职业选择

硬件工程作为电子系统设计的核心领域,涉及从芯片级到整机级的完整技术链条。其基本原理是通过电路设计、信号处理和功率管理等技术,将电子元件集成为功能完备的硬件系统。随着产品复杂度提升,硬件工程师岗位出现高度专业化分工,这种细分不仅提升了技术深度,更优化了团队协作效率。在工程实践中,信号完整性和电源完整性成为高速数字设计的两个关键技术挑战,直接影响系统稳定性。本文基于行业热词"硬件工程师"和"信号完整性",深入解析八大细分岗位的技术差异,帮助从业者明确职业发展方向,构建系统化的硬件设计思维。

weixin_33811539的博客 458

如何处理SQL Server死锁问题

Good articles to troubleshooting deadlock issue in SQL Server: deadlock is defined in the dictionary as "a standstill resulting from the action of equal and opposed forces," and this turns out to be ...

java开发指南博客 【转载】 1538

【四足机器人项目实战】cheetah 3/mini运动控制工程解读(附C++代码)

系列文章目录 提示:这里可以添加系列文章的所有文章的目录,目录需要自己手动添加 TODO:写完再整理 文章目录系列文章目录前言一、主程序入口1.代码流程2.终端设置信息提示二、用MiniCheetahHardwareBridge类构造一个hw的对象并初初始化1.2.3.4.三、运行硬件桥驱动【MiniCheetahHardwareBridge】1.2.3.4.四、1.2.3.4.总结参考资料 前言 认知有限,望大家多多包涵,有什么问题也希望能够与大家多交流,共同成长! 本文先对cheetah3/m

qq_35635374的博客 2617

Windows服务器添加关闭端口的IP安全策略

开始 → 管理工具 → 本地安全策略 → IP 安全策略 ,在 本地计算机Start → Adiministrator Tools → Local Security Policy → IP Security Policies on Local Computer1. 右键IP 安全策略,在弹出的快捷菜单中选择 “创建IP安全策略(Creat IP Security Policy...)”2. 在向导...

东滨之鱼的博客 2690

基于STM32XX的LCD液晶显示屏(HS19264G06A、驱动芯片:ST7525)驱动C程序设计

define USE_HW_SPI 1 // 1:使用硬件SPI, 0:使用软件模拟SPI。

myron6688的博客 237

面向精准医疗的多模态影像融合:实现前列腺MRI与大病理切片的三维配准与空间重建研究

亲爱的同学,当你能完整实现“前列腺MRI与大病理组织学图像的3D配准及体素重建”,你会发现医学影像交叉领域的毕设课题充满挑战与乐趣。我们将从临床需求出发,拆解3D配准与体素重建的核心技术,带你从原理到代码实现完整流程,让你的毕设不仅能顺利完成,更能体现临床应用价值。,让MRI和病理图像在同一空间对齐,能实现“术前影像-术后病理”的精准关联,为前列腺癌的精准诊疗、预后评估提供关键依据——这一课题既有技术挑战性,又有临床意义,是毕设的优质选择。(如NCC、Dice、配准时间),用数据证明方法的优越性。

m0_71589036的博客 4718

Linux、Windows Server Password Security Policy Strengthen

catalog 1. windows Security and Protection(Logon and Authentication) 2. windows密码强制安全策略 3. PAM(Pluggable Authentication Modules) 4. linux密码强制安全策略配置   1. windows Security and Protection(Logon...

weixin_34392906的博客 300

CAM350常用快捷键

CAM350快捷键 CAM350常用快捷键

bhxc809751502的博客 3066

SQL Server 安全篇——降低外围威胁(2)——禁用不安全功能

本文属于SQL Server安全专题系列    SQL Server默认禁用不安全的功能。如果需要启用,可以通过SSMS来实现,本文介绍手动配置外围应用配置器和使用策略管理来管理外围环境。手动配置外围应用配置器    右键实例,选择facts如下图,然后在【方面(F)】中选择“外围应用配置器”:可以看到下面的选项,通常我们会使用到“XPCmdShellEnabled”项,如果要用,则选择【True...

MVP黄钊吉(發糞塗牆) 1445

TMS_WebGMaps_1.9.8.0_Full_Source

TMS_WebGMaps_1.9.8.0_Full_Source 全源码 delphi cbuilder

Data-Structures-and-Algorithm-Analysis-in-Java.pdf

作者: Weiss, Mark A. 出版社: Addison Wesley Data Structures and Algorithm Analysis in Java is an “advanced algorithms” book that fits between traditional CS2 and Algorithms Analysis courses. In the old ACM Curriculum Guidelines, this course was known as CS7. This text is for readers who want to learn good programming and algorithm analysis skills simultaneously so that they can develop such programs with the maximum amo...

pc如何打开组策略_如何查看哪些组策略应用于您的PC和用户帐户

pc如何打开组策略We have shown you a lot of tips and tricks over the yearsthat involve modifying Local Group Policy. If you would ever like to see all the Group Policy settings in effect on your PC, here’s h...

cum44153的博客 2176

efm32 入门.pdf

本PDF共计22页,介绍的是操作驱动API,下载与否自己斟酌。

177.Agent-LangGraph-MCP的构成说明

MCP架构通过MCP主机、客户端与服务器的协同,实现工具、资源与提示词的统一管理。MCP服务器提供Tools、Resources、Prompts能力,MCP客户端则负责发现、调用与读取,使Agent可按需获取上下文。其核心在于将工具从Agent中抽离,封装为可复用的服务,提升灵活性与可维护性,推动AI应用高效协作。

计算机王的博客 315

jre9下载 jdk9

(Java SE Runtime Environment 9.0) 9.0u175 官方最新版 【x86|x64】

Docker Compose:搭建本地多服务开发环境

从一个 Java API、PostgreSQL 和 Redis 开始,配置服务名、端口、环境变量、健康检查、数据卷和依赖关系。理解 Compose 文件如何被解析、项目如何隔离,以及哪些数据不能依赖“重建容器”保留,能够把个人开发环境整理成团队可复用的启动入口。

m0_62221377的博客 478

AI全栈实战 | 3.9-01 爬虫入门:requests 加 BeautifulSoup 三分钟跑通,但 90% 的人栽在这 4 个“礼貌“问题上

⚠️:本文内容仅用于。请遵守目标站点的服务条款与相关法律法规,不得对目标服务造成负担,不得采集、传播个人隐私数据。技术是中性的,边界在你手里。爬虫的入门技术(requests 发请求 + BeautifulSoup 解析)三分钟就能学会。真正区分"会用爬虫"和"会做爬虫的人"的,是这篇我们跑通"请求→解析→存储"的最小闭环,然后重点把"合规与礼貌"这根弦给你绷上。

源码获取 | 运行部署 | 定制二开修改,如果回复不及时请耐心等待,请见谅。 445

spring boot 4集成SQLLite,及其SQLLite的建库

spring boot 4集成SQLLite,及其SQLLite的建库

weixin_41463944的博客 239

【基于 WebSocket 的多用户网页五子棋】—— 数据管理模块

但行好事,莫问前程

qq_42996461的博客 260

OpenClaw 深度调查:把 AI 助手做成你自己的控制平面

对 openclaw/openclaw 的完整技术尽调:Gateway 架构、Agent 运行时、工具与沙箱、30 个消息通道、181 个插件、安全信任边界、工程代价与采用建议。17 章 / 10 张图,全部数字标注口径,数据截至 2026-10-31。

厚积薄发 363

IDEA 简介:从零认识 IntelliJ IDEA

IDEA 全称,是由 JetBrains 公司开发的一款主流 Java 集成开发环境(IDE)。它集代码编辑、编译、调试、测试、版本控制、构建管理等功能于一体,被大量 Java 开发者视为日常开发的首选工具。所谓 IDE(Integrated Development Environment,集成开发环境),就是把写代码所需的各类工具整合到同一个界面中。相比只用文本编辑器加命令行编译,IDE 能显著减少重复操作,让开发者把精力集中在业务逻辑上。

ztI10的博客 187

TransactionInactiveError:await 之后事务已经不活跃了

TransactionInactiveError 出现于 IndexedDB 事务已结束(非 active 状态)时调用 put、get 等操作。常见于 await 后或 setTimeout 中执行请求,因任务已完成,事务已提交或进入 finished 状态。请求必须在创建事务的同一任务中挂起,否则无效。解决方法:在 onsuccess 回调内同步发起后续操作,或提前将所有请求挂入事务。避免在异步上下文中使用事务操作,确保请求在事务活跃期内完成。

qq_40822000的博客 160

Docker部署linkding:HTTPS与数据备份

部署私人书签库,除了让页面能够打开,还需要考虑几个实际问题:重建容器后数据是否保留、登录和保存是否正常、升级前怎样备份,以及出现 502 或 CSRF 错误时从哪里检查。本文使用 Docker Compose 部署 linkding,采用默认 SQLite 数据库,通过 Caddy 提供 HTTPS,并完成账户创建、数据持久化验证和备份。如果重建后账户或书签消失,应先检查是否换了项目目录、改了挂载路径,或者启动了另一套实例,不要急着重新初始化。遇到权限问题,应根据日志确认具体目录和运行用户,再调整权限。

tedcloud123的博客 194
上一篇: 443 CHapter5.Designing SQL Server Endpoints
下一篇: 443 Chapter8. Failover clustering -- not completed
aoding8407
博客等级 码龄11年 2粉丝 0原创
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符  | 博主筛选后可见
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付:10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值