|31040 and 31041 - Connection to server failed. Errors occurred while connecting to server name. Server message Do you still want to register this server? MICROSOFT|
A connection to a server can fail for various reasons. The following reasons are common: The user does not have the permissions required to access a server or a database. The repository is located on a remote computer, and the computer name cannot be resolved. The repository has been migrated to a SQL Server database, but the client is missing the necessary SQL Server connectivity components. A client does not have the permissions required to access the instance of SQL Server containing the database. Analysis Manager (or another application using DSO) is attempting to connect to an Analysis server with a later service pack than the Analysis Services service pack on the local host server. Network problems prevent the connection. These messages can also appear when the SQL Server Client Network Utility on the computer running Analysis Manager is configured to use TCP/IP as the default protocol, or if TCP/IP is used for the connection to the instance of SQL Server containing the Analysis Services repository. The error messages then indicate that Analysis Manager cannot make trusted connections with SQL Server using TCP/IP.
Examine the server message text embedded in the m ... Login to see more
SQL Server Analysis Services (SSAS)