Post reply

sql server installation question!!

  • November 3, 2008 at 9:21 pm

    #128494

    While installing sql server 2005, is it okay for selecting mixed mode of authentication? Thanks!

  • November 3, 2008 at 9:27 pm

    #893400

    Yes you can, unless you want it. You can complete installation with only WIndows Authentication as well, if you decide to use windows and SQL Server Authentication then choose Both.

    SQL Server Authentication is only for backward compatibility.

    When you choose Mixed authentication, give a strong password for SA A/c, by default SQL Server Installation keeps a blank password for SA ( System administrator, the highest priviledge A/c in SQL Server).

  • November 5, 2008 at 9:38 am

    #894351

    By default, SQL 2005 makes you create an SA password. You have to specify if you want it blank.

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

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