Edit Article

Edited by Idcardworkshop, Maluniu, Teresa

Host your membership or visitor data with a network-based SQL database has many benefits, specially you would like to access member data in different locations.

Ad

EditSteps

  1. 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
    Ad
  2. 2
    Create Databases: To manage and create a MS SQL database, you will need "Microsoft SQL Server Management Studio Express" to create databases and setup users, 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), log in to your database server,
  3. 3
    Setting up users and assign permissions: By using SSMSE, you can easily create SQL server login. 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.
  4. 4
    Connect ID Card Workshop to MS SQL database: Once you completed the configuration of database, you may connect ID Card Workshop to this database. 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.
  5. 5
    Select "SQL" and enter the address of the SQL server, please note, address should include the Instance name of database, the format is {server address}\{Instance 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
  6. 6
    After completed the configuration, the software will guide you to create default design templates.
  7. 7
    Design your cards, enroll new members and start print out your cards: Once you complete the project creation, you can design your card by adding text, logos, QR codes and barcodes into the canvas.
    Ad
Add your own method
Save

Article Info

Categories: MySQL

Recent edits by: Maluniu, Idcardworkshop

Ad

Thanks to all authors for creating a page that has been read 715 times.

Was this article accurate?

YesNo

Become
an Author!

Write an Article