Hey guys,
Since I'm new to SQL Server 2005, I was testing some Samples that came with it. Now, I'm having problems with the AMO Browser....
everytime I run it, it gives me the connection and the AMO Browser pop-ups but when I try to connect (Analysis Services Server: Data Source=localhost)
It gives me an error:
A connection cannot be made. Ensure that the server is running
Additional Information:
No connection could be made because the target machine actively refused it (System)
Show Technical details
All Messages:
===================================
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices)
Program Location:
at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId)
at Microsoft.AnalysisServices.Server.Connect(String connectionString)
at Microsoft.Samples.SqlServer.AmoBrowser.connectButton_Click(Object sender, EventArgs e)
===================================
No connection could be made because the target machine actively refused it (System)
Program Location:
at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port)
at Microsoft.AnalysisServices.XmlaClient.GetTcpClientByAddress(String hostName, Int32 port)
at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
* My server is running for all Services and Databases!
Could anyone please help me out on this one, I'm not sure if anyone have tried this already. Thanks in advance!
hi,i have the same question!|||First check whether the SQL SERVER ANALYSIS SERVICES 2005 WAS INSTALLED
IF installed and check whether it is running or not IN Background
No comments:
Post a Comment