What is sa login in SQL Server?

Question

The sa Login. The sa login, short for system administrator, is one of the riskiest server-level principals in SQL Server. It's automatically added as a member of the sysadmin fixed server role and, as such, has all permissions on that instance and can perform any activity. 26 мар. 2019 г.

What is the sa account used for?

The SA account is used only for the management of SQL Server; it is not a CAREWare login. If the SA password is lost, the CAREWare Help Desk strongly suggests that all attempts to recover the password are exhausted before attempting to detach and reattach the database as outlined in the System Administrator's Manual.

How do I find my sa password for SQL Server?

Open SQL Server configuration manager and select the service of SQL Server instance. Right-click and click on the Properties option. After adding the startup parameter, click on the Apply button and then the OK button in the warning message window. Restart the SQL Server service to start SQL Server in single user mode.

Should I disable sa account in SQL Server?

Due to its administrative nature, any compromise of the sa account could have catastrophic consequences, including the complete loss of control over SQL Server. It is therefore widely considered good security practice to disable the sa account altogether.

More Information1Start SQL Server. ... 2Expand server_name, and then expand Security. ... 3Right-click Logins, and then click New Login.4Enter a user name for SQL Server. ... 5Enter a password. ... 6Select the Microsoft Forecaster database. ... 7Grant access to the Microsoft Forecaster database. ... 8Click OK.

Expert · Answer