Create New Database SQL Server 

Create New Database SQL Server

Create New Database SQL Server 2008R2

The first thing you need to do is open SQL Server Management Studio

SQL Server 2008 Management Studio splash screen

from here login with the necessary credentials

(may require TCP/IP to be enabled on the server if accessed remotely)

Connect to Server dialog for SHAREPOINT-DEV\SQLEXPRESS2008 with Windows Authentication

in this case the “SHAREPOINT-DEV” is the server hostname

SQLEXPRES2008 is the name of the Database Server (confusing but go with it, whatever your environment is)

hit connect once your credentials are entered correctly

Object Explorer connected to SHAREPOINT-DEV\SQLEXPRESS2008 listing existing databases

once logged in, expand databases, you should be able to see all the databases on the database server.

Right Click on “Databases” and hit “Create New Database”

Right-click on Databases with New Database highlighted

Give it a name, and specify any options as necessary

New Database dialog with database name MyUberCoolDatabase and its data and log files

Hit “OK”

There’s our New Database!

Object Explorer showing the new MyUberCoolDatabase under Databases

That’s it! You have created a new Database!

 

If you are looking for SQL Database Hosting visit www.zwiegnet.com/go to get started today!

Related guides: Install SQL Management Studio 2008R2 | Find Database Names Microsoft SQL Server

Leave a Reply

Your email address will not be published. Required fields are marked *