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