When using the Development Toolkit you may receive the following error message if the necessary SQL Server ports are not open on the servers being used:
Complete text from error message:
Error in Command:
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
To resolve the issue, ensure that the ports that are being used for the Development Deployment Toolkit are open on the server(s). You can determine the ports that need to be opened by looking at the local ports used during the configuration of the Development Deployment Toolkit.
This screenshot shows the local port used during the configuration on the production server.
In this example Port 10001 needs to be opened on the production server.
This screenshot represents the port that needs to be opened on the development server.
In this example Port 10002 needs to be opened on the development server.
For more information on opening a port in Windows Firewall see Open the Analysis Services Port in Windows Firewall .