If you use named instances of SQL Server on different computers for any of the Analysis Center databases, you need to ensure that each client of a database can connect to that named instance.
Use the SQL Server Client Network Utility to configure connectivity from each client computer to each named instance of SQL Server. For example, from the Data Warehouse SQL Server computer to the SQL Server instance for the Data Mart.
To configure connectivity:
On the client computer, click Start > Programs > Microsoft SQL Server > Client Network Utility.
On the General tab, enable TCP/IP and set it as the first protocol.
Select TCP/IP and click Enable.
Click the arrows to move TCP/IP to the top of the Enabled protocols by order list.
On the Alias tab, click Add to open the Add Network Library Configuration dialog box.
In the Server alias field, specify the SQL Server\Instance name to which the client will connect. The same name is displayed in the Server name field.
In the Network libraries panel, select TCP/IP.
In the Connection parameters panel, specify the Port number through which the connection to the SQL Server is made.
If you do not know the port number, select Dynamically determine port.
NOTE:It is preferable to specify the port number. The process of dynamically determining the port might cause security alerts in circumstances where there is monitoring for port attacks. In circumstances where the client and server are separated by a firewall, the system administrator will need to know which port to open.
Click OK to close the Add Network Library Configuration dialog box.
Click OK to close the Client Network Utility dialog box.