INFORMATICS

The Best

Off the SA account - red arrow

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

Off the sa account - red arrow

After installing a new instance of the server MSSQL may prove that the sa account is disabled.

Turn the database administrator account - SA with the command:

Launching 'sa' account - ALTER LOGIN sa ENABLE

Exclusion of 'sa' account - ALTER LOGIN sa DISABLE

How to do this: Go to the Query window -> press Command -> proceed Query.

Administrative account for the security is disabled by default since version of MS SQL 2005 Server and Express version.

Off the administrative account, as has the red arrow with the inscription SA.

Search