SQL Server -Window XP useful commands for DBA

run>msinfo32
  • It gets the system information like OS, version name, components and many more.
run>sqlservermanager11.msc
  • Opens the SQL server configuration manager if the latest SQL server installed on the machine is SQL 2012.
run>sqlservermanager10.msc
  • Opens the SQL server configuration manager if the latest SQL server installed on the machine is SQL 2008.
run>compmgmt.msc
  • It opens the computer management window which in turn used for user management, event viewer, disk management etc.
run>inetmgr
  • It opens the IIS window which int-run used for managing FTP, Web sites and SMTP.
run>cmd>osql -L
  • It fetches the list of all the SQL server installed on the current network.
run>cmd>netstat -na|find "1433"
  • It finds the status of the 1433 port.
run>c:\windows\system32\drivers\etc\hosts
  • This is the host file path. In case client SSMS is not able to connect to the SQL server using the server name but can connect using the IP address then try making an entry (associate IP address with the Server name) into this file.
run>secpol.msc
  • Opens the local security setting window which is used to set security options, IP security, password policy etc.

Leave a Reply

Your email address will not be published. Required fields are marked *