database_design

APPNOTE: How to determine if you have SQL Server admin rights

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.