## Running DataImporter as a Windows Service

If you chose to run DataImporter as a Windows Service, you need to follow these steps to have it access the local SQL Express database.

1. When defining your database connection, in the Database Connection Properties dialog box, select either Choose a local database instance or Attach database filename. For more information on database connection, see "Connecting to a Database".

Database Connection Properties dialog box

2. Using the Microsoft SQL Server Management Studio Express tool, in the Object Explorer, expand .SQLEXPRESS, then Security, and then Logins. Assign the target database to the NT Authority\System user login, and click Properties to open Login Properties dialog box.

SQL Server Management Studio Express

3. From the left pane, under Select a page, click Status. Under Settings, under Permission to connect to database engine, click Grant. Under Login, click Enabled.

Login Properties - Status screen

4. From the left pane, under Select a page, click User Mapping. From the Users mapped to this login area, from the list, click DEMO. From the Database role membership area, from the list, select db_owner.

Login Properties - User Mapping screen

5. After finishing the above steps, click OK. In the Object Explorer, right-click on SQLEXPRESS, and click Restart.