Unable to save template after making changes.
Error message when attempting to hit save:
Template [Document] failed to save in DR
Clarity.10026 Template [Document] failed to save.
System.Data.SqlClient.SqlException A network-related or instance-
specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the
instance name is correct and that SQL Server is configured to allow
remote connections. (provider: Named Pipes Provider, error: 40 - Could
not open a connection to SQL Server)
The cause for this issue is that the cube's relational connection source is pointing to a relational database on a separate server environment.
Diagnosing the problem
Reconfirm all connection/detail to ensure that both the relational database and olap cube connection strings are from the same server.
- Open up Analysis Services
- Select the database that is being used and expand
- Select Data Sources, and further expand.
- Select the datasource and right click and select properties.
- Examine the Connection String information to see if the relational database used is on the same server as Analysis Services.
Resolving the problem
In this case, the issue lies in the connection string for the cube. Analysis Services was on one server and the corresponding relational database was on another. The customer forgot to repoint the database after moving the database from a production environment.
Edit the connection string to use the same server as the Analysis Service and this should correct the problem.
If the databases are required to be on separate servers, please refer to technote # 1583743