Databases Reference
In-Depth Information
Using SQL Server Management Studio
SQL Server Management Studio (SSMS) is ground zero for administering the
Analysis Servers resident on your network; not only that, you can also adminis-
ter instances of SQL Server, Reporting Services, Integration Services and SQL
Server Mobile from SSMS. In this topic you learn administering and managing
Analysis Servers, and this chapter specifically discusses the Analysis Services
object as shown in the Object Explorer. Administering Analysis Services is dis-
cussed in detail in
Chapter 11
.
The first step in the process of adding objects to the Object Explorer calls for
connecting to the services you wish to manage. In fact, as soon as you start
Management Studio, you get a dialog to connect to one of the services as
shown in
Figure 2-39
. Create a connection to the Analysis Services through
your login.
Figure 2-39
SSMS provides you a way to register your servers so that you do not have to
specify the login credentials each time need to connect to a server. Click on
View menu item and select Register Servers. You will now see a window called
Registered Servers in SSMS as shown in
Figure 2-40
. In the Registered Serv-
ers pane, click the toolbar icon second from left; this enables you to register an
Analysis Services instance instead of SQL Server. Now, right-click Microsoft
Analysis Servers and select New
Server Registration. In the resulting New
Search WWH ::
Custom Search