Monday, March 26, 2012

Help! SQLEXPRESS Command Prompt Installation!

i have a problem installing SQLEXPRESS via command prompt... the installation is successful but the 'sa' account could not login to the server.. here's the command in my batch file.

Code Snippet

Start /wait <exe> /qb INSTANCENAME=MYINSTANCE ADDLOCAL=ALL *AUTOSTART=1 RSCONFIGURATION=DEFAULT SECURITYMODE=SQL SAPWD=sapwd SQLCOLLATION=Latin1_General_BIN requiresmsiengine=1

and one more thing, i need to run the report server automatically.. thanks! Smile

Which connection string are you using to connect to the database and which exact error message do you get ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||im using mixed mode... actually there is no error during the installation via command prompt it's just the 'sa' account could not login and the report server could not be initialized but all the components were installed... is there something wrong with my command in the batch file?

No comments:

Post a Comment