SQL Server Performance

How to find the default password for sa in SQL Server 2005 Express?

Discussion in 'SQL Server 2005 General DBA Questions' started by pcsql, Aug 20, 2007.

  1. pcsql New Member

    If SQL Server 2005 Express is installed with Windows Authentication, what is the default password for sa? Is it a random password and how to find out what it is?
    Is there a way to install SQL Server 2005 Express with Mixed Mode when I run VS2005 or VS2008 Beta2 installation?
    pcsql, Aug 20, 2007
    #2

  2. smy New Member

    smy, Aug 20, 2007
    #3

  3. ghemant Moderator

    Hi,
    You may change your authentication mode to Mixed, log into your SQL server with windows authentication-> right click on server - properties -> security -> select mixed authentication mode -> set the password for SA
    ghemant, Aug 20, 2007
    #4

  4. mahbub880 New Member

    Thank you Ghemant Vai.
    mahbub880, Jun 6, 2009
    #6

  5. satya Moderator

    SA is disabled by default. You need to connect with an account that is a local administrator in the first instance (windows authentication), then configure other accounts.

    May I suggest that you never enable SA and continue to use windows authentication?
    satya, Aug 21, 2007
    #7

Share This Page