How to: Create a SQL Server Database in Server Explorer

You can create a new Microsoft SQL Server database using Server Explorer. A new database in Server Explorer will contain folders for objects such as database tables, views, stored procedures, and functions. You can then develop the database structure by using Visual Database Tools.

Note Note

Applies only to Microsoft SQL Server databases.

NoteNote

In Visual Studio 2013, you can connect to a SQL Server database from either SQL Server Object Explorer or the Data Connections node in Server Explorer. SQL Server Object Explorer provides a view that is like SQL Server Management Studio. To open this explorer from the menu bar, choose View, SQL Server Object Explorer. For more information, see Connected Database Development.

NoteNote

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 Customizing Development Settings in Visual Studio.

To create a new Microsoft SQL Server database

  1. Right-click the Data Connections node and choose Create New SQL Server Database.

    The Create New SQL Server Database dialog box appears.

  2. Enter the server name where the database will be located.

  3. Select either Use Windows NT Integrated Security or Use a specific user ID and password.

    For more information on SQL Server database access authentication, see Create New SQL Server Database Dialog Box.

  4. Enter the name of the new database.

  5. Click OK.

The new Microsoft SQL Server database appears in Server Explorer.

Note Note

You must have adequate Microsoft SQL Server permissions to create a new database on the target server.

Community Additions

Show: