CODEWITHSUNDEEP
sql-server
homerun
homerun

Reputation: 131

SQL Server 2008 won't let me enable the 'sa' user

I normally use the sa user for development, but SQL Server isn't letting me enable the account. It says:

Cannot set a credential for principal user 'sa'

When installing it I set it up with mixed mode.

Upvotes: 0

Views: 3402

Answers (3)

onupdatecascade
onupdatecascade

Reputation: 3366

Instead of SA, grant your own windows account the appropriate perms in SQL Server. Leave mixed mode off if possible, or if you must have mixed mode, disable the SA account itself.

Upvotes: 1

Joel Coehoorn
Joel Coehoorn

Reputation: 416039

Don't use the sa account ever, even for development work. Not only is it dangerous from a security standpoint, it can also lead to bugs popping up at deployment when you suddenly don't have permissions for something.

Upvotes: 4

Otávio Décio
Otávio Décio

Reputation: 74290

This may be of help. But I agree with Coehoorn's statement - DON'T USE SA.

Upvotes: 4

Related Questions