Analysis Services deployment wizard gMSA

ITinNeed 1 Reputation point
2020-12-10T07:05:41.34+00:00

Hi,
im trying to run ASDW locally on a server. I full all the parameters and i test connection runs successfully.
Is it possible to use gMSA in "Impersonation information"? i choose "use speicific windows user name and password" and in the user name i write "mydomain\gMSA-account$" and leave the password empty. is this supported?

Internal error: The operation terminated unsuccessfully.
OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'V1Database', Name of 'V1Database'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Created Date', Name of 'ANM' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Created Date Year' attribute of the 'Reported' dimension from the 'Databasename' database was being processed.
Server: The current operation was cancelled because another operation in the transaction failed.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,263 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,821 Reputation points
    2020-12-11T02:24:42.117+00:00

    Hi,

    Normally it is suggested to avoid using gMSA\MSA on this scene, and try to use virtual service accounts unless you have special needs. One discussion about using gMSA with SQL server : MSA and gMSA and SQL Services You could evaluate if the gMSA in your environment is really necessary.

    What is the OS version and the SQL Server Version?

    To use gMSA we need to take care of lot of things, firstly make sure you gMSA setting with SQL Server is correct. You may follow this article : Using Group Managed Service Accounts with SQL Server

    There is one good thread that shares experience of this topic, it might be long but it should be helpful and recorded the step-by-step procedure , please see: Group Managed Service Accounts and SQL Server

    Regards,
    Lukas


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    What can I do if my transaction log is full?--- Hot issues November
    How to convert Profiler trace into a SQL Server table -- Hot issues November

    0 comments No comments

  2. ITinNeed 1 Reputation point
    2020-12-11T07:44:10.15+00:00

    Thank you for your answer.
    im not trying to run gMSA with SQL services but im looking for if Analysis Service in SQL 2016 support gMSA for "Imporsenate Information"?