Link to home
Start Free TrialLog in
Avatar of MarcoCastro
MarcoCastroFlag for Brazil

asked on

Problem while installing MS SQL 2006

Hi,

  I wish to install MS SQL 2005 without prompts to the user so I use this command line:

cd c:\mcsoft

start /wait setup.exe /qb SAPWD=xyz INSTALLSQLDIR="%ProgramFiles%\Microsft SQL Server\" ADDLOCAL=ALL INSTANCENAME=SQLEXPRESS SECURITYMODE=SQL SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI SQLAUTOSTART=1 DISABLENETWORKPROTOCOLS=0

  The problem happens when installing SQL Server Database Services. Is showed this error line: Error reading from file: c:\McSoft\Program Files\Microsoft SQL Server\90\Shared\Microsoft.Sql.Sac.Public.dll. The problem is not the file itself, the problem is the path. I don't know why the installer inclues McSoft in the path. I have already tried a lot of combination with no success.

  Any clue is wellcome.

  Thanks,
  Marco Castro
Avatar of pbeirne
pbeirne
If you have a default install of Windows, simply try changing

INSTALLSQLDIR="%ProgramFiles%\...

to

INSTALLSQLDIR="C:\Program Files\...
Avatar of master135
master135
Flag of Ukraine image
Try to use  INSTALLSQLDIR="%SYSTEMDRIVE%\ProgramFiles\Microsft SQL Server\"
Avatar of pbeirne
pbeirne
to see if your %programfiles% variable is the culprit you can open a command prompt and type SET

Look for the line in the output that says: ProgramFiles=

And see if it says C:\mcsoft\Program Files
Avatar of MarcoCastro
MarcoCastro
Flag of Brazil image

ASKER

%ProgramFiles% is equal to c:\Program Files. McSoft is the folder where setup is saved at.

If I set INSTALLSQLDIR=C:\Program Files\... the setup changes the path to C:\McSoft\Program Files\... anyway.

If I set INSTALLSQLDIR to default, i.e. don't use this parameter, setup still with the path c:\McSoft\Program Files\...

Nothing works!
Avatar of master135
master135
Flag of Ukraine image
To specify Setup parameters by loading them from an .ini file, use the /settings filename.ini argument to specify the .ini file. The template.ini file on the SQL Server 2005 installation media provides detailed instructions for creating an .ini file. Note in particular that the first noncommented line in the .ini file must contain the string [Options]
For example
[Options]
USERNAME=MyName
COMPANYNAME=MyCompany
PIDKEY=ABCDE12345FGHIJ67890KLMNO
INSTALLSQLDIR="C:\Program Files\Microsoft SQL Server\"
INSTALLOLAPDATADIR="C:\Program Files\Microsoft SQL Server\MSSQL\OLAP\Data"
ADDLOCAL=SQL_Engine,Analysis_Server,RS_Server...
INSTANCENAME=MyInstance


more info about installation here in the end:
http://technet.microsoft.com/en-us/library/ms144259%28SQL.90%29.aspx
Avatar of pbeirne
pbeirne
Change your command line to:

start /wait c:/mcsoft/setup.exe /qb SAPWD=xyz INSTALLSQLDIR="%ProgramFiles%\Microsft SQL Server\" ADDLOCAL=ALL INSTANCENAME=SQLEXPRESS SECURITYMODE=SQL SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI SQLAUTOSTART=1 DISABLENETWORKPROTOCOLS=0

and run it from the c:> prompt.  Not from c:\mcsoft\>
ASKER CERTIFIED SOLUTION
Avatar of MarcoCastro
MarcoCastro
Flag of Brazil image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial