After logging on to the database in windows, run the following command:
Exec sp_password null, 'sa ', 'sa'
Alter login SA enable
| you use Microsoft SQL Server 2008 to connect to a server running Microsoft SQL Server 2005. In the Properties dialog box, enter the SQL server administrator account, and run "sa" to log on to SQL Server Management studio. You have changed to "Sa logon attribute", and then click OK. in this case, you will receive the following error message: title: microsoft SQL Server Management studio
----------------------------
failed to change the logon 'sa. (Microsoft. sqlserver. SMO)
----------------------------
Other information: An exception occurs when a Transact-SQL statement or batch processing is executed. (Microsoft. sqlserver. connectioninfo)
------------------------------
creden。 cannot be set for the main SA. (Microsoft SQL Server, error: 15535)
---------------------------- cause if it is common, the logon properties-sa dialog box is not selected. This problem occurs when you map to the certificate check box. If selected, this check box does not indicate that SQL Server 2008 will try to delete any creden。 mapped to your login creden. Because your creden cannot be set to "sa" login, you will receive an exception error message when you click OK to close this dialog box, as mentioned in the "symptoms" section. solution
to solve this problem, make sure that you have selected the General Tab Of the logon properties-sa dialog box before changing the "sa" Logon attribute and clicking OK to close the dialog box, |
|
