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
Applies only to Microsoft SQL Server databases.
Note
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.
To create a new Microsoft SQL Server database
Right-click the Data Connections node and choose Create New SQL Server Database.
The Create New SQL Server Database dialog box appears.
Enter the server name where the database will be located.
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.
Enter the name of the new database.
Click OK.
The new Microsoft SQL Server database appears in Server Explorer.
Note
You must have adequate Microsoft SQL Server permissions to create a new database on the target server.