Database Reference
In-Depth Information
Figure 5-1.
Opening SQL Server Management Studio with adminstrator rights
Connecting to Servers
When SQL Server Management Studio first opens, you will be asked to connect to a SQL Server installation using
the Connect to Server dialog window. You can connect to several different types of servers including SQL Server's
database server, the Integration Services Server, the Analysis Cube Server and the Reporting Services Server. We
work with all of these servers and make the connections to them in future chapters, but for now, we are focusing
on the SQL Server database engine.
■
When you first open SQL Server Management Studio, the object Explorer window will not be populated
with servers as shown in Figure
5-2
until after these connections have been made.
Note
Figure 5-2.
Examples of the types of connections that can be made to the four BI servers
