Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <#
- -------------------------------------------------------------------------------------------------------------------------
- SRC -> https://www.mssqltips.com/sqlservertip/3542/automated-way-to-get-all-port-information-for-sql-server-instances/
- O/P -> No enabled -> https://imgur.com/4zSgWzL
- if enabled -> check tcp (name key registry) -> https://imgur.com/LEATWo4
- -> Enabled -> https://imgur.com/YcmAsuA
- ls tcp (name key registry) -> https://imgur.com/Y7BwSGn
- -------------------------------------------------------------------------------------------------------------------------
- ◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼
- mp4 ->
- ◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼◼
- #>
- # <msSql12.xenDesktop> <-- Instance Name
- cd hklm: ; ls "hkey_local_machine\software\microsoft\microsoft sql server\<msSql12.xenDesktop>\msSqlServer\SuperSocketNetLib"
- #Restart SQL Server via Cmd (elevated) | O/P -> https://imgur.com/VFPSmHA
- net stop msSql$<instanceName> && net start msSql$<instanceName>
- # check via netstat (status port -> listening | established)
- # O/P -> https://imgur.com/toTKAe5
- netstat -ano | findstr /i 1433
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement