SQL Server Logon Dialog Box

Use this dialog box to log in to a SQL Server database. This dialog box appears when specific access permission is required for the current database process.

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Visual Studio Settings.

  • Server
    This field indicates the server name where the database is located.

  • Database
    Shows the name of the data source.

  • Use Windows NT Integrated Security
    Allows a network user to access the database for this connection without supplying a separate user ID or password because these are obtained from the Windows NT network security process.

  • Use a specific user ID an password
    Select this to enable the User ID and Password options.

  • User ID
    Provides a text box in which to enter a User ID.

  • Password
    Provides a text box in which to enter a password.

  • Save my password
    Saves and encrypts your password so that you do not need to enter a password each time you open the connection.

See Also

Tasks

How to: Connect to a Database from Server Explorer

Reference

Add/Modify Connection (Microsoft SQL Server)