Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
SQL Server Authentication mode is not getting set when SQL Server is installed through an application installer. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    SQL Server 2005 is a prerequisite for my application. The application installer is created and maintained use Wise Installer Studio. I need to enable SQL Server Authentication at install time for my application. I pass the following command line arguements:-

    sqlexpr.exe /qb INSTANCENAME=MYAPPSQLSERVER ADDLOCAL=SQL_Data_Files,Connectivity SAPWD="sapassword" SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 INSTALLSQLDATADIR="C:\Program Files\MyApp\Data\SQL"

    My problem is that the above statement works perfectly when I execute it from command line.But when I run my application installer, though SQL server gets installed, SQL Server Authentication mode is not getting set. What could be the reason for this different behavior. 

    Tuesday, September 27, 2011 10:46 AM