Post reply

SQL 2008 express installation using command prompt

  • July 2, 2013 at 6:40 am

    #275715

    Hi

    I am trying to install sql server 2008 express using command prompt from my .net application

    This is the command

    Arguments='/q /hideconsole /action=Install/TCPENABLED=1/NPENABLED=1/SECURITYMODE=SQL/features=SQL,Tool/SAPWD ="Mydwp2008#"s/instancename=SQLEXPRESS/enableranu=1/sqlsvcaccount="NT Authority\Network Service"/AddCurrentUserAsSqlAdmin/skiprules=RebootRequiredCheck/IAcceptSQLServerLicenseTerms'

    installion is working fine..but the authentication mode is changed to WINDOWS authentication mode even though i am choosing mixed mode.

    How to solve this issue

  • July 2, 2013 at 7:21 am

    #1629063

    Are you saying that you can't log in with the SA password you set?


    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne

  • July 2, 2013 at 7:35 am

    #1629072

    s_osborne2 (7/2/2013)

    Are you saying that you can't log in with the SA password you set?

    yes..sa user is disabled and when i check the authentication mode it is WINDOWS

  • July 2, 2013 at 7:40 am

    #1629074

    It's been a while since i've done installs like this but if that's the exact string you're executing, might it be that you've not left a space between the switches?

    Looking at MSDN there's a space between each switch. See here: http://technet.microsoft.com/en-us/library/ms144259(v=sql.100).aspx#Install

    So i've cleaned up the string you seem to be executing as follows:

    Arguments='/q /hideconsole /action=Install /TCPENABLED=1 /NPENABLED=1 /SECURITYMODE=SQL /features=SQL,Tool /SAPWD ="Mydwp2008#"s /instancename=SQLEXPRESS /enableranu=1 /sqlsvcaccount="NT Authority\Network Service" /AddCurrentUserAsSqlAdmin /skiprules=RebootRequiredCheck /IAcceptSQLServerLicenseTerms'

    Give that a bash and see if you still get the same issue.

    Thanks,

    Simon


    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne

  • July 2, 2013 at 7:41 am

    #1629076

    Or it could be the double quotes in your SA password. Are those necessary? consider using a different secure password.


    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne

  • July 3, 2013 at 5:39 am

    #1629491

    Hi simon, i tried both solution...still it is not working.

  • July 4, 2013 at 5:08 am

    #1629811

    finally got it ..its a silly mistake...i am always trying to run the application by right clicking Run as Administrator..i tried directly and it takes mixed mode authentication

Viewing 7 posts - 1 through 6 (of 6 total)

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