Change 'sa' password.

• krammana

  Mr or Mrs. 500

  Points: 546

  More actions

  April 14, 2008 at 8:49 am

  #205704

  How to change the 'sa' password if only reporting and analysis services are installed in your machine?

  I dont have management studio and database service is also not installed in my machine...Please reply me as soon as possible

  Thanks in advance...

• K. Brian Kelley

  SSC Guru

  Points: 114703

  More actions

  April 14, 2008 at 9:09 am

  #802119

  If it's 2005, the easiest way is to use SQL Server Management Studio. You can install just the workstation components if you have the CD/DVD. Otherwise, you could use a script (say VBScript) which makes a connection and executes sp_password.

  K. Brian Kelley
  @kbriankelley

• krammana

  Mr or Mrs. 500

  Points: 546

  More actions

  April 14, 2008 at 11:56 am

  #802215

  Thanks