'Can I create and manage a schema or Database in SQL Server if I am not the Admin of the system?

I am not the Admin of the Laptop provided to me at work.

I want to build a small database of my own on my local machine. I have already installed SQL Server 2019 with the help of IT Admins. But SQL Server is not allowing me to create any table or schema.

sql-server


Solution 1:[1]

To create/manage database you must have the privileges "ALTER ANY DATABASE" at the login account level, or be a member of the "dbcreator" server role.

There is no need to be sysadmin.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 SQLpro

Related Questions