Skip to content Skip to sidebar Skip to footer

Sql Server 2008 Enable Sa Account

I logged into SQL Server 2008 via SQL Server Management Studio using Windows admin account. When I run the command (ALTER LOGIN sa ENABLE) I get the following error. Cannot alter

Solution 1:

You account doesn't have permissions. It isn't sysadmin.

CREATE DATABASE requires

Requires CREATE DATABASE, CREATE ANY DATABASE, or ALTER ANY DATABASE permission.

This is (legacy SQL Server 2000 lingo):

  • sysadmin
  • dbcreator

If the account is "end user" consider wrapping the call in a stored procedure to hide the permissiosn escalation

Edit, after question update

sa is always sa; you can't disable it as such

You need to grant some permissions to the Windows account using GRANT

Solution 2:

Post a Comment for "Sql Server 2008 Enable Sa Account"