-2

I am not the admin on my work machine. I had SQL Server 2012 installed and I cannot create or import a DB. Under security I tried granting my windows UN 'dbcreator' and do not have permission. I log into my local server using my machine name.

Chris
  • 103
  • 1

1 Answers1

1

Unfortunately, you're going to have to get the person who installed SQL Server to make you an admin.

In the past, SQL Server used to make all windows administrators SQL Server admins. This changed around SQL 2008. The person who installed SQL Server is an admin by default, however.

There are ways to grant yourself access to SQL Server if you've locked yourself out, but they require administrative privileges (to stop and start services).

Katherine Villyard
  • 18,510
  • 4
  • 36
  • 59