MSSQL for Linux 安装指南
1、安装源 sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-preview.repo [[email?protected] etc]# cd /etc/yum.repos.d/ 2、安装MSSQL yum install mssql-server 3、安装完成后,配置SETUP [[email?protected] /]# /opt/mssql/bin/mssql-conf setup
选择 SQL Server 的一个版本: 可在以下位置找到有关版本的详细信息: 使用此软件的付费版本需要通过以下途径获取单独授权 输入版本(1-8): 2 可以从以下位置查看隐私声明: 接受此许可条款吗? [Yes/No]:yes
输入 SQL Server 系统管理员密码: ForceFlush is enabled for this instance. 4、验证服务是否正常开启 [[email?protected] /]# systemctl status mssql-server ● mssql-server.service - Microsoft SQL Server Database Engine Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled) Active: active (running) since 一 2019-05-20 11:16:37 CST; 47s ago Docs: https://docs.microsoft.com/en-us/sql/linux Main PID: 26015 (sqlservr) CGroup: /system.slice/mssql-server.service ├─26015 /opt/mssql/bin/sqlservr └─26037 /opt/mssql/bin/sqlservr 5月 20 11:16:41 localhost.localdomain sqlservr[26015]: 2019-05-20 11:16:41.51 Server Server is listening on [ 127.0.0.1 <ipv4> 1434]. 5月 20 11:16:41 localhost.localdomain sqlservr[26015]: 2019-05-20 11:16:41.51 Server Dedicated admin connection support was established for listening locally on port 1434. 5月 20 11:16:41 localhost.localdomain sqlservr[26015]: 2019-05-20 11:16:41.51 spid20s SQL Server is now ready for client connections. This is an informational message; no user action is required. 5月 20 11:16:42 localhost.localdomain sqlservr[26015]: 2019-05-20 11:16:41.99 spid9s Starting up database ‘tempdb‘. 5月 20 11:16:42 localhost.localdomain sqlservr[26015]: 2019-05-20 11:16:42.24 spid9s The tempdb database has 1 data file(s). 5月 20 11:16:42 localhost.localdomain sqlservr[26015]: 2019-05-20 11:16:42.28 spid16s The Service Broker endpoint is in disabled or stopped state. 5月 20 11:16:42 localhost.localdomain sqlservr[26015]: 2019-05-20 11:16:42.28 spid16s The Database Mirroring endpoint is in disabled or stopped state. 5月 20 11:16:42 localhost.localdomain sqlservr[26015]: 2019-05-20 11:16:42.36 spid16s Service Broker manager has started. 5月 20 11:16:42 localhost.localdomain sqlservr[26015]: 2019-05-20 11:16:42.43 spid5s Recovery is complete. This is an informational message only. No user action is required. 5月 20 11:16:45 localhost.localdomain sqlservr[26015]: 2019-05-20 11:16:45.31 spid33s The activated proc ‘[dbo].[sp_syspolicy_events_reader]‘ running on queue ‘msdb.dbo.syspolicy_event_queue‘ output the following: ‘Transaction (Proc... Hint: Some lines were ellipsized,use -l to show in full. 5、开启远程访问,将开放端口1433 [[email?protected] /]# firewall-cmd --zone=public --add-port=1433/tcp --permanent success 6、测试连接正常使用。 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |