SQLAccount

Aug 23, 2011 at 7:40 PM

Is there a way I can change it so that I can use a group for SQLAccount or SQLSVCAccount? I don't have a domain account I can use for installations and multiple machines and I don't want to put in the computername\accountname and password in everytime.

Coordinator
Aug 26, 2011 at 7:44 AM

You cannot use a group name for SQLAccount (SQL2005) or SQLSVCACCOUNT (SQL2008 and above), or for any of the other service acounts.  This is a Microsoft restriction in that the ability to run a service needs to be linked to a specific account.  If you don't want to set up new domain accounts for SQL Server, then don't specify /SQLAccount, etc, when you run FineBuild, and it will default to using NT AUTHORITY\NETWORK SERVICE for the service accounts.

Aug 26, 2011 at 8:07 PM

That's exactly what I want it to do, use NT AUTHORITY\NETWORK SERVICE but it tells me I must define SQLAccount and it's password when I run SQLFineServer.bat

On a second note I went ahead and used an account so I could see how this was going to work. It finished but did not install the tools, why would that be?

Aug 26, 2011 at 10:02 PM

@ECHO OFF
REM Copyright � 2008, 2011 Edward Vassie.  Distributed under Ms-Pl License
REM
CALL "SqlFineBuild.bat" %*     /Type:Full                    /IAcceptLicenseTerms        ^
/DrvProg:C                   ^
 /DrvBackup:C /DrvData:C /DrvDataFT:C /DrvLog:C /DrvTemp:C	^
 /SAPWD:"DCTsql#1"	/Instance:SQL05	/TCPPort:1343  ^

 

 

<?xml version="1.0" encoding="utf-8"?>
<SQL2005Config>
  <Global AGTAutoStart="1" ASAutoStart="0" ASCollation="Latin1_General_CI_AS" AuditLevel="2" DBA_DB="DBA_Data" DBAEmail="" DBMailProfile="Public DB Mail" DBOwnerAccount="DBOwner" DirDBA="DBAFiles" DirSQL="SQLFiles" DisableNetworkProtocols="0" DTCMultiInstance="Yes" EnableRANU="1" ErrorReporting="0" FilePerm="&quot;Administrators&quot;:F &quot;Users&quot;:R" GroupDBANonSA="" GroupDBA="BUILTIN\Administrators" Mailserver="" NumErrorLogs="31" RSAutoStart="0" RSConfiguration="Default" RSSQLLocal="1" saName="sa" SecurityMode="SQL" SpeedTest="5.0" SPLevel="SP4" SPCULevel="CU4" SQLAutoStart="1" SQLBrowserAutoStart="1" SQLCollation="Latin1_General_CI_AS" SQLWriterAutoStart="0" SQMReporting="0" tempdbFile="200 MB" TCPPort="1433" TCPPortAS="2383" TF1="T1118" TF2="T1222" TF3="T3604" TF4="T845" Upgrade="SQL_Engine,Analysis_Server,RS_Server">
    <Strings ClusASIPIdx="3" ClusASSuffix="AS" ClusDBIPIdx="2" ClusDBSuffix="DB" ClusDTCIPIdx="1" ClusDTCSuffix="TC" LabBackup="Backup" LabBackupAS="AS Backup" LabData="SQL Data" LabDataAS="AS Data" LabDataFT="FT Data" LabDTC="MSDTC" LabLog="SQL Logs" LabLogAS="AS Logs" LabLogTemp="Temp Logs" LabSysDB="SQL SysDB" LabSystem="System" LabTemp="Temp" LabTempAS="AS Temp" LabTempWin="Temp" LabTools="Tools" MenuAccessories="Accessories" MenuAdminTools="Administrative Tools" MenuBOL="SQL Server Books Online" MenuConfigTools="Configuration Tools" MenuPerfTools="Performance Tools" MenuPrograms="Programs" MenuSQL2005="Microsoft SQL Server 2005" MenuSQLAS="Analysis Services" MenuSQLDocs="Documentation and Tutorials" MenuSQLIS="Integration Services" MenuSSMS="SQL Server Management Studio" MenuSSMSExp="SQL Server Management Studio Express" NTAuthAccount="" PathAddComp="..\Additional Components\" PathSQLMedia="..\" PathSQLSP="..\Service Packs\" ResponseNo="N" ResponseYes="Y" SQLProgDir="Microsoft SQL Server" SQLRecoveryComplete="Recovery is complete" SQLRSStartComplete="INFO: Total Physical memory:"></Strings>
  </Global>
  <BuildClient>
    <Flags ConfigGenMaint="Yes" ConfigMenus="Yes" ConfigNetwork="Yes" ConfigServices="Yes" InstABE="Yes" InstBOL="Yes" InstBIDSHelper="Yes" InstBPAnalyzer="Yes" InstDTSDesigner="Yes" InstIntViewer="Yes" InstMDXStudio="Yes" InstNet3="No" InstPDFReader="Yes" InstPerfDash="Yes" InstProcExp="Yes" InstProcMon="Yes" InstRawReader="Yes" InstRMLTools="Yes" InstRptTaskPad="Yes" InstSP="Yes" InstSPCU="Yes" InstSPCUSNAC="No" InstSQLNexus="Yes" InstSQLTools="Yes" InstSystemViews="Yes" InstTrouble="Yes" InstXEvents="Yes" InstXMLNotepad="Yes" SetupBOL="Yes" SetupCMD="Yes" SetupMyDocs="Yes" SetupNetTrust="Yes" SetupShares="Yes" SetupSSMS="Yes" SetupVS="Yes" SetupWindows="Yes" UserConfiguration="No" UserPreparation="No" />
  </BuildClient>
  <BuildServer spConfigureCLREnabled="1" spConfigureMaxServerMemory="" spConfigureOptimizeForAdHocWorkloads="1" spConfigureRemoteAdminConnections="1" spConfigurexpCmdshell="0">
    <Flags ConfigCmdExec="No" ConfigDBAManagement="Yes" ConfigDBMail="Yes" ConfigDBOpts="Yes" ConfigDisableSA="Yes" ConfigGenMaint="Yes" ConfigFT="Yes" ConfigMenus="Yes" ConfigNetwork="Yes" ConfigNonSAAccounts="Yes" ConfigOLAP="Yes" ConfigOLAPAPI="Yes" ConfigOldAccounts="Yes" ConfigParam="Yes" ConfigSAAccounts="Yes" ConfigServices="Yes" ConfigSQLAgent="Yes" ConfigSQLInst="Yes" ConfigSQLMail="Yes" ConfigSQLServer="Yes" ConfigStdAccounts="Yes" ConfigSysDB="Yes" ConfigSysIndex="Yes" ConfigSysManagement="Yes" InstABE="Yes" InstBOL="Yes" InstBIDS="Yes" InstBIDSHelper="Yes" InstDB2OLE="Yes" InstDTSDesigner="Yes" InstDTSBackup="Yes" InstIntViewer="Yes" InstJavaDBC="Yes" InstMDXStudio="Yes" InstNet3="No" InstPDFReader="Yes" InstPerfDash="Yes" InstProcExp="Yes" InstProcMon="Yes" InstRawReader="Yes" InstRMLTools="Yes" InstRptTaskPad="Yes" InstSP="Yes" InstSPCU="Yes" InstSPCUSNAC="No" InstSQLAS="Yes" InstSQLBC="Yes" InstSQLDB="Yes" InstSQLDBFT="Yes" InstSQLDBRepl="Yes" InstSQLIS="Yes" InstSQLNexus="Yes" InstSQLNS="Yes" InstSQLRS="Yes" InstSQLTools="Yes" InstSSMS="Yes" InstSystemViews="Yes" InstTrouble="Yes" InstXEvents="Yes" InstXMLNotepad="Yes" SetupBOL="Yes" SetupCMD="Yes" SetupDTCCluster="Yes" SetupDTCNetAccess="No" SetupFirewall="Yes" SetupMyDocs="Yes" SetupNetTrust="Yes" SetupShares="Yes" SetupSSISCluster="No" SetupSSMS="Yes" SetupVS="Yes" SetupWindows="Yes" UserConfiguration="Yes" UserPreparation="Yes" />
  </BuildServer>
  <BuildWorkstation spConfigureCLREnabled="1" spConfigureMaxServerMemory="" spConfigureOptimizeForAdHocWorkloads="1" spConfigureRemoteAdminConnections="1" spConfigurexpCmdshell="0">
    <Flags ConfigCmdshell="Yes" ConfigDBAManagement="Yes" ConfigDBMail="Yes" ConfigDBOpts="Yes" ConfigDisableSA="Yes" ConfigGenMaint="Yes" ConfigFT="Yes" ConfigMenus="Yes" ConfigNetwork="Yes" ConfigNonSAAccounts="Yes" ConfigOLAP="Yes" ConfigOLAPAPI="Yes" ConfigOldAccounts="Yes" ConfigParam="Yes" ConfigSAAccounts="Yes" ConfigServices="Yes" ConfigSQLAgent="Yes" ConfigSQLInst="Yes" ConfigSQLMail="Yes" ConfigSQLServer="Yes" ConfigStdAccounts="Yes" ConfigSysDB="Yes" ConfigSysIndex="Yes" ConfigSysManagement="Yes" InstABE="Yes" InstBOL="Yes" InstBIDS="Yes" InstBIDSHelper="Yes" InstBPAnalyzer="Yes" InstDB2OLE="Yes" InstDTSDesigner="Yes" InstDTSBackup="Yes" InstIntViewer="Yes" InstJavaDBC="Yes" InstMDXStudio="Yes" InstNet3="No" InstPDFReader="Yes" InstPerfDash="Yes" InstProcExp="Yes" InstProcMon="Yes" InstRawReader="Yes" InstRMLTools="Yes" InstRptTaskPad="Yes" InstSP="Yes" InstSPCU="Yes" InstSPCUSNAC="No" InstSQLAS="Yes" InstSQLBC="Yes" InstSQLDB="Yes" InstSQLDBFT="Yes" InstSQLDBRepl="Yes" InstSQLIS="Yes" InstSQLNS="Yes" InstSQLNexus="Yes" InstSQLRS="Yes" InstSQLTools="Yes" InstSSMS="Yes" InstSystemViews="Yes" InstTrouble="Yes" InstXEvents="Yes" InstXMLNotepad="Yes" SetupBOL="Yes" SetupCMD="Yes" SetupDTCCluster="No" SetupDTCNetAccess="No" SetupFirewall="Yes" SetupMyDocs="No" SetupNetTrust="Yes" SetupShares="Yes" SetupSSISCluster="No" SetupSSMS="Yes" SetupVS="Yes" SetupWindows="Yes" UserConfiguration="Yes" UserPreparation="Yes" />
  </BuildWorkstation>
  <Files ABEx64msi="ABEUIx64.msi" ABEx86msi="ABEUIx86.msi" BIDSexe="BIDSHelper2005Setup(1.5.0.0).exe" BOLmsi="SqlServer2K5_BOL_Jan2009.msi" BPAmsi="SQLBPASetup.msi" DB2exe="DB2OLEDB.exe" DBAManagementCab="SqlDBAManagement.cab" DBAManagementbat="Install.bat" DTSmsi="SQLServer2005_DTS.msi" DTSBackupmsi="DTSBackup2000.msi" DTSFix="KB917406.sqlwb.exe.manifest" GenMaintCab="GenericMaintenance.cab" GenMaintBat="INSTALL.BAT" IntViewermsi="InternalsViewerInstaller.msi" Javaexe="sqljdbc_1.2.2828.100_enu.exe" KB932232exe="VS80sp1-KB932232-X86-ENU.exe" KB954961exe="VS80sp1-KB954961-X86-INTL.exe" MDXZip="MDXStudio2005.zip" MDXexe="MDXStudio.exe" PDFexe="SumatraPDF-1.7-install.exe" PDFReg="SumatraPDF" PerfDashmsi="SQLServer2005_PerformanceDashboard.msi" ProcExpZip="ProcessExplorer.zip" ProcExpexe="procexp.exe" ProcMonZip="ProcessMonitor.zip" ProcMonexe="Procmon.exe" ProgCacls="cacls" ProgNtrights="ntrights" ProgReg="reg" RawReaderexe="RawFileReader.exe" RMLToolsX86msi="RMLSetup_X86.msi" RMLToolsX64msi="RMLSetup_AMD64.msi" SP2X86="SQLServer2005SP2-KB921896-x86-ENU.exe" SP2X86Exp="" SP2X86CU1="sqlserver2005-kb935356-x86-enu.exe" SP2X86CU2="sqlserver2005-kb936305-x86-enu.exe" SP2X86CU3="sqlserver2005-kb939537-x86-enu.exe" SP2X86CU4="sqlserver2005-kb941450-x86-enu.exe" SP2X86CU5="sqlserver2005-kb943656-x86-enu.exe" SP2X86CU6="sqlserver2005-kb946608-x86-enu.exe" SP2X86CU7="sqlserver2005-kb949095-x86-enu.exe" SP2X86CU8="SQLServer2005-KB951217-x86-ENU.exe" SP2X86CU9="sqlserver2005-kb953752-x86-enu.exe" SP2X86CU10="sqlserver2005-kb956854-x86-enu.exe" SP2X86CU11="sqlserver2005-kb958753-x86-enu.exe" SP2X86CU12="sqlserver2005-kb962970-x86-enu.exe" SP2X86CU13="sqlserver2005-kb967908-x86-enu.exe" SP2X86CU14="sqlserver2005-kb970278-x86-enu.exe" SP2X86CU15="sqlserver2005-kb972510-x86-enu.exe" SP2X86CU16="sqlserver2005-kb974647-x86-enu.exe" SP2X86CU17="sqlserver2005-kb976952-x86-enu.exe" SP2X64="SQLServer2005SP2-KB921896-x64-ENU.exe" SP2X64Exp="" SP2X64CU1="sqlserver2005-kb935356-x64-enu.exe" SP2X64CU2="sqlserver2005-kb936305-x64-enu.exe" SP2X64CU3="sqlserver2005-kb939537-x64-enu.exe" SP2X64CU4="sqlserver2005-kb941450-x64-enu.exe" SP2X64CU5="sqlserver2005-kb943656-x64-enu.exe" SP2X64CU6="sqlserver2005-kb946608-x64-enu.exe" SP2X64CU7="sqlserver2005-kb949095-x64-enu.exe" SP2X64CU8="SQLServer2005-KB951217-x64-ENU.exe" SP2X64CU9="sqlserver2005-kb953752-x64-enu.exe" SP2X64CU10="sqlserver2005-kb956854-x64-enu.exe" SP2X64CU11="sqlserver2005-kb958753-x64-enu.exe" SP2X64CU12="sqlserver2005-kb962970-x64-enu.exe" SP2X64CU13="sqlserver2005-kb967908-x64-enu.exe" SP2X64CU14="sqlserver2005-kb970278-x64-enu.exe" SP2X64CU15="sqlserver2005-kb972510-x64-enu.exe" SP2X64CU16="sqlserver2005-kb974647-x64-enu.exe" SP2X64CU17="sqlserver2005-kb976952-x64-enu.exe" SP3X86="SQLServer2005SP3-KB955706-x86-ENU.exe" SP3X86Exp="SQLEXPR32.exe" SP3X86CU1="SQLServer2005-KB959195-x86-ENU.exe" SP3X86CU2="sqlserver2005-kb961920-x86-enu.exe" SP3X86CU3="sqlserver2005-kb967909-x86-enu.exe" SP3X86CU4="sqlserver2005-kb970279-x86-enu.exe" SP3X86CU5="sqlserver2005-kb972511-x86-enu.exe" SP3X86CU6="sqlserver2005-kb974648-x86-enu.exe" SP3X86CU7="sqlserver2005-kb960598-x86-enu.exe" SP3X86CU8="sqlserver2005-kb978915-x86-enu.exe" SP3X86CU9="sqlserver2005-kb980176-x86-enu.exe" SP3X86CU10="sqlserver2005-kb983329-x86-enu.exe" SP3X86CU11="sqlserver2005-kb2258854-x86-enu.exe" SP3X86CU12="sqlserver2005-kb2345449-x86-enu.exe" SP3X86CU13="sqlserver2005-kb2438344-x86-enu.exe" SP3X86CU14="sqlserver2005-kb2489375-x86-enu.exe" SP3X86CU15="sqlserver2005-kb2507766-x86-enu.exe" SP3X64="SQLServer2005SP3-KB955706-x64-ENU.exe" SP3X64Exp="SQLEXPR.exe" SP3X64CU1="SQLServer2005-KB959195-x64-ENU.exe" SP3X64CU2="sqlserver2005-kb961930-x64-enu.exe" SP3X64CU3="sqlserver2005-kb967909-x64-enu.exe" SP3X64CU4="sqlserver2005-kb970279-x64-enu.exe" SP3X64CU5="sqlserver2005-kb972511-x64-enu.exe" SP3X64CU6="sqlserver2005-kb974648-x64-enu.exe" SP3X64CU7="sqlserver2005-kb960598-x64-enu.exe" SP3X64CU8="sqlserver2005-kb978915-x64-enu.exe" SP3X64CU9="sqlserver2005-kb980176-x64-enu.exe" SP3X64CU10="sqlserver2005-kb983329-x64-enu.exe" SP3X64CU11="sqlserver2005-kb2258854-x64-enu.exe" SP3X64CU12="sqlserver2005-kb2345449-x64-enu.exe" SP3X64CU13="sqlserver2005-kb2438344-x64-enu.exe" SP3X64CU14="sqlserver2005-kb2489375-x64-enu.exe" SP3X64CU15="sqlserver2005-kb2507766-x64-enu.exe" SP4X86="SQLServer2005SP4-KB2463332-x86-ENU.exe" SP4X86Exp="" SP4X86CU1="sqlserver2005-kb2464079-x86-enu.exe" SP4X86CU2="sqlserver2005-kb2489409-x86-enu.exe" SP4X86CU3="sqlserver2005-kb2507769-x86-enu.exe" SP4X86CU4="SQLServer2005-KB2494123-x86-ENU.exe" SP4X64="SQLServer2005SP4-KB2463332-x64-ENU.exe" SP4X64Exp="" SP4X64CU1="sqlserver2005-kb2464079-x64-enu.exe" SP4X64CU2="sqlserver2005-kb2489409-x64-enu.exe" SP4X64CU3="sqlserver2005-kb2507769-x64-enu.exe" SP4X64CU4="SQLServer2005-KB2494123-x64-ENU.exe" SQLExpX86Exe="SQLEXPRADV_x86_ENU.exe" SQLExpX64Exe="SQLEXPRADV_x64_ENU.exe" SQLFullEXE="Servers\Setup.exe" SQLNexuszip="sql nexus 2.5.0.7.zip" SysManagementCab="SqlSysManagement.cab" SysManagementbat="Install.bat" SystemViewsPDF="SQL_Server_2005_System_Views_Poster.pdf" RptTaskPadRdl="SQL2000 Taskpad View.rdl" TroublePDF="Troubleshooting Performance Problems SQL2005.pdf" UserConfigurationvbs=".\Build Scripts\User2Configuration.vbs" UserPreparationvbs=".\Build Scripts\User1Preparation.vbs" VS2005SP1exe="VS80sp1-KB926601-X86-ENU.exe" XMLmsi="XmlNotepad.msi"></Files>
</SQL2005Config>
Coordinator
Aug 29, 2011 at 10:33 AM

This is a bug inFineBuild.  The intention was to screen out local accounts (servername\account) but allow NT AUTHORITY and domain accounts.  I will fix this in the next published version of FineBuild.

As a workaround, add the following parameter when you run FineBuild /Validate:NO  The NO must be in upper case.  It is not a good idea to use /Validate:NO in normal situations, as the validation is intended to only catch conditions that would cause the SQL Server install to fail.

Coordinator
Aug 29, 2011 at 10:43 AM

The FULL install is intended for production server instances, and does not include the tools unless you ask for them.  If you want to get the tools and use the network service for all accounts, the best option is to use the SQLFineWorkstation file.

The tools are not included for a FULL install because best practice is that for production servers the DBA should never log on to the SQL Server box except in an emergency.  Any time a person logs on to a computer you increase the risk of accidently doing something that could cause the box to crash.  All management of the servers should be done from a dedicated Administration machine.  You can use the SQLFineClient to install just the SQL tools to set up the administration machine.

However, if you want to include the SQL tools on a FULL install, add the /SQLTools:Yes parameter to the SQLFineServer file.

Aug 29, 2011 at 6:05 PM

Ed,

First off thanks for all the help, these scripts are truly amazing.

Working with the previous suggestions I started over with a clean SQL2005Config and used the Workstation install.

Everything seemed to install fine but I got an error near the end:

Process Id 2CA: Reset DBA Permissions at 9:54:59 AM
***** Error has occurred *****
 Process    : 2CA: Reset DBA Permissions
 Error code : -2147023559
 Last Action: Reset DBA Registry perm: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\
 SQL Server Base Install failed

This left it where I could not log in with a local admin account or the SA account. I'm not sure where it went wrong. I probably should have started off with all the information I could but here it is now.

The systems I will be using the script on are Windows 7 x64 Enterprise. I am doing a named instance, SQL05, because I will also be installing SQL 2008. Security isn't a huge issue, it is a development environment.

Here is the batch file I used:

@ECHO OFF
REM Copyright � 2008, 2011 Edward Vassie.  Distributed under Ms-Pl License
REM
CALL "SqlFineBuild.bat" %*     /Type:Workstation             /IAcceptLicenseTerms          ^
 /SAPWD:"DCTsql#1" /Validate:NO ^
 /Instance:SQL05	/TCPPort:1434

Also, to get it to run I had to use the "run as administrator" command even though the logged in account is a local admin in Windows 7.

Aug 29, 2011 at 8:20 PM

I apologize for not reading the manual with more scrutiny. I did find the part regarding the UAC, thanks to VM's I'm giving it another go with UAC turned off.

Aug 30, 2011 at 1:05 PM

Well turning off the UAC did not resolve the error I am getting. I will take a look to see what is happening in the script at that point and if I figure it out I will relay that back here.

Coordinator
Aug 31, 2011 at 6:25 PM

Are you installing a 32-bit version of SQL Server on a 64-bit OS?  If so then FineBuild is using the wrong registry key, just delete the call to ResetDBARegPerm. 

Aug 31, 2011 at 9:41 PM

I'm installing the 64-bit version on a 64-bit OS. I did comment out the calls to ResetDBARegPerm though to move on. Still having issues in other scripts, seems like anything that makes a call to the registry is having a problem.

I'm getting closer though, and even with errors I can get it to install and update to SP4 and can log in. So that's really all I'm going for.

Coordinator
Sep 9, 2011 at 2:33 PM
Edited Sep 9, 2011 at 2:38 PM

FineBuild V3.0.0 should fix these problems.  If you use /GroupDBA:"" then FineBuild will default to using the local Administrators group.