SQL Server 2008 Notes

SQL Server 2008 opens the remote Access database

1. Enter the database Manager in Windows Authentication mode.

Step Two: Right-click the SA and select Properties:

In the General tab, re-fill in the Password and confirm the password (changed to a good note). Remove the mandatory password policy.

Step three: Click on the Status tab: Tick Grant and enable. And then determine

Fourth step: Right-click the instance name (which is the part that draws the red line) and select Properties.

Fifth step: Point security, confirm that SQL SERVER and Windows Authentication mode are selected.

Sixth step: Restart the SQL Server service (important).

SQL Server 2008 Service cannot start

Turn off the Via service to start the SQL Server service

SQL Server 2008 Remote automatic backup

Start the SQL Server Agent service, maintenance plan, new maintenance plan through the Maintenance Plan Wizard, in the job where you can view the status of the maintenance plan execution

Program accessing database prompting user permissions error

Change the database property owner to a remote local user group for the database to be properly accessed