How to Create a Network Based ID Card Project with ID Card Workshop and Microsoft SQL (MS SQL) Databases

Step-by-Step Guide

1. 1

   Step 1: Install MS SQL Database: You may install MS SQL Database with your own server or use a SaaS SQL service to storage your data.

   To install a MS SQL database on a server, you may visit this website to get more information about MS SQL: http://www.microsoft.com/sqlserver/ , and the express version of MS SQL is free, you may download it from this website: www.microsoft.com/express/sql
2. 2

   Step 2: Create Databases: To manage and create a MS SQL database

   , to create a new user enter the SSMSE, in Object Explorer, expand the folder in which you want to create the new user.
   
   Right click "Security"
   
   and select "New"
   
   and select "Login"
   
   enter the info requested, and in "Server Roles" page, you can assign different permissions to this new user.
   
   Click "OK" to complete the process. , Click on "Create New Project" button and select "Create a new project from an existing database source (Access, Excel, SQL etc.)" and click "Next" . and enter your project name. , i.e. if you would connect to a local MS SQL Express database, the address should be:127.0.01\SQLEXPRESS and if you would specify database name the connection format is {server address}\{Instance name};database={database name} i.e.
   127.0.01\SQLEXPRESS;database=membership ,,
3. 3

   Step 3: you will need "Microsoft SQL Server Management Studio Express" to create databases and setup users

4. 4

   Step 4: you can download and install this software from this website: http://www.microsoft.com/en-us/download/details.aspx?id=7593 After you installed the SSMSE (Microsoft SQL Server Management Studio Express)

5. 5

   Step 5: log in to your database server

6. 6

   Step 6: Setting up users and assign permissions: By using SSMSE

7. 7

   Step 7: you can easily create SQL server login.

8. 8

   Step 8: Connect ID Card Workshop to MS SQL database: Once you completed the configuration of database

9. 9

   Step 9: you may connect ID Card Workshop to this database.

10. 10

    Step 10: Select "SQL" and enter the address of the SQL server

11. 11

    Step 11: please note

12. 12

    Step 12: address should include the Instance name of database

13. 13

    Step 13: the format is {server address}\{Instance name}.

14. 14

    Step 14: After completed the configuration

15. 15

    Step 15: the software will guide you to create default design templates.

16. 16

    Step 16: Design your cards

17. 17

    Step 17: enroll new members and start print out your cards: Once you complete the project creation

18. 18

    Step 18: you can design your card by adding text

19. 19

    Step 19: QR codes and barcodes into the canvas.

Detailed Guide

About the Author