Monday, May 7, 2012

Why can't I create a database locally?

When facing this error...

CREATE DATABASE permission denied in database 'master'

 
 

...try right-clicking on the SQL Server Management Studio icon and then selecting "Run as administrator" to be able to create a user account for yourself that has the needed permissions. This should let you edit databases created as administrator.

No comments:

Post a Comment