SQL Database / User Creation

Enable SQL Authentication

Note: This guide is applicable to SQL Server 2014 Express Edition. Please follow Microsoft documentation for other SQL Server versions.

Create New Database

1. Open Microsoft SQL Server 2014|SQL Server Management Studio Express.

2. Right click on Databases

3. Click on New Database
   

   

   
   

4. In the Database Name column, type “CPG” 

5. Click OK to complete the DB creation
   

   

   
   

Create New Login Account

1. On the left sidebar, click on the Security folder, right-click Logins, and select New Login
   

   

   
   

2. On the Login window, enter the name ccuser.

3. Then select SQL Server authentication and enter a Password and Confirm password. 

4. Uncheck Enforce Password Policy
   

   

   
   

5. Click on the User Mapping option appearing in the side menu.

6. Under the database section, check the database “ccadmin”.

7. Under the database role section, select db_owner role.

8. Click OK.

You are good to go with the database. Continue with the next steps listed under the deployment-guide for the product installation.

If SQL Login is used for the first time on SQL Server instance, an error 18456 occurs very often because Windows Authentication (only) is set in Server properties (security section).

To Access Server Properties, Open SQL Server Management Studio, and go to the Object Explorer pane (use view if you can’t see it). Use the Connect button to connect to the database engine for your server. Once connected, you will see it in the object explorer. Right-click Server and click Properties. This will open Server Properties.

See the below screenshot that might be causing SQL login to fail

Set Server Authentication to SQL Server and Windows Authentication mode

Invalid userID: SQL Server is not able to find the specified UserID on the server you are trying to get. The most common cause is that this userID hasn’t been granted access on the server but this could be also a simple typo or you accidentally are trying to connect to different server (Typical if you use more than one server)

Invalid password: Wrong password or just a typo. Remember that this username can have different passwords on different servers.

less common errors: The userID might be disabled on the server. Windows login was provided for SQL Authentication (change to Windows Authentication. If you use SSMS you might have to run as different user to use this option). Password might have expired and probably several other reasons…. If you know of any other ones let me know.