Connection

Installation

Installing and Configuring SQL Server 2005 Developer Edition

The Open Source Providers

 

Connection

Use the SQL Server Management Studio to connect to a SQL Server. Before you can connect, your database administrator must add your Windows account to the server as a login account. Do the following.

1. Click SQL Server Management Studio in the Microsoft SQL Server 2005 menu. The menu path is StartProgramsMicrosoft SQL Server 2005.
2. The Management Studio window is displayed with a Connect to Serverdialog in the foreground.
3. There are three spinboxes labeled Server type, Server name, and Authentication. The server type was set to Database Engine. The authentication was set to Windows Authentication. The server name had to be set to that of a known SQL Server 2005 server.
4. Click Connect. The result is that the components of the named server are displayed in the Object Explorer.