Using Management Studio for SQL Server 2008

This page as PDF

back

Management Studio is an application interface that connects to SqlServer after it is installed, and provides a user view into the inner components of the database engine. It will install in the Operating system along with Sql Server itself and the other utilities you see here. It is located in the SqlServer Programs menu where it can be started by a user and where it will connect to an “instancename” of sql Server, in PI’s case either MSSQLEXPRESS or ILOOKPI08 or both. The following screen shows the menu location within the Microsoft SQL Server 2008 program group.

folder_view

When Management studio is started, for either the Express edition or Full, you should be able to connect to a database “instancename” if it is correctly installed. An instance name is similar to a username, in that it is a name created by the user or the system, so that the user can refer to the named instance of the dbengine.

By default, you will use ONLY the default name of Sql Server if you are installing the express edition. This name is SQLEXPRESS for the free version that you will install from the above screen. [When you install the complete Perlustro delivered version of Sql Server 32 or 64, you will give it a new name : ILOOKPI08 - BUT ONLY for the DVD version of SqlServer, you do NOT change the name of the Express Version during the install].

Below is a view of the Management Studio screen that you will see when you run the Management application from START Programs.

The Database name should have the Express name “$MSSQLEXPRESS” already in place. IF it does not, it may be because there is a pre existing version already installed.

connect

In the following view, seen by a user running Management Studio, you see the same Server name as in the preceding screen, but the Server name now appears on the left side of the main window after the CONNECT button has been clicked.

When the Database Engine has made a connection to the Instance name selected and installed [this may take 1 minute], it will fill in the left window pane as you see below. The name field above ILOOKPI08 would be $MSSQLEXPRESS using the Express Version installation in the pre-requisite installs.

valid_connection

Success of the SqlServer installation itself, can be measured by the Green Button above. If the connection is made and no other problems prevent the database engine from populating the object explorer, there should be no problems encountered in installation of ILookPI at this point.

At the conclusion of any SqlServer Session, but in particular in the first install, you can determine the current logging issues for the installation or running instance name by simple double clicking the current logs, AFTER you make a current connection through SQl Management Studio to the database engine – as noted in the following screen.

current_date

back