Connect to SQL Server Dialog Box

SQL Query Analyzer Help

SQL Query Analyzer Help

Connect to SQL Server Dialog Box

Use the Connect to SQL Server dialog box to connect to a Microsoft® SQL Server™ database.

Options

SQL Server

Specify the name of an instance of SQL Server to which you want to connect. In Microsoft Windows NT®, you must have the required system permissions and rights to start SQL Server either locally or remotely. On computers running the Microsoft Windows® 95 or Windows 98 operating system, every user can start SQL Server locally. The operating system prevents SQL Server from being started remotely.

Start SQL Server if it is stopped

Start an instance of SQL Server if it is stopped.

(...)

Display the list of active SQL Server database servers on the network. This list only displays instances of SQL Server on Windows NT. This functionality is not available on computers running the Microsoft Windows 95 or Windows 98 operating system.

Connect using:

Specify the type of authentication to use when connecting to the database server.

Windows NT authentication Specify that SQL Server will use the Windows NT user information to validate the user. This option is only available when connecting to an instance of SQL Server on Windows NT. The client needs to be part of a Windows NT domain or workgroup. The user needs to be validated as a Windows NT user before access is granted.
SQL Server authentication Specify the use of  standard SQL Server security validation. This is the default and only available option for an instance of SQL Server on the Windows 95 or Windows 98 operating system. It is optional for an instance of SQL Server on Windows NT. The login must be added to the SQL Server before a user can log in.
Login name Specify a login recognized in SQL Server.
Password Specify the password for the login name.