Create New Database SQL Server
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!
Related guides: Install SQL Management Studio 2008R2 | Find Database Names Microsoft SQL Server
