I'm installing SQL express from command line, and using something like that:
/qb INSTANCENAME="SQLEXPRESS" ADDLOCAL="All" SECURITYMODE="SQL" AGTACCOUNT="konrad" AGTPASSWORD="*******" SQLBROWSERACCOUNT="konrad" SQLBROWSERPASSWORD="*******" SQLACCOUNT="konrad" SQLPASSWORD="*******" SAPWD="********"
but after installation process security mode is still set to windows authorization
I realy don't know what is wrong
Could it be that the SQL Server password is not complex enough and you enabled a security complexity policy ? I thought that the install procedure should cancel then, but it seems that the SECURITYMODE is ignored for some reason. Did you try to put the settings in a template file and see if it will be taken from that ?
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||hmmm it's weird... when I type simple password installation goes to end without errors, but when passwords are more complicated I get an error:
SQL Server Setup could not validate the service accounts. Either the service accounts have not been provided for all of the services being installed, or the specified username or password is incorrect. For each service, specify a valid username, password, and domain, or specify a built-in system account.
atm it works only with one pair of passwords which I specify in first installation on this system after reboot but sql auth. still doesn't work :/
could someone give me working command to execute this installer with SQL Authentication that may be very helpfull
regards,
Konrad B.
|||
Any special characters in there ?
Jens K. Suessmeyer
http://www.sqlserver2005.de
No comments:
Post a Comment