Data World

SQL Server -Window XP useful commands for DBA

Posted by Pramod Singla on October 10, 2012


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.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: