Microsoft SQL Server Management Studio Express

By KAmmend1221 ·
Please Help Me..This program is driving me insane, I installed this program due to the current class that I am taking, however, this program will not allow me to create a new database it keeps telling me that the Error Message 262 Create Database Denied in Database Master.... Considering that I am the only person who is using this software and no one else is why is this doing it and how can I get it to grant me the permission?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Whatever user you are logging

by Tony Hopkinson In reply to Microsoft SQL Server Mana ...

on as doesn't have the privilege.

Bit hard to say waht you should do with out knowing what options you chose on install.

But the default would be the user that installed it has sa privileges.

To give a create database priv to a user, you have to login as admin (the user it was installed as) and tick the option against the user you want to be able to do it.

Related Discussions

Related Forums