The following will tell you if you have sufficient privilege to create a new database.
The procedure will be to create a temporary database, then drop it, leaving the SQL Server instance unchanged.
Step 1 – Start SQL Server 2008 R2 Management Studio
Typically this is located in :
Start > Program Files > Microsoft SQL Server 2008 R2
You will be asked to connect to an Instance of SQL Server:
Use Windows Authentication. Your DRN account will provide your authorization.
Step 2 – Attempt to Create a Temporary Database
Click the right mouse on the Databases node, and select “New Database…”
Call the database JUNK:
Press the OK button.
If no errors occur, then you have sufficient privilege.
Step 3 – Cleanup
The database JUNK will appear at the bottom of the list of databases.
Locate it and right mouse – select Delete
Click the OK button to delete (also referred to as “drop”) the JUNK database.