Professional Microsoft® SQL Server® Analysis Services 2008 with MDX

7.1. Administration Using SQL Server 2008 Tools

Let's just jump in and get our feet wet, shall we? In Chapter 2 you used SSMS to view the objects found in an Analysis Services 2008 database. We'll start here on a similar footing:

1. Launch SSMS from All Programs Microsoft SQL Server 2008 SQL Server Management Studio.

2. Using Object Explorer, connect to the Analysis Services instance.

3. Open the Databases folder.

You will see a tree view of those databases you have saved on the server to date, as shown in Figure 7-1. One of those databases should be titled AnalysisServices2008Tutorial — you should take a moment to review the tree nodes and what they contain because you will be learning the administrative tasks associated with those objects.

Figure 7.1. Figure 7-1

7.1.1. Managing Analysis Servers

SSMS, the integrated management environment for SQL Server 2008 products, provides you the flexibility of managing several Analysis Services instances. In this chapter we use the word "server" to denote an instance of Analysis Services, and "servers" to denote one or more. If you have a set of production servers that are being used by customers and a set of test servers that are being used for development ...