HOW Do I GET DATA ANALYZER TO CONNECT TO MY SSAS 2005 DB's EXTERNALLY?

okay,

I have the SSAS 2005 cubes migrated. I have loaded MS Data Analyzer (the client ad-hoc quesry tool of choice for the CXX's and SSAS 2005) and can connect with no problem LOCALLY on the DA- installed on local machine. I have no lucky externally. I keep getting the error: Cannot connect to the "MYDBSERVER". The server is either not started ot too busy. HELP!!

kj

There coupld be multiple things going on.

1. You are missing new AS 9 OLEDB provider. Download and install Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider from http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

2. Your firewall might be blocking AS TCP port. Open port 2383 for default instance of AS.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

How do I find Database Designer in 2005 Managment Studio?

I cannot find how to open the Visual Database Designer (or Visual Table Designer) in the Management Studio loaded with SQL Server 2005 Professional.

I right-click on the Database Diagrams icon but all it gives me is "Working with SQL Server 2000 diagrams" and "Refresh". Similarly no Visual Table Designer option.

Regards,

Nick Samuel

I believe that functionality was moved to BIDS or VSTS and is NOT in SSMS.|||Arnie, thank you for the suggestion but I cannot fand it in BIDS/VSTS either.|||

Go to server | database | Tables. Right click on tables node -> New Table. This will launch table designer for you.

-Sravanthi

|||

Sravanthi, thank you for your help but I cannot find the options you list on either tool. I can choose to display the Database Design toolbar but it is, of course, grayed out. What am I missing?

Regards,

Nick

|||Are you using SQL Server Management studio only? Make sure you open Object Explorer ( View Menu -> Object Explorer) or press F8. Then in the tree view that comes up in Object Explorer navigate using the steps i mentioned above. If you have already done this, then please post a screen shot or something so that we can see what the issue you are facing exactly.|||

Hi Sravanthi,

I have have used Object Explorer. I cannot see how to post a screen shot on this forum.

Regards,

Nick Samuel

|||

Database Designer is in Visual Studio, and the 'premium' version is in 'Visual Studio for Database Professionals'.

There is NOT a 'database designer' in SSMS.