Export (0) Print
Expand All

Add/Modify Connection (Microsoft SQL Server)

The Add Connection dialog box for Microsoft SQL Server allows you specify settings, such as server name and passwords, for this connection. This dialog box is available in two ways: when Microsoft SQL Server is selected under Data Source in the Choose/Change Data Source dialog box or when <unspecified> is selected under Data Source in the Choose/Change Data Source dialog box and .NET Framework Data Provider for SQL Server is selected under Data provider. To use a different provider, click the Change button and select a different data source or provider in the Change Data Source dialog box.

NoteNote:

This topic also covers the New Database Reference dialog box.

NoteNote:

The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.

Data Source

Shows the data source and provider chosen in the Data Source dialog box.

Change button

Brings up the Change Data Source dialog box where you can change the data source or provider.

Server name

Shows the name of the server for this connection. To choose a different server, select one from the drop-down list or type the server name into the text box.

NoteNote:

Local SQL Server Express instances are not listed in the listing of available data sources.

Refresh button

Updates the list of servers to include any that became available since you opened or refreshed the drop-down list.

Use Windows authentication

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 SQL Server authentication

Sets the logon requirements so you must enter a user name and password to open the connection from Server Explorer.

User name

Provides a text box in which to enter a User ID. When you open this connection, the logon dialog box will require that you enter this User ID to access the database. The database administrator must first grant permission for you to access the database in order for the connection to succeed.

Password

Provides a text box in which to enter a password. When you open this connection, the logon dialog box will require that you enter this password to access the database. The database administrator must first grant permission for you to access the database in order for the connection to succeed.

Save my password

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

Select or enter a database name

Shows the name of the database to connect to. To choose a new database, select one from the drop-down list or type the database name into the text box.

Attach a database file

Shows the file name of the database to attach. For a new connection, type the database filename or click Browse to locate the database file.

Logical name

Shows the name for this database connection. This name does not need to match the name of the database file itself.

Advanced button

Displays the Advanced Properties dialog box, where you can specify or view settings for the connection. The content of this tab changes depending on which provider you selected in the Data Source dialog box.

Test connection button

Tests the connection without closing the dialog box so you can make adjustments to the settings if the connection does not succeed.

OK button

Commits the connection settings.

Community Additions

ADD
Show:
© 2014 Microsoft