Sunday, September 9, 2012

CREATE DATABASE permission denied in database ‘master’.

I successfully installed MSSQL Server 2008 in my working pc. But when I tried creating a database
I encountered an error

CREATE DATABASE permission denied in database ‘master’. 


I recalled my username has no privilege as domain administrator. So, the solution was to 
1. login on my  working pc as domain administrator
2. change server authentication to mixed mode
3. change password of sa.
4. reconnect using sa account

That's it...

2 comments: