Thursday, July 14, 2016

HOW TO DISABLE NETBIOS VIA COMMAND LINE ON WINDOWS

wmic nicconfig get caption,index,TcpipNetbiosOptions

wmic nicconfig where index=8 call SetTcpipNetbios 2

The SetTcpipNetbios parameter can have this value:
0 – Use NetBIOS setting from the DHCP server
1 – Enable NetBIOS over TCP/IP
2 – Disable NetBIOS over TCP/IP

Thursday, July 7, 2016

How to reset SQL Server sa password using Microsoft SQL Server Management Studio


1. Reset the SQL system administrator password
a)  Download and install Microsoft SQL Server Management Studio Express; Make sure to choose the suitable Windows platform (x86 or x64);
b)  Open the application, and choose the authentication mode:  “Windows Authentication”;
 

c)  Press “Connect” button and navigate to the Security->Logins folder in the left side of your window; Right-click on “sa” and choose properties;



d)      Change the password with a complex one.   For e.g.: P@ssw0rd;



e)  Make sure that SQL Server allows the “sa” account to connect and has enough permissions; Navigate to Status-> and choose “Grant” and “Enabled” in the right side of the window.