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.

CodePudding user response：

Ask the IT Admins to login to SQL Management Studio with the system Admin account using Windows authentication and create you a user within SQL Server with the right privileges. : https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-database-user?view=sql-server-ver15 I think they can assign database admin rights to your normal non-admin user.

CodePudding user response：

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.