Michael, Thanks for the help, I got squared away now, plus the silent install for SP2. Working like a charm.
There was a ADDLOCAL statements that are legit in the documentation online and in the M$ land but when you put them in the template.ini it bombs. Z Edward E. Ziots Network Engineer Lifespan Organization MCSE,MCSA,MCP,Security+,Network+,CCA Phone: 401-639-3505 -----Original Message----- From: Ziots, Edward [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 1:19 PM To: NT System Admin Issues Subject: RE: For anyone that has done a silent install of SQL 2005 Going to give this a whirl now and see whether we get any further. Not quiet sure why you would put "NT AUTHORITY\Network Service" for the username of the licensed installer, but the rest looks fine. I am re-reading books-online right now about the Parent-child relationships in the ADDLOCAL line to see if something is afoul. I will let you know if this worked. Z Edward E. Ziots Network Engineer Lifespan Organization MCSE,MCSA,MCP,Security+,Network+,CCA Phone: 401-639-3505 -----Original Message----- From: Michael B. Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 1:05 PM To: NT System Admin Issues Subject: RE: For anyone that has done a silent install of SQL 2005 Notice my changes. I hope they help. [Options] USERNAME="NT AUTHORITY\NETWORK SERVICE" COMPANYNAME=Company PIDKEY=PIDKEY INSTALLSQLDIR="D:\Program Files\Microsoft SQL Server\" ADDLOCAL=SQL_Engine,SQL_Replication,Client_Components,Connectivity,SQLXM L INSTANCENAME=MSSQLSERVER SQLBROWSERACCOUNT=domain\user SQLBROWSERPASSWORD=Password SQLACCOUNT=domain\user SQLPASSWORD=Password AGTACCOUNT=domain\user AGTPASSWORD=password SQLBROWSERAUTOSTART=0 SQLAUTOSTART=0 AGTAUTOSTART=0 SECURITYMODE=SQL SAPWD=SApassword SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS DISABLENETWORKPROTOCOLS=2 ERRORREPORTING=0 SQMREPORTING=0 Regards, Michael B. Smith MCSE/Exchange MVP http://TheEssentialExchange.com -----Original Message----- From: Ziots, Edward [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 12:51 PM To: NT System Admin Issues Subject: RE: For anyone that has done a silent install of SQL 2005 What should the ADDLOCAL line be then. The requirement is Options Section which I have. And from the template.ini file this is what I want the end-state to look like. SQL 2005 Standard edition installed in D:\Program Files\Microsoft SQL Server. I Want the database engine, data files, SQL XML, Client tools,Connectivity, SQL Replication, I want 3 accounts to register as the running services for the SQL Server service, SQL Agent Service, and SQL Browser Service. So looking in the default template.ini file you have the following. Below the commandline parameters section you see the [Options] section I have USERNAME and COMPANYNAME It says next that the ADDLOCAL= line needs to come. Per the Template.ini file I want to add the following. SQL Server Database Services = SQL_Engine in the ini file (Have this) Data Files= SQL_Data_Files (Don't have this) Replication=SQL_Replication(Have it) Full-Text Search Engine=SQL_FullText (don't have it) Client components=Client_Components (Got it) Connectivity Components=Connectivity (Got it) Management Tools=SQL_Tools90 (Don't got it) SQLXML Client Features=SQLXML (Got it) Legacy Components=Tools_Legacy (Got it) Documentation and Samples=SQL_Documentation (Don't got it) SQL Server Books Online=SQL_BooksOnline (Don't got it) (All these are valid for Standard, Developer and Enterprise Editions) Anything else I might be missing here, I will redo the ini file and see what happens. Z Edward E. Ziots Network Engineer Lifespan Organization MCSE,MCSA,MCP,Security+,Network+,CCA Phone: 401-639-3505 -----Original Message----- From: Michael B. Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 12:25 PM To: NT System Admin Issues Subject: RE: For anyone that has done a silent install of SQL 2005 <scratches head> Did you obfuscate that file? If not, then you need to fill in the parameters! Otherwise, your ADDLOCAL line is wrong. Regards, Michael B. Smith MCSE/Exchange MVP http://TheEssentialExchange.com -----Original Message----- From: Ziots, Edward [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 12:18 PM To: NT System Admin Issues Subject: For anyone that has done a silent install of SQL 2005 Importance: High Again another one that is driving me nuts. I am trying to use the following command with a .ini file which is a copy of the template.ini include with SQL 2005 Standard CD we have to build a silent install. The bat file Start /wait setup.exe /qb /settings D:\ServerInstall.ini The .ini file [Options] USERNAME=Network Services COMPANYNAME=Company PIDKEY=PIDKEY INSTALLSQLDIR="D:\Program Files\Microsoft SQL Server" ADDLOCAL=ADDLOCAL="SQL_Engine,SQL_Replication,Client_Components,Connecti vity,SQLXML" INSTANCENAME=MSSQLSERVER SQLBROWSERACCOUNT=Domain Account for Service SQLBROWSERPASSWORD=Password SQLACCOUNT=Domain Account for Service SQLPASSWORD=Password AGTACCOUNT=Domain Account for Service AGTPASSWORD=password SQLBROWSERAUTOSTART=0 SQLAUTOSTART=0 AGTAUTOSTART=0 SECURITYMODE=SQL SAPWD=SA password SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS DISABLENETWORKPROTOCOLS=2 ERRORREPORTING=0 SQMREPORTING=0 It basically bombs and says features specified are not valid for any SQL Server Products? If anyone has done a customized default installation before successfully though the .ini method can you spare some help? Been 2 days and still getting nowhere with this silly thing. Z Edward E. Ziots Network Engineer Lifespan Organization MCSE,MCSA,MCP,Security+,Network+,CCA Phone: 401-639-3505 ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~ ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~ ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~ ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~ ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~ ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
