Post reply

sa password not set during unattended install

  • July 26, 2007 at 7:48 am

    #179938

    i'm using the following command to install sql 2005 express edition:

    Start /wait sqlexpr.exe /qb INSTANCENAME=my_instance ADDLOCAL=All SAPWD=XXXXX SQLACCOUNT=domain\userName SQLPASSWORD=XXX AGTACCOUNT=domain\userName AGTPASSWORD=XXX SQLBROWSERACCOUNT=domain\userName SQLBROWSERPASSWORD=XXX

    the installation completes normally, but the SA password is never set and the server authentication is set to windows, not mixed.

    any ideas what i'm doing wrong?

    tks

  • July 26, 2007 at 9:15 am

    #722606

    I've never done an unattended install, but Windows Authentication is the default, so I imagine somewhere in that string you need to tell it to install it with Mixed Authentication. 

  • July 26, 2007 at 9:52 am

    #722623

    yes, you're right. i was missing this:

    SECURITYMODE=SQL

    first time reading through the documentation on how to do this i misunderstood the sapwd flag to pass in the SA password PLUS set mixed mode.

    tks

     

     

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

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