Microsoft SQL Server数据库装好后,发现在某些时候需要更改数据库身份验证模式.
这里共享自己编写并常用的Microsoft SQL Server数据库身份验证模式更改脚本.
将以下代码保存成MSSQLServer身份验证_混合模式.bat
@echo off
echo ARE You Sure want to choose MSSQLServer身份验证_混合模式?
echo press any key to continue
pause>nul
echo 修改注册表...
reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer" /v LoginMode /t reg_dword /d 00000002 /f
echo 修改注册表...
reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer" /v LoginMode /t reg_dword /d 00000002 /f
net stop MSSQLSERVER
REM echo 即将启动MSSQLSERVER服务
REM pause
net start MSSQLSERVER
echo Success
pause>nul
将以下代码保存成MSSQLServer身份验证_仅Windows.bat
@echo off
echo ARE You Sure want to choose MSSQLServer身份验证_仅Windows?
echo press any key to continue
pause>nul
echo 修改注册表...
reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer" /v LoginMode /t reg_dword /d 00000001 /f
echo 修改注册表...
reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer" /v LoginMode /t reg_dword /d 00000001 /f
net stop MSSQLSERVER
REM echo 即将启动MSSQLSERVER服务
REM pause
net start MSSQLSERVER
echo Success
pause>nul
以后只需运行一下脚本就可以实现更改数据库身份验证模式了.
