Create New Database SQL Server 2008R2

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

from here login with the necessary credentials

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

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

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”

Give it a name, and specify any options as necessary

Hit “OK”

There’s our New Database!

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!