Connecting to SQL Server with the Management Studio

The MS SQL Server 2005 SQL Server Management Studio application will be used to create and implement your database maintenance plans for full and incremental (transaction log) backups. Instructions for logging in to SQL Server 2005 with the Management Studio are provided below.

  1. Open the SQL Server Management Studio for MS SQL Server 2005. By default, the SQL Server Management Studio is available in the Microsoft SQL Server 2005 program group in the Start:Programs menu.
    A screenshot showing how the MS SQL Server Management Studio is opened from the Windows Start menu.
  2. The Connect to Server window will open.
    A screenshot showing the MS SQL Server 2005 Connect to Server window.
  3. Select “Database Engine” in the Server Type field.
  4. Select the server on which MS SQL Server 2005 is installed in the Server name field.
  5. Select “SQL Server Authentication” in the Authentication field.
  6. Type the “sa” user (without quotes) and password in the Login and Password fields.
  7. Click Connect when finished. The SQL Server Management Studio will connect and log in to the SQL Server specified.
    Screenshot showing MS SQL Server Management Studio connected to a SQL Server.
    At this point you have connected to the MS SQL Server with the Management Studio. You can continue with implementing the database maintenance plans by following the procedures described in the rest of this chapter.
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.