Create New SQL Server Database Dialog Box

Use this dialog box to create a new SQL Server database on a server with the Microsoft SQL Server database management system. To access this dialog box, right-click the Connections node in Server Explorer and choose Create New SQL Server Database.

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.

  • Select or enter a 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.

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

  • 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 and password
    Sets the logon requirements so you must enter a user name and password to open the connection from Server Explorer.

  • User ID
    Provides a text box in which to enter a User ID. When you open this connection from Server Explorer, 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 from Server Explorer, 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.

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

See Also

Tasks

How to: Create a SQL Server Database in Server Explorer

How to: Connect to a Database from Server Explorer