AutoSPInstaller and SQL 2012

Mar 21, 2012 at 5:51 PM

Greetings All

     Having some trouble using SPInstaller with SQL 2012 (demo purposes only).  Has anyone run into this issue (see below).

           - xdemo\spaccountadmin does not have '' role!

     In summary, the account I am using is a 'box admin' with 'sysadmin' right on the SQL server. Permissions have been verified.

     Ideas/recomendations are greatly appreciated.

Thanks for reading

Rob

Transcript started, output file is C:\Users\spaccountadmin\Desktop\AutoSPInstal
ler-2012-03-21_1-11.rtf
-----------------------------------
| Automated SP2010 install script |
| Started on: 3/21/2012 1:11:35 PM |
-----------------------------------
--------------------------------------------------------------
- Validating user accounts and passwords...
- Account "xdemo\SPFarmReport"...Verified.
- Account "xdemo\SPFarmReport"...Verified.
- Account "xdemo\SPAppPoolReport"...Verified.
- Account "xdemo\SPAppPoolReport"...Verified.
- Account "xdemo\SPSearchCAReport"...Verified.
- Account "xdemo\SPSearchCAReport"...Verified.
- Account "xdemo\SPSearchCAReport"...Verified.
- Account "xdemo\SPAppPoolReport"...Verified.
- Account "xdemo\SPServicesReport"...Verified.
- Account "xdemo\SPServicesReport"...Verified.
- Account "xdemo\SPServicesReport"...Verified.
--------------------------------------------------------------
--------------------------------------------------------------
- Testing access to SQL server/instance/alias: AZxxxxxxx
- Trying to connect to "AZxxxxxxx"...Success
- SQL Server version is: 11.0.2100.60
Fail
--------------------------------------------------------------
- Script aborted!
- xdemo\spaccountadmin does not have '' role!
-----------------------------------
| Automated SP2010 install script |
| Started on: 3/21/2012 1:11:35 PM |
| Aborted:    3/21/2012 1:11:37 PM |
-----------------------------------
Transcript stopped, output file is C:\Users\spaccountadmin\Desktop\AutoSPInstal
ler-2012-03-21_1-11.rtf
Press any key to exit...

 

Coordinator
Mar 22, 2012 at 2:47 AM

Have you modified the script itself at all? It looks like the $serverRole variable doesn't have a value, whereby it should normally it should loop through the values in $serverRolesToCheck.

Also SQL 2012 support was only added fairly recently; are you using a current version of AutoSPInstaller?

Brian

Mar 23, 2012 at 5:50 PM

I am also getting the same error when trying to run the script. I am using AutoSPInstaller 2.5.7 with a clean build of SQL 2012 Ent. I did notice that that all of the Server Roles in SQL are disabled except for public. I have ensured that the SPadmin account has dbcreator and securityadmin roles, but still get the same message as rhodesr described above. Any clues as to what I'm doing wrong? This same script has worked fine in SQL 2008 R2.

Rob

Coordinator
Mar 23, 2012 at 6:47 PM

Right, 2.5.7 didn't detect/support SQL 2012 - try the latest changeset (note that a bunch of other new stuff is in there too, make sure you review the release notes).

Brian

Mar 23, 2012 at 8:06 PM

      No mods to the script (only the input file).  I recently downloaded the latest version (on 3/19) from which I am running this build.

Coordinator
Mar 24, 2012 at 3:39 AM

Sorry for asking once again - but when you say the latest version do you mean the latest changeset listed above? Or the latest stable package (which hasn't been updated since November)?

If it is the latest changeset, could you try assigning the dbcreator and securityadmin roles to the login as well as the existing sysadmin? It shouldn't need this but I'm curious if perhaps it's failing because those two roles weren't explicitly assigned.

Brian

Mar 26, 2012 at 2:13 AM

brianlala, I downloaded the "Change Set 86963" version 3 that you suggested and it worked great! I was able to install SP on a new VM with a separate SQL 2012 VM. I set the RemoteInstall to true, but only ran it locally.

 In my DEV environment, I have 2 servers - SP2012 (SharePoint) and SQL2012 (SQL 2012). I have a handful of accounts for various services. I am logged in as robdev\sp2012 for the install. I had added this account to my SQL 2012 server as sysadmin, dbcreator, and securityadmin. Here is the output of the install:

**********************
Windows PowerShell Transcript Start
Start time: 20120323142752
Username  : ROBDEV\sp2012 
Machine	  : SP2012 (Microsoft Windows NT 6.1.7601 Service Pack 1) 
**********************
Transcript started, output file is C:\Users\sp2012\Desktop\AutoSPInstaller-2012
-03-23_2-27.rtf
-----------------------------------
| Automated SP2010 install script |
| Started on: 3/23/2012 2:27:52 PM |
-----------------------------------
 - SharePoint binaries are already installed.
--------------------------------------------------------------
 - Validating user accounts and passwords...
 - Account "robdev\sp2012"...Verified.
 - Account "robdev\spservice"...Verified.
 - Account "robdev\spapppoolportal"...Verified.
 - Account "robdev\spapppoolmysite"...Verified.
 - Account "robdev\SPsearchsvc"...Verified.
 - Account "robdev\SPSearchsvc"...Verified.
 - Account "robdev\spfsearchcaacc"...Verified.
 - Account "robdev\SPSearchsvc"...Verified.
 - Account "robdev\spexcel"...Verified.
 - Account "robdev\spvisio"...Verified.
 - Account "robdev\spperfpoint"...Verified.
 - Account "robdev\spexcel"...Verified.
--------------------------------------------------------------
--------------------------------------------------------------
 - Testing access to SQL server/instance/alias: sql2012
 - Trying to connect to "sql2012"...Success
 - SQL Server version is: 11.0.2100.60
 - This instance of SQL Server is not clustered
 - Check if ROBDEV\sp2012 has dbcreator server role...Pass
 - Check if ROBDEV\sp2012 has securityadmin server role...Pass
--------------------------------------------------------------
 - Install based on: 
 - c:\SP2010\AutoSPInstaller\\AutoSPInstallerInput.xml 
 - Environment: Dev 
 - Version: 3.0
--------------------------------------------------------------
 - Disabling Loopback Check...
--------------------------------------------------------------
--------------------------------------------------------------
 - Disabling IE Enhanced Security...
--------------------------------------------------------------
--------------------------------------------------------------
 - Setting services Spooler, AudioSrv and TabletInputService to Manual...
 - Spooler is already stopped and set Manual, no action required.
 - AudioSrv is already stopped and set Manual, no action required.
 - TabletInputService is already stopped and set Manual, no action required.
 - Setting unused services WerSvc to Disabled...
 - WerSvc is already stopped and disabled, no action required.
 - Finished disabling services.
--------------------------------------------------------------
--------------------------------------------------------------
 - Not changing CRL check behavior.
--------------------------------------------------------------
--------------------------------------------------------------
 - SP2010 prerequisites appear be already installed - skipping install.
--------------------------------------------------------------
--------------------------------------------------------------
 - Configuring IIS logging...
 - c:\Logs\IIS is already compressed.
--------------------------------------------------------------
--------------------------------------------------------------
 - SP2010 binaries appear to be already installed - skipping installation.
--------------------------------------------------------------
--------------------------------------------------------------
 - Office Web Apps binaries appear to be already installed - skipping install.
--------------------------------------------------------------
--------------------------------------------------------------
 - No language packs found in C:\SP2010\LanguagePacks, skipping.
 - Currently installed languages:
  - English (United States)
--------------------------------------------------------------
 - SharePoint 2010 binary file installation done!
--------------------------------------------------------------
 - Adding robdev\sp2012 to local Administrators ...
 - robdev\sp2012 is already a member of "Administrators".
--------------------------------------------------------------
--------------------------------------------------------------
 - Loading SharePoint Powershell Snapin
--------------------------------------------------------------
--------------------------------------------------------------
 - Checking farm membership for SP2012 in "SP2012_Config"...

 - Attempting to join farm on "SP2012_Config"...
 - No existing farm found.
 - Creating config database "SP2012_Config"...
 - Done creating configuration database for farm.
--------------------------------------------------------------
--------------------------------------------------------------
 - Configuring the SharePoint farm/server...
 - Installing Help Collection...
 - Securing Resources...
 - Installing Services...
 - Installing Features...
 - Creating Central Admin site...
 - Waiting for Central Admin site...Online
 - Installing Application Content...
 - Creating Version registry value (workaround for bug in PS-based install)
 - Getting version number... 14.0.0.6114
 - Done initial farm/server config.
--------------------------------------------------------------
--------------------------------------------------------------
 - Configuring SharePoint diagnostic (ULS) logging...
 - c:\Logs\SharePointULS doesn't exist; creating...
 - Setting SharePoint diagnostic (ULS) logging options:
  - DaysToKeepLogs: 14
  - LogMaxDiskSpaceUsageEnabled: True
  - LogDiskSpaceUsageGB: 20
  - LogLocation: c:\Logs\SharePointULS
  - LogCutInterval: 30
 - Moving any contents in old location C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS\ to c:\Logs\SharePointULS...
 - Compressing c:\Logs\SharePointULS and subfolders...
--------------------------------------------------------------
--------------------------------------------------------------
 - Configuring Office Web Apps...
 - Installing Help Collection...
 - Installing Application Content...
 - Securing Resources...
 - Installing Services...
 - Installing Features...
--------------------------------------------------------------
--------------------------------------------------------------
 - Adding Managed Accounts
 - Creating local profile for robdev\spservice...Done.
 - Registering managed account robdev\spservice...
 - Creating local profile for robdev\spapppoolportal...Done.
 - Registering managed account robdev\spapppoolportal...
 - Creating local profile for robdev\spapppoolmysite...Done.
 - Registering managed account robdev\spapppoolmysite...
 - Creating local profile for robdev\SPsearchsvc...Done.
 - Registering managed account robdev\SPsearchsvc...
 - Done Adding Managed Accounts
--------------------------------------------------------------
--------------------------------------------------------------
 - Creating web applications...
 - Creating Web App "Portal Home"
 - Setting up managed paths for "http://sp2012:80"
 - Setting up explicit managed path "help" at "http://sp2012:80"
 - Setting up managed path "teams" at "http://sp2012:80"
 - Setting up managed path "depts" at "http://sp2012:80"
 - Setting up managed path "sites" at "http://sp2012:80"
 - Setting up managed path "corp" at "http://sp2012:80"
 - Setting up explicit managed path "search" at "http://sp2012:80"
 - Setting up explicit managed path "broadcast" at "http://sp2012:80"
 - Done setting up managed paths at "http://sp2012:80"
 - Granting robdev\spservice rights to "Portal Home"...Done.
 - Creating Site Collection "http://sp2012"...
 - Updating the locale for "Portal Home" to "en-us"...
 - Updating 24 hour time format for "Portal Home" to "false"...
--------------------------------------------------------------
 - Applying object cache accounts to "http://sp2012:80"...
 - Done applying object cache accounts to "http://sp2012:80"
 - Setting online webpart catalog access for "http://sp2012:80"
--------------------------------------------------------------
 - Creating Web App "MySite Host"
 - Setting up managed paths for "http://mysp2012:80"
 - Setting up managed path "personal" at "http://mysp2012:80"
 - Deleting managed path "sites" at "http://mysp2012:80"
 - Done setting up managed paths at "http://mysp2012:80"
 - Granting robdev\spservice rights to "MySite Host"...Done.
 - Creating Site Collection "http://mysp2012"...
 - Setting the Portal Site Connection for "My Site Host"...
 - Updating the locale for "My Site Host" to "en-us"...
 - Updating 24 hour time format for "My Site Host" to "false"...
--------------------------------------------------------------
 - Applying object cache accounts to "http://mysp2012:80"...
 - Done applying object cache accounts to "http://mysp2012:80"
 - Setting online webpart catalog access for "http://mysp2012:80"
--------------------------------------------------------------
 - Adding HOSTS file entries for local resolution...
 - Backing up HOSTS file to:
 - C:\Windows\System32\drivers\etc\HOSTS.120323143558.copy
 - Adding HOSTS file entry for "mysp2012"...
 - Adding HOSTS file entry for "sp2012"...
--------------------------------------------------------------
--------------------------------------------------------------
 - Provisioning State Service Application...
 - Creating State Service Application Proxy...
 - Done creating State Service Application.
--------------------------------------------------------------
--------------------------------------------------------------
 - Provisioning Managed Metadata Service Application
 - Creating SharePoint Hosted Services Application Pool...
 - Starting Managed Metadata Service:
 - Starting Metadata Service Instance...
 - Waiting for Metadata service...Online
 - Creating Metadata Service Application...
 - Creating Metadata Service Application Proxy...
 - Granting rights to Metadata Service Application...
 - Done creating Managed Metadata Service Application.
--------------------------------------------------------------
--------------------------------------------------------------
 - Starting Claims to Windows Token Service...
 - Waiting for Claims to Windows Token Service...Online
--------------------------------------------------------------
--------------------------------------------------------------
 - Provisioning User Profile Service Application
 - Starting User Profile Service instance...
 - Waiting for User Profile Service...Online
 - Web app "MySite Host" already provisioned.
 - Creating User Profile Service Application...
 - Waiting for User Profile Service Application...............................Online
 - Creating User Profile Service Application Proxy...
 - Granting rights to User Profile Service Application...
 - Granting robdev\spapppoolportal rights to SP2012_...
 - Granting robdev\spapppoolportal rights to SP2012_...
 - Enabling the Activity Feed Timer Job..
 - Done creating User Profile Service Application.
 - Could not get User Profile Service, or StartProfileSync is False.
--------------------------------------------------------------
--------------------------------------------------------------
 - Provisioning SP Usage Application...
 - Fixing Usage and Health Data Collection Proxy...
 - Enabling usage processing timer job...
 - Done provisioning SP Usage Application.
--------------------------------------------------------------
--------------------------------------------------------------
 - Configuring Usage Logging...
 - c:\Logs\SharePointUseage doesn't exist; creating...
 - Moving any contents in old location C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS\ to c:\Logs\SharePointUseage...
 - Compressing c:\Logs\SharePointUseage and subfolders...
 - Done configuring usage logging.
--------------------------------------------------------------
--------------------------------------------------------------
 - Provisioning Web Analytics Service Application...
 - Checking Analytics Service instances...
 - Starting local Analytics Web Service instance...
 - Updating Web Analytics Data Processing Service to run as ROBDEV\spservice...
 - Starting local Analytics Data Processing Service instance...
 - Creating Web Analytics Service Application...
 - Creating Web Analytics Service Application Proxy...
--------------------------------------------------------------
--------------------------------------------------------------
 - Provisioning Secure Store Service Application...
 - Starting Secure Store Service Instance...
 - Waiting for Secure Store service...Online
 - Creating Secure Store Service Application...
 - Creating Secure Store Service Application Proxy...
 - Done creating Secure Store Service Application.
 - Creating the Master Key...
 - Creating the Application Key...
 - Done creating/configuring Secure Store Service Application.
--------------------------------------------------------------
--------------------------------------------------------------
 - Applying service account robdev\spservice to service SPSearch4...
 - Done.
--------------------------------------------------------------
--------------------------------------------------------------
 - Applying service account robdev\spservice to service SPTraceV4...
 - Adding robdev\spservice to local Performance Monitor Users group...
 - robdev\spservice is already a member of Performance Monitor Users.
 - Adding robdev\spservice to local Performance Log Users group...
 - Updating service account...
 - Restarting service SPTraceV4...
 - Done.
--------------------------------------------------------------
--------------------------------------------------------------
 - Provisioning Enterprise Search...
 - Setting default index location on search service...
 - Getting robdev\SPSearchsvc account for application pool...
 - Creating SharePoint Search Application Pool...
 - Creating Search Service Application...
 - Setting administration component...
 - Waiting for administration component initialization............................................................Done.
 - Setting content access account for Search Service Application...
Set-SPEnterpriseSearchServiceApplication : An update conflict has occurred, and
 you must re-try this action. The object SearchServiceApplication Name=Search S
ervice Application was updated by ROBDEV\sp2012, in the OWSTIMER (2532) process
, on machine SP2012.  View the tracing log for more information about the confl
ict.
At C:\SP2010\AutoSPInstaller\AutoSPInstallerFunctions.ps1:2933 char:56
+         $searchApp | Set-SPEnterpriseSearchServiceApplication <<<<  -DefaultC
ontentAccessAccountName $svcConfig.EnterpriseSearchServiceApplications.Enterpri
seSearchServiceApplication.ContentAccessAccount `
    + CategoryInfo          : InvalidData: (Microsoft.Offic...viceApplication: 
   SetSearchServiceApplication) [Set-SPEnterpriseSearchServiceApplication], S  
  PUpdatedConcurrencyException
    + FullyQualifiedErrorId : Microsoft.Office.Server.Search.Cmdlet.SetSearchS 
   erviceApplication
 
 - Creating new crawl topology...
 - Creating new crawl component...
 - Creating new query topology...
 - Creating new query component...
 - Setting index partition and property store database...
 - Starting Search Query and Site Settings Service Instance...
 - Waiting for Search Query and Site Settings service...Online
 - Setting new crawl topology to active...
 - Waiting for Crawl Components............................................................................................................Active
 - Setting query topology as active...
 - Waiting for Query Components...Active
 - Creating enterprise search service application proxy...
 - Creating network share "SearchIndex=C:\SearchIndexes"
--------------------------------------------------------------
--------------------------------------------------------------
 - Provisioning Business Data Connectivity Service
 - Checking local service instance...
 - Starting Business Data Connectivity Service...
 - Waiting for Business Data Connectivity Service...Online
 - Creating Business Data Connectivity Service...
 - Done creating Business Data Connectivity Service.
--------------------------------------------------------------
--------------------------------------------------------------
 - Provisioning Excel Services Application...
 - Checking local service instance...
 - Starting Excel Calculation Services...
 - Waiting for Excel Calculation Services...Online
 - Creating Excel Services Application...
 - Re-importing SP PowerShell Snapin to enable new cmdlets...
--------------------------------------------------------------
 - Loading SharePoint Powershell Snapin
--------------------------------------------------------------
 - Configuring service app settings...
 - Setting unattended account credentials...
 - Creating Secure Store Target Application 99f00101-2b37-43fa-8ffc-3fb2a9ecd3c9-ExcelUnattendedAccount...
 - Creating Secure Store Application...
 - Updating Secure Store Group Credential Mapping...
 - Done creating Excel Services Application.
--------------------------------------------------------------
--------------------------------------------------------------
 - Provisioning Access Services...
 - Checking Access Database Service instance...
 - Starting Access Database Service instance...
 - Waiting for Access Database Service instance...Online
 - Creating Access Services...
 - Provisioning Access Services Proxy...
--------------------------------------------------------------
--------------------------------------------------------------
 - Provisioning Visio Graphics Service...
 - Checking Visio Graphics Service instance...
 - Starting Visio Graphics Service instance...
 - Waiting for Visio Graphics Service instance...Online
 - Creating Visio Graphics Service...
 - Provisioning Visio Graphics Service Proxy...
 - Setting unattended account credentials...
 - Creating Secure Store Target Application 01506294-4bdb-45ac-a439-b6a47352e980-VisioUnattendedAccount...
 - Creating Secure Store Application...
 - Updating Secure Store Group Credential Mapping...
 - Setting Application ID for Visio Service...
--------------------------------------------------------------
--------------------------------------------------------------
 - Provisioning PerformancePoint Service...
 - Checking PerformancePoint Service instance...
 - Starting PerformancePoint Service instance...
 - Waiting for PerformancePoint Service instance...Online
 - Creating PerformancePoint Service...
 - Provisioning PerformancePoint Service Proxy...
 - Granting robdev\sp2012 rights to database SP2012_PerformancePointDB...
Add-SPShellAdmin : 
     "Cannot add robdev\sp2012 to the SharePoint_Shell_Access role of the datab
ase SP2012_PerformancePointDB. A possible cause of this error is that the accou
nt name was already added to the database as a login using a different user nam
e than the account name."
At C:\SP2010\AutoSPInstaller\AutoSPInstallerFunctions.ps1:3549 char:79
+             Get-SPDatabase | Where {$_.Name -eq $PerformancePointDB} | Add-SP
ShellAdmin <<<<  -UserName $FarmAcct
    + CategoryInfo          : InvalidData: (Microsoft.Share...AddSPShellAdmin: 
   SPCmdletAddSPShellAdmin) [Add-SPShellAdmin], ArgumentException
    + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletAddSPShe 
   llAdmin
 
 - Setting PerformancePoint Data Source Unattended Service Account...
--------------------------------------------------------------
--------------------------------------------------------------
 - Provisioning Word Automation Services...
 - Checking Word Automation Services instance...
 - Starting Word Automation Services instance...
 - Waiting for Word Automation Services instance...Online
 - Creating Word Automation Services...
 - Provisioning Word Automation Services Proxy...
--------------------------------------------------------------
--------------------------------------------------------------
 - Provisioning PowerPoint Service Application...
 - Checking PowerPoint Service instance...
 - Starting PowerPoint Service instance...
 - Waiting for PowerPoint Service instance...Online
 - Creating PowerPoint Service Application...
 - Provisioning PowerPoint Service Application Proxy...
--------------------------------------------------------------
--------------------------------------------------------------
 - Provisioning Word Viewing Service...
 - Checking Word Viewing Service instance...
 - Starting Word Viewing Service instance...
 - Waiting for Word Viewing Service instance...Online
 - Creating Word Viewing Service...
 - Provisioning Word Viewing Service Proxy...
--------------------------------------------------------------
--------------------------------------------------------------
 - Configuring Outgoing Email...
--------------------------------------------------------------
--------------------------------------------------------------
 - Configuring PDF file search, display and handling...
 - Configuring PDF file iFilter and indexing...
 - PDF iFilter installer found in C:\SP2010\PDF\.
 - Installing Adobe PDF iFilter...
 - Setting PDF search crawl extension...
 - PDF extension for Search Service Application now set.
 - Updating registry...
 - Restarting SharePoint Search Service...
 - Done configuring PDF iFilter and indexing.
 - Configuring PDF Icon...
 - PDF icon found at C:\SP2010\PDF\\icpdf.gif
 - PDF icon copied successfully.
 - Creating backup of DOCICON.XML file...
 - Writing new DOCICON.XML...
 - Restarting IIS...
 - Adding PDF MIME type "application/pdf" web apps...
  -  http://sp2012:80: Adding "application/pdf"...Done.
  -  http://mysp2012:80: Adding "application/pdf"...Done.
 - Done configuring PDF indexing and icon display.
--------------------------------------------------------------
--------------------------------------------------------------
 - Installing ForeFront binaries...
 - Done installing ForeFront.
--------------------------------------------------------------
 - Not changing local Admin membership of robdev\sp2012.
 - Adding Network Service to local WSS_WPG group (fixes event log warnings)...
 - Running all Health Analyzer jobs...
 - Completed! 
 - Launching Central Admin...
 - Launching http://sp2012...
 - Launching http://mysp2012...
-----------------------------------
| Automated SP2010 install script |
| Started on: 3/23/2012 2:27:52 PM |
| Completed:  3/23/2012 2:49:40 PM |
-----------------------------------
**********************
Windows PowerShell Transcript End
End time: 20120323145040
**********************

 

 

Mar 26, 2012 at 3:09 PM
No problem at all. I downloaded the latest stable package (November). It looks like that may be the issue I am running into.
I will download the latest version and try my script again.
Thanks
Rob
On 03/23/12, brianlala<NOTIFICATIONS@codeplex.com> wrote:

From: brianlala

Sorry for asking once again - but when you say the latest version do you mean the latest changeset listed above? Or the latest stable package (which hasn't been updated since November)?

If it is the latest changeset, could you try assigning the dbcreator and securityadminroles to the login as well as the existing sysadmin? It shouldn't need this but I'm curious if perhaps it's failing because those two roles weren't explicitly assigned.

Brian