Ask the Expert

Initial password after a fresh install of SQL Server 2000

What is the password for login :SA after installing SQL Server 2000 for the first time?

    Requires Free Membership to View

SQL Server 2000 gets you to assign a password for SA when you install the server, if you have selected mixed mode authentication. There is also a check box you can tick if you really need to insist on a blank SA password – highly not recommended! If you only selected Windows authentication, then converted to mixed mode, you'll need to log on using a Windows login, then assign a password to SA.

This was first published in December 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.