SQL Server 2019基础配置

梦里梦外; 2023-07-09 12:26 182阅读 0赞

# SQL Server 2019基础配置 #

1、在开始菜单中选中安装的SQL Server 2019 配置管理器，打开。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70]  
2、点击SQL Server网络配置->MSSQLSERVER 的协议->启用TCP/IP协议。示例：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 1]  
3、启动管理应用。示例：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 2]  
4、默认直接点击连接即可。示例：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 3]  
5、发现有如图所示的结果表示连接成功。示例：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 4]  
6、单击->右键->属性。示例：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 5]  
7、点击安全性->勾选SQL Server 和 Windows身份验证模式。示例：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 6]  
8、点击连接->允许远程连接到此服务器->点击确定。示例：

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 7]  
9、点击确定。  
![在这里插入图片描述][20200228220450269.png]  
10、选中SQL Servel服务->点击SQL Server->右键重启。示例：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 8]  
11、等待重启完成。示例：  
![在这里插入图片描述][20200228220620346.png]  
12、点击sa，sa是系统默认的，可以根据自己的需要进行修改，修改默认密码。示例：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 9]  
13、点击状态->在登录名中点击启用->点击确定。示例：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 10]  
14、关闭所有窗口，重新进行连接即可，其中登录名为刚才的登录名(没有修改默认是sa)，密码用刚才修改的密码。示例：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 11]  
**SQL Server 2019 安装请看这里**[安装教程][Link 1] 。

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200228220155567.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200228220233999.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200228220300111.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200228220325144.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20200228220347154.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20200228220410741.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20200228220429856.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/20200228220521224.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg=,size_16,color_FFFFFF,t_70
[20200228220450269.png]: https://img-blog.csdnimg.cn/20200228220450269.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 8]: https://img-blog.csdnimg.cn/20200228220604530.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg=,size_16,color_FFFFFF,t_70
[20200228220620346.png]: https://img-blog.csdnimg.cn/20200228220620346.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 9]: https://img-blog.csdnimg.cn/20200228220638252.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 10]: https://img-blog.csdnimg.cn/20200228220656167.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg_size_16_color_FFFFFF_t_70 11]: https://img-blog.csdnimg.cn/20200228220715329.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NIUUMzODg=,size_16,color_FFFFFF,t_70
[Link 1]: https://blog.csdn.net/CHQC388/article/details/104550963