1.打开 第一个cmd窗口输入 :net stop mssqlserver
2.等服务停止后,进入sqlservr.exe安装目录
D:
cd D:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn
再输入:sqlservr.exe -sMSSQLSERVER -mSQLCMD –c -f -m 注意,这窗口不要关
3.打开第二个cmd窗口进入:
d:
cd D:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn
然后执行:sqlcmd -E
然后输入:
EXEC sp_configure 'show advanced options', '1' RECONFIGURE WITH OVERRIDE;
EXEC sp_configure 'max server memory', 2147483647 RECONFIGURE WITH OVERRIDE;
EXEC sp_configure 'show advanced options', '0' RECONFIGURE WITH OVERRIDE;
GO
提示修改后,再重启服务。