none
The credentials you provided for analysis services service are invalid. To continue, provide a valid account and password for analysis services service. RRS feed

  • Question

  • Hi

    I'm trying to install powerpivot with sharepoint integration mode on a server using sql server 2012 installation wizard.

    I type in a domain user name and password and I get the error message :

    The credentials you provided for analysis services service are invalid. To continue, provide a valid account and password for analysis services service.

    Error result: -2068578304
    Result facility code: 1204

    Any ideas on how to get around this problem?

     I changed my password to s a strong type password. It made no difference.

    The server is a domain member server.

    Tuesday, October 9, 2012 9:48 AM

All replies

  • For the above problem here are details from the sql server 2012 log

    Overall summary:

    Final result: Failed: see details below

    Exit code (Decimal): -2068578304

    Exit facility code: 1204

    Exit error code: 0

    Exit message: The credentials you provided for the Analysis Services service are invalid. To continue, provide a valid account and password for the Analysis Services service.

    Start time: 2012-10-08 22:28:22

    End time: 2012-10-08 22:29:24

    Requested action: Install

    Setup completed with required actions for features.

    Troubleshooting information for those features:

    Next step for AS: SQL Server Setup was canceled before completing the operation. Try the setup process again.

    Next step for AS_SPI: SQL Server Setup was canceled before completing the operation. Try the setup process again.

    Next step for BOL: SQL Server Setup was canceled before completing the operation. Try the setup process again.

     

    Machine Properties:

    Machine name: VM-350B-EF54

    Machine processor count: 1

    OS version: Windows Server 2008 R2

    OS service pack: Service Pack 1

    OS region: United States

    OS language: English (United States)

    OS architecture: x64

    Process architecture: 64 Bit

    OS clustered: No

    Product features discovered:

    Product Instance Instance ID Feature Language Edition Version Clustered

    SQL Server 2012 MSSQLSERVER MSSQL11.MSSQLSERVER Database Engine Services 1033 Enterprise Evaluation Edition 11.0.2100.60 No

    SQL Server 2012 MSSQLSERVER MSAS11.MSSQLSERVER Analysis Services 1033 Enterprise Evaluation Edition 11.0.2100.60 No

    SQL Server 2012 Management Tools - Basic 1033 Enterprise Evaluation Edition 11.0.2100.60 No

    SQL Server 2012 Management Tools - Complete 1033 Enterprise Evaluation Edition 11.0.2100.60 No

    SQL Server 2012 Client Tools Connectivity 1033 Enterprise Evaluation Edition 11.0.2100.60 No

    SQL Server 2012 Reporting Services - SharePoint 11.0.2100.60 No

    Package properties:

    Description: Microsoft SQL Server 2012

    ProductName: SQL Server 2012

    Type: RTM

    Version: 11

    SPLevel: 0

    Installation location: D:\sqlfull_x64_enu\x64\setup\

    Installation edition: Evaluation

    Product Update Status:

    None discovered.

    User Input Settings:

    ACTION: Install

    ADDCURRENTUSERASSQLADMIN: false

    AGTSVCACCOUNT: <empty>

    AGTSVCPASSWORD: <empty>

    AGTSVCSTARTUPTYPE: Manual

    ASBACKUPDIR: C:\Program Files\Microsoft SQL Server\MSAS11.POWERPIVOT\OLAP\Backup

    ASCOLLATION: Latin1_General_CI_AS

    ASCONFIGDIR: C:\Program Files\Microsoft SQL Server\MSAS11.POWERPIVOT\OLAP\Config

    ASDATADIR: C:\Program Files\Microsoft SQL Server\MSAS11.POWERPIVOT\OLAP\Data

    ASLOGDIR: C:\Program Files\Microsoft SQL Server\MSAS11.POWERPIVOT\OLAP\Log

    ASPROVIDERMSOLAP: 1

    ASSERVERMODE: MULTIDIMENSIONAL

    ASSVCACCOUNT: EUR\AG01522

    ASSVCPASSWORD: *****

    ASSVCSTARTUPTYPE: Automatic

    ASSYSADMINACCOUNTS: <empty>

    ASTEMPDIR: C:\Program Files\Microsoft SQL Server\MSAS11.POWERPIVOT\OLAP\Temp

    BROWSERSVCSTARTUPTYPE: Automatic

    CLTCTLRNAME: <empty>

    CLTRESULTDIR: <empty>

    CLTSTARTUPTYPE: 0

    CLTSVCACCOUNT: <empty>

    CLTSVCPASSWORD: <empty>

    CLTWORKINGDIR: <empty>

    COMMFABRICENCRYPTION: 0

    COMMFABRICNETWORKLEVEL: 0

    COMMFABRICPORT: 0

    CONFIGURATIONFILE: D:\sqlfull_x64_enu\config.ini

    CTLRSTARTUPTYPE: 0

    CTLRSVCACCOUNT: <empty>

    CTLRSVCPASSWORD: <empty>

    CTLRUSERS: <empty>

    ENABLERANU: false

    ENU: true

    ERRORREPORTING: false

    FEATURES: AS, AS_SPI, BOL

    FILESTREAMLEVEL: 0

    FILESTREAMSHARENAME: <empty>

    FTSVCACCOUNT: <empty>

    FTSVCPASSWORD: <empty>

    HELP: false

    INDICATEPROGRESS: false

    INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\

    INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\

    INSTALLSQLDATADIR: <empty>

    INSTANCEDIR: C:\Program Files\Microsoft SQL Server\

    INSTANCEID: POWERPIVOT

    INSTANCENAME: POWERPIVOT

    ISSVCACCOUNT: NT AUTHORITY\Network Service

    ISSVCPASSWORD: <empty>

    ISSVCSTARTUPTYPE: Automatic

    MATRIXCMBRICKCOMMPORT: 0

    MATRIXCMSERVERNAME: <empty>

    MATRIXNAME: <empty>

    NPENABLED: 0

    PID: *****

    QUIET: true

    QUIETSIMPLE: false

    ROLE: SPI_AS_ExistingFarm

    RSINSTALLMODE: DefaultNativeMode

    RSSHPINSTALLMODE: DefaultSharePointMode

    RSSVCACCOUNT: <empty>

    RSSVCPASSWORD: <empty>

    RSSVCSTARTUPTYPE: Automatic

    SAPWD: <empty>

    SECURITYMODE: <empty>

    SQLBACKUPDIR: <empty>

    SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS

    SQLSVCACCOUNT: <empty>

    SQLSVCPASSWORD: <empty>

    SQLSVCSTARTUPTYPE: Automatic

    SQLSYSADMINACCOUNTS: <empty>

    SQLTEMPDBDIR: <empty>

    SQLTEMPDBLOGDIR: <empty>

    SQLUSERDBDIR: <empty>

    SQLUSERDBLOGDIR: <empty>

    SQMREPORTING: false

    TCPENABLED: 0

    UIMODE: Normal

    UpdateEnabled: true

    UpdateSource: MU

    X86: false

    Configuration file: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20121008_222646\ConfigurationFile.ini

    Detailed results:

    Feature: Analysis Services

    Status: Failed: see logs for details

    Reason for failure: Setup was canceled for the feature.

    Next Step: SQL Server Setup was canceled before completing the operation. Try the setup process again.

    Feature: Analysis Services SharePoint Integration

    Status: Failed: see logs for details

    Reason for failure: Setup was canceled for the feature.

    Next Step: SQL Server Setup was canceled before completing the operation. Try the setup process again.

    Feature: Documentation Components

    Status: Failed: see logs for details

    Reason for failure: Setup was canceled for the feature.

    Next Step: SQL Server Setup was canceled before completing the operation. Try the setup process again.

    Rules with failures:

    Global rules:

    Scenario specific rules:

    Rules report file: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20121008_222646\SystemConfigurationCheck_Report.htm

    Exception summary:

    The following is an exception stack listing the exceptions in outermost to innermost order

    Inner exceptions are being indented

    Exception type: Microsoft.SqlServer.Chainer.Infrastructure.InputSettingValidationException

    Message:

    The credentials you provided for the Analysis Services service are invalid. To continue, provide a valid account and password for the Analysis Services service.

    HResult : 0x84b40000

    FacilityCode : 1204 (4b4)

    ErrorCode : 0 (0000)

    Data:

    SQL.Setup.FailureCategory = InputSettingValidationFailure

    DisableWatson = true

    Stack:

    at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.LogAllValidationErrorsAndThrowFirstOne(ValidationState vs)

    at Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction.ExecuteAction(String actionId)

    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)

    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun, ServiceContainer context)

    Inner exception type: System.ApplicationException

    Message:

    The credentials you provided for the Analysis Services service are invalid. To continue, provide a valid account and password for the Analysis Services service.

    Tuesday, October 9, 2012 10:55 AM
  • Would you please check-out Alberto's and Xiao's answers in below thread

    http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/49354a50-7c48-4915-babe-2507a8a07c26


    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn


    Tuesday, October 9, 2012 11:06 AM
    Moderator
  • Hello,

    Make sure the account used to start SQL Server Analysis Services has “Log on as a service” permissions. This permission may be affected by group policies. For more information on permissions required, please see the following article:

    http://msdn.microsoft.com/en-us/library/ms143504(v=sql.110).aspx#Serv_Perm

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Tuesday, October 9, 2012 11:08 AM
    Moderator
  •  Hi Guys

    Thanks for reply

    I definitely have the domain account setup as 'logon as a service'.

    This same domain account is setup  as logon account for services such as  'sql server analysis services'

    This domain account has a strong password.

    I checked the password with a microsoft strong password test webpage they provide.

    I also made the domain account a member of : SQLServerMSASUser${MACHINE NAME}$MSSQLSERVER.

    The purpose of this group is :

    "Members in the group have the required access and privileges to be assigned as the logon account for the associated instance of SQL Server 2012 Analysis Services."

    Still doesn't work though

    Any other ideas?

    I was thinking is there any diagnostics  or tracing I can turn to get more information on what exactly the problem is?

    Do you think the event viewer will get me any info?

    Is there any config files I should update to get more  trace info?

    Wednesday, October 10, 2012 11:24 AM
  • Hi Guys

    One think to note about my installation.

    I'm using a VM server.

    I noticed some threads where people talk about having problems using VM servers.

    I'm wondering would this be related to the problem I'm getting?

    Anyone aware of issues related to VM server installations and how to work around them?

    Wednesday, October 10, 2012 1:58 PM
  • Is the VM machine part of the domain ?

    I mean the VM itself not the VM server ?

    If so can you leave the domain and re-join it again ?

    Also make sure you know the local machine Administrator user name and password


    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    Wednesday, October 10, 2012 2:39 PM
    Moderator
  • yes the VM machine is part of a domain.

    I'm setup as an admin user on the vm server

    When do I need to leave the domain and rejoin it?

    Wednesday, October 10, 2012 2:42 PM
  • Hi Guys

    One more thing to note is that I'm using a VM server.

    Reading through other threads I see this may cause  problems sometimes

    My vm server is a member of a domain.

    I have admin rights on this vm server

    Wednesday, October 10, 2012 3:30 PM
  • Hello,

    On the System Properties of Control Panel (Computer Name tab) you can join a a workgroup and then rejoin the domain.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Wednesday, October 10, 2012 3:35 PM
    Moderator
  • Hi Alberto

    YEs I tried that and I get into workgroup mode on the server.

    However I still get that same error message when I try to install powerpivot integrated with sharepoint.

    regards,

    Aidan

    • Proposed as answer by danielGuzman Monday, October 22, 2012 9:16 PM
    • Unproposed as answer by danielGuzman Monday, October 22, 2012 9:16 PM
    Wednesday, October 10, 2012 8:57 PM
  • Que tal Albero.<o:p></o:p>

    fájate que hoy me paso lo mismo, no aceptaba ninguna cuenta de dominio, pero lo solucione, no instalar con la cuenta de administrador local, inicia sesión con la cuenta de dominio misma que deberás colocar en analysis services y veras que instalas sin problemas. <o:p></o:p>

    saludos<o:p></o:p>

    Monday, October 22, 2012 9:23 PM
  • Hi Daniel 

    Thanks for reply.

    So you say you needed to logon as the domain user when setting up powerpivot?

    Am I correct?

    I presume this domain user was a member of the administrators group on the server?

    What I'm doing is logging on as the domain account and this same domain account is in the administrators group on the server.

    When you initially  did the installation what were you logged on as?

    Were you  just a local admin user?

    Regards,

    aidan

    Wednesday, October 24, 2012 10:36 PM
  • Please share the setup logs.


    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter

    Thursday, October 25, 2012 1:34 AM
    Moderator
  • No this issue is not resolved

    Summary of what I did so far to setup power pivot  and power view.

    Follow Microsoft Instructions

    I got microsoft install instructions at :

    http://msdn.microsoft.com/en-us/library/jj591528.aspx

    In these instructions I’m following scenario 1 which is documented in instructions.

    Scenario 1 is described as :

     Install the Power View and PowerPivot Infrastructure on New Single Windows Server 2008 R2 Computer that is a Domain Member

    I’ve got access to VM  server running which is a domain member

    Server is : VM-350B-EF54.nam.nsroot.net

    On this server I’ve installed the following in accordance with MS instructions.

    • Installed SQL server 2012 DB engine and analysis services
    • Installed Sharepoint 2010
    • Installed sharepoint 2010 sp1

    I was in the process of installing PowerPivot for sharepoint and I get to the step where I need to specify a domain account for SQL server analysis services for power pivot.

    My domain account is rejected . See below the error.

    The credentials you provided for analysis services service are invalid. To continue, provide a valid account and password for analysis services service.

    I've tried different domain member accounts but it makes no difference

    Any ideas?

    <//span>

    Thursday, October 25, 2012 1:19 PM
  • Daniel's solution works all right.

    What you have to do is set up a new domain account and make that a member of the domain admin group.

    Cancel the current installation and log back using the new domain admin account.  Once you get to the Server Configuration screen, type the new domain account inside the SQL Service Analysis Services account name field (password included).

    That will let you proceed to the next screen.  I pretty much changed all the accounts on the server configuration screen to be the same (not recommended by ms). Btw, I'm installing sql 2012 within a Hyper V server 2008 which is also a PDC (again not recommended by the MS gurus), overall the virtual server 2008 is quite responsive.

    Heck, I'm testing for fun and kicks, -Windows 8, Hyper V, rdp, Visual Studio 2012, SQL2012, and all the new ms goodies, pretty cool when out of all this "serious" stuff you can always relax and bottom left click to get the goofy metro screen.

    Thus far XP has proven to be a mediocre implementation in Hyper V and I'm still trying to force fit W95 and W98 but for some reason the cabs will not read as opposed to the smooth setup using virtual server within W7.

    Monday, December 3, 2012 10:15 PM