Donate

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...

Comments

Post a Comment

Donate

Popular Posts From This Blog

WPF CRUD Application Using DataGrid, MVVM Pattern, Entity Framework, And C#.NET

How To Insert Or Add Emojis In Microsoft Teams Status Message

Bootstrap Modal In ASP.NET MVC With CRUD Operations