Post reply

Create an admin password after installati

  • December 26, 2002 at 3:54 pm

    #159045

    Is it possible to create an administrative password for the super user "sa" account after installed SQL Server 7.0?

    Thank you!

  • December 26, 2002 at 3:56 pm

    #445164

    Just login to Query Analizer as sa and execute

    sp_password 'old_password', 'new_password'

  • December 26, 2002 at 3:58 pm

    #445165

    Yes, you can put a password on SA by using EM. Go to the Security Tab, click on Logins, find SA and right click, then enter a super secret password twice.

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

  • December 27, 2002 at 9:36 am

    #445188

    Both ways work well.

    Thank you very much!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply