Executing SQL Server Express (SQLEXPR.EXE) within VB.NET
Posted on 2006-10-25
I am attempting to execute SQL Server Express installation within my VB.NET 2005 application using several scenarios of the following:
Process.Start("Start /wait " & glRootDirectory & "\SQLEXPR.EXE /qb INSTANCENAME=TSF ADDLOCAL=SQL_Engine,Client_Components,Connectivity SECURITYMODE=SQL SAPWD=<password> DISABLENETWORKPROTOCOLS=0")
I continue to get an error 'Specified file does not exist'. I was able to perform this install from the command prompt and I know that it has to be a syntax issue with using Process.Start as opposed to installing from the command prompt.
I should be able to install using Process.Start shouldn't I? If so, what is wrong with the syntax of my command line?