Unable to connect to Analysis Services as a client

Unable to connect to Analysis Services as a client

• Mehmet Can

  In the BI project properties (right click on project node -> Properties), in the Deployment tab there are the 'Server' and 'Database' settings. Those are for the AS2005.

  The connection string for the DataSource is for the relational SQL Server.

  Adrian Dumitrascu.

  
  

• betrl8thanever

  This error suggests that you don't have permissions with the user connecting from the client machine.

  On the client machine, run the SQL Management Studio under a user that is administrator on the server machine (we don't need it to be a full admin on the server machine, only AS2005 admin, but we'll try this as a test).

  If the connection succeeds, right click on the AS2005 server item, use 'Properties', go to the 'Security' tab and add your initial user (for which the connection failed) as an AS2005 administrator. Then you should be able to connect fine. You can also lower the rights for the user, to make it just database(s) administrator, instead of full server administrator.

  Adrian Dumitrascu.

  
  

• rothth

  Hi:

  How I can conecting to analysis services from BI Studio with sql authtentication

  
  

• ahamilton

  Well Adrian I got my OS changed to WIN 2000 Server SP4 and now I can connect clients using either SQL Management Studio and BI studio.

  I've tried with XP to connect clients using the AS2005 admin logon, with no results. The machines are on the same domain.

  Now it is working fine with WIN 2000 Server SP4. I don't unserstand, normally it should also work under an XP OS!

  Thanks a lot Adrian

  
  
  

• CRISTIANO333

  No, Windows XP Professional is supported. (I use it all the time to connect to AS2005) The problem is caused by something else. The AS2005 server machine and the client machine are both on the same domain What I suggested on the previous messages didn't work (with logging in on the client machine with an user who is AS2005 admin)

  Can you connect to the AS2005 machine from any other machine Can you connect to it locally When connecting, please try SQL Management Studio and either one of MDX Sample App if you have it (from AS2000), Excell or the data link dialog (.udl file)

  Adrian Dumitrascu

  
  

• shainer0531

  Hi Adrian,
  
  These are my settings :
  
  In the project properties in the deloyment tab :
  server : server_name\instance_name
  database : database_name
  
  Datasource connection string : SQL Native Client
  connection test : OK
  
  After building my cube, I get the following error while deploying it :
  the project could not be deployed on the server "server_name\instance_name" due to the following connectivity problems : A connection cannot be made. Ensure that the server is running...
  
  It seems that I can't connect to AS2005 on the server as a client. I'm trying to connect as administrator.
  
  I've check all services and tcp/ip connections and the firewall is off on the server and I still can't solve the problem. Any ideas
  
  
  

• awake

  Thanks Adrian for your answer.

  Where in the BI project should I specify to refer to Analysis Services and not to the SQL relational server

  In the project properties and in the deployment section I have the right server : "server_name\instance_name". Should we specify to point to analysis services in the datasource (in the connection string)

  Thanks

  
  
  

• phradecky

  Hi,

  You mentioned that the server is started because you created the datasource using the sqlclient provider. The datasource will point to the relational SQL Server (out of which the AS2005 cubes and dimensions will be processed), while your BI project needs to be deployed to the Analysis Services server. "server_name\instance_name" needs to refer to the AS2005 server ("SQL Server Analysis Services" service), not to the relational SQL Server.

  I hope this helps,

  Adrian Dumitrascu.

  
  

• dunlapja

  Adrian,

  I found out that on the server, I cannot log on to analysis services using SQL Management Studio as administrator. The authentification, user and password are greyed. I can only log on using the windows authentification mode and with my windows user name.

  When I browse for network servers, still with SQL Management Studio, I have only the database engine as net work server on both server and client.

  When I browse for local servers on the server, all the servers are present :

  • database engine
  • analysis services
  • reporting services
  • integration services

  In the SQL Server Configuration Manager, all services are configured as "Network Service".

  How to make available the other 3 services on the network (SSAS, SSRS, SSIS).

  The server's firewall is set off for tests.

  Thanks Adrian.

  
  
  

• dane_msft

  1. If the AS2005 server is on the same machine where you are opening SQL Management Studio, then login (to Windows) with an Windows local administrator account. Then open SQL Management Studio and connect to AS2005. Integrated authentication is done, so you will have AS2005 admin rights. Then right click on the AS2005 item, use 'Properties' and go to the 'Security' tab. Add your normal user name as an AS2005 admin. Later you can lower this permission to make your user just a database admin, but for the moment we'll go with the full server admin to see if this will work. Then logout from Windows and loging with your user. You should be able to connect now to AS2005. Please note that you can also run SQL Management Studio under a different user (to skip the Windows loging-logout parts).

  2. If the AS2005 server is on machine A and SQL Management Studio is on different machine B, then you need to loging on machine B under an account who is admin on machine A (or run SQL Management Studio under that account).

  Adrian Dumitrascu.

  
  

• Rajeev Tiwari

  Hi Adrian,

  I think the problem is with win XP and SQL SERVER 2005 Enterprise Edition. It seems that we cannot connect clients to a SQL SERVER having win XP as OS. We need a server OS (win2000 server SP4 or win 2003 server)

  Do you confirm that

  Thanks

  
  
  

• Cezary

  Basic authentication (with user name and password) is only supported for http connections (where the user name and password are passed to IIS for verification and impersonation).

  For native connections (native connections = the regular ones, non-http, non-local cubes) only integrated authentication works. That's why the user name and password are greyed out in the connect dialog from SQL Management Studio.

  Adrian Dumitrascu.

  
  

• tom ferguson

  I've tried to connect to Analysis Services on the server using SQL Server Management Studio as a client, I have the following errors :

  A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

  Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)

  An existing connection was forcibly closed by the remote host (System)

  The SQL Server 2005 is installed on the local network and is running on an XP SP2 32bits PC, and the client is a windows 2000 SP4 PC.

  I wonder if the server should not be a Windows 2003 for appropriate server/client applications

  
  
  

• Aneesh

  Well Adrian I got my OS changed to WIN 2000 Server SP4 and now I can connect clients using either SQL Management Studio or BI studio.

  I've tried with XP to connect clients using the AS2005 admin logon, with no results. The machines are on the same domain.

  Now it's working fine with WIN 2000 Server SP4. I don't unserstand, normally it should also work under an XP OS!

  Thanks a lot for your help Adrian

  
  
  
• Unable to connect to Analysis Services as a client