Common use of Add Microsoft SQL Server Database Account for WorldCard Team Clause in Contracts

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)‌

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)‌.