July 2, 2013 at 6:40 am
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
Are you saying that you can't log in with the SA password you set?
July 2, 2013 at 7:35 am
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
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
July 2, 2013 at 7:41 am
Or it could be the double quotes in your SA password. Are those necessary? consider using a different secure password.
July 3, 2013 at 5:39 am
Hi simon, i tried both solution...still it is not working.
July 4, 2013 at 5:08 am
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