I am learning SQL Server 2005 Analysis Services. I am following the following webcast
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID=1032263433&CountryCode=US
When I try to deploy the project (F5) in Business Intelligence studio, I get the error message 'cannot connect to the server, check project properties under deployment'. I have checked those properties and made sure that the server name is correct and I have created a database on the server too.
I have tried installing SP2. But I still get the error message.
Any ideas what I need to do to fix this?
Thank you,
jsmith
Is the server installed on the same machine that you are using Visual Studio on? If not, how are you accessing the server?|||Yes it is installed on the same machine. I am using windows authentication to access it.
Thanks,
jsmith
|||Some additional info: I cannot connect to the Analysis Services through Management Studio, too. Following is the detail of the error message:
===================================
Cannot connect to TESTSERVER.
===================================
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)
Program Location:
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
===================================
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 (System)
Program Location:
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
at System.Net.Sockets.TcpClient.Connect(IPEndPoint remoteEP)
at System.Net.Sockets.TcpClient.Connect(IPAddress address, Int32 port)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClientByAddress(String hostName, Int32 port)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
Any ideas?
Thanks
jsmtih
|||Have you verified that the Analysis Server is up and running? Go to Services under Administrative tools and look for SQL Server Analysis Services (<name of your server>). It should be started.|||Yes Analysis services are running under services. I also cannot connect to reporting services.
I am able to connect to Database services and Integration services.
Thanks,
|||Are you running under the account that installed SSAS or as a local administrator. If not you might need to get a local machine admin to logon, start up SSMS and add you to the server's security group.|||Ok. There was a firewall on the computer which was blocking some ports and not allowing the connections to be made.
When a previous image was restored (before the firewall), everything started working fine.
Thank you so much everyone for trying to help
Regards,
jsmith.
No comments:
Post a Comment