May 21, 2022 at 3:55 pm
Hi All,
We have Project server 2019 (Sharepoint).
The database server (Only Database services & SSIS) is installed on Server1 & Web server is Server2 (Web app & only SSAS Services). We are using SQL 2017 standard edition. SSAS is running as service account (NTService\MSSQLServerOLAPService)
When we try to build the cube using Sharepoint Central Administration it is failing with errors. Looks like it is not able to connect to the other SQL Server. Providing the error below. How do we know which account it is using to connect to SQL Server? TCP/IP port is enabled on the database server. I can't able to add the NTService\MSSQLServerOLAPService account on the DB server
===== Initiating OLAP database build process =====
Cube build request message has been added to the Project Server queue
===== Verifying and running pre-build server event handler =====
Verifying and running pre-build server event handler
===== Determining database and OLAP database structure =====
Cube build initialization started
===== Building database and cubes =====
Cube build session started
Analysis Services server failed to build OLAP database. Error: Error Adding DataSourceView 'Name' to database 'DBNAME'. Error: Error Adding Table '' to database. Error: Login timeout expired
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.
Named Pipes Provider: Could not open a connection to SQL Server [5].
===== Process Completed =====
Failed to build the OLAP cubes. Error: Error Adding DataSourceView 'Name' to database 'DBNAME'. Error: Error Adding Table '' to database. Error: Login timeout expired
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.
Named Pipes Provider: Could not open a connection to SQL Server [5].
It created the database in Analysis service but the datasource view is empty. So I right click on the datasourceview and check the connection, it is showing success.
Providing the datasource view connection strings below. It is using SQLnativeclient11 connection
Create xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<ParentObject>
<DatabaseID>DBNAME</DatabaseID>
</ParentObject>
<ObjectDefinition>
<DataSource xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300" xmlns:ddl400="http://schemas.microsoft.com/analysisservices/2012/engine/400" xmlns:ddl400_400="http://schemas.microsoft.com/analysisservices/2012/engine/400/400" xmlns:ddl500="http://schemas.microsoft.com/analysisservices/2013/engine/500" xmlns:ddl500_500="http://schemas.microsoft.com/analysisservices/2013/engine/500/500" xsi:type="RelationalDataSource">
<ID>Project Reporting data source</ID>
<Name>Project Reporting data source</Name>
<ConnectionString>Provider=SQLNCLI11;Data Source=DatbaseServcerName;Initial Catalog=;Integrated Security=SSPI;Persist Security Info=False</ConnectionString>
<ImpersonationInfo>
<ImpersonationMode>Default</ImpersonationMode>
</ImpersonationInfo>
<Timeout>PT0S</Timeout>
</DataSource>
</ObjectDefinition>
</Create>
May 22, 2022 at 4:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
May 23, 2022 at 12:05 pm
I am sorry. The post is too lengthy, I want rephrase my question simply
1) How can we add the service account (Networkservice\MSSqLOLAPservice) that run on machine 1 to sql server on machine 2. I tried to use the option create new windows login but the name is not verified.
2) Running sql profile will give only connected logins/failed or it will show us what all are accounts that are tried to connect as well. Because I am not seeing any login failures in sql error log.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply