Add Microsoft SQL Server Database Account for WorldCard Team Clause Samples

Add Microsoft SQL Server Database Account for WorldCard Team. If you are using Microsoft SQL Server, please open [SQL Server Management Stu- dio] first and log in to access the database with Administrator or sa with the highest per- missions. Then right click on the database server and select [Properties]. On the left side of the [Security] page, make sure you have set the server authentication as [SQL Server and Windows authentication mode]; if not, please make changes and right click on the database server and choose [Restart] to restart the database server. Next, we need to add a Microsoft SQL Server account for WorldCard Team to use, please expand the server folder, and right click on [Security] folder, then click [New \ Login]. Select [SQL Server authentication] in the [General] page, and enter the account / password you want to use (here we take “pptest” as example); Please note that the [Enforce password policy] option below must be checked out. Then click on the [Server Roles] on the left, and check [dbcreator] for this account, the others is not recommended to check to avoid security problems, and then click [OK] to complete. After creating the new account, it is recommended to close the SQL Server Manage- ment Studio and re-open it again, and select [SQL Server Authentication] in the [Authen- tication] field of login windows, then use the account / password you just created to log in to make sure the new account can be logged in correctly. Chapter 2 Database Settings (MSSQL or Postgre)‌