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.