1. Ensure the authentication of SQL Server
(1) Right click the SQL Server and select "Properties"
(2) Under page "Security", click "SQL Server and Windows Authentication mode" and then click button "OK"
2. Create a read-only account
(2) Under page "General", type login name, password for SQL authentication and default database
(3) Under page "User Mapping", click the designated database and set db_datareader in its role membership
(4) Click button "OK"
No comments:
Post a Comment