Skip to content

Instantly share code, notes, and snippets.

@azechi
Last active December 12, 2016 05:46
Show Gist options
  • Save azechi/a3f8c8a159d25221853217adcd35294a to your computer and use it in GitHub Desktop.
Save azechi/a3f8c8a159d25221853217adcd35294a to your computer and use it in GitHub Desktop.
net user administrator "password"
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'password', CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
ALTER LOGIN [sa] ENABLE
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2
GO
net stop mssqlserver /y
net start sqlserveragent
Get-NetFirewallPortFilter -Protocol tcp | ?{ $_.LocalPort -eq 5985 } | get-netfirewallrule | Get-NetFirewallAddressFilter | Set-NetFirewallAddressFilter -RemoteAddress Any
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment