SQLSERVER 2008 229 and 18456 errors

SQLSERVER 2008 229

The SELECT permission on the object 'extended _ properties' (database 'mssqlsystemresource', schema 'sys') is denied. (Microsoft SQL Server, error: 229)

Solution:

Remove the check box of db_denydatareader from the corresponding user permissions in the database. Db_denydatareader is a denial of access.

SQLSERVER 2008 18456 error

1. Enter the database manager in windows authentication mode.

 

Step 2: Right-click sa and select attributes:

 

On the General tab, enter the password again and confirm the password (change to a memorable one ). Remove the password policy.

 

Step 3: click the Status tab, and select grant and enable. Then confirm

 

Step 4: Right-click the instance name (that is, the section of the red line of the image below) and select Properties.

 

 

Step 5: Click Security. Check that the SQL SERVER and Windows Authentication modes are selected.

 

 

Step 6: Restart the SQLSERVER service (important ).