SQL Server Instructions

  1. Open Microsoft SQL Server Management Studio
  2. Right-click on the server (root item) in the Object Explorer
  3. Select Properties
  4. Select the Security page (at left)
  5. Set Server authentication to SQL Server and Windows Authentication mode
  6. Click on OK
  7. Right-click on Databases in the Object Explorer
  8. Select New Database…
  9. Enter "clinic" for Database name
  10. Click on OK
  11. Open the Databases folder in the Object Explorer
  12. Select the clinic database
  13. Click on File -> Open -> File (Ctrl+O)
  14. Select the clinic.sql file from this folder
  15. Click on Execute (F5)
  16. Open the clinic database folder in the Object Explorer
  17. Open the Security folder of the clinic database in the Object Explorer
  18. Right-click the Users folder
  19. Select New User…
  20. Ensure User type is SQL user with login
  21. Enter "clinic" for User name
  22. Enter "clinic" for Login name
  23. Enter "dbo" for Default schema
  24. Click on OK
  25. Close the Databases folder in the Object Explorer
  26. Open the Security folder in the Object Explorer
  27. Right-click the Logins folder
  28. Select New Login…
  29. Enter "clinic" for Login name
  30. Select SQL Server Authentication
  31. Choose and confirm a password
  32. Uncheck Enforce password policy
  33. Click on the Server Roles page (at left)
  34. Check sysadmin
  35. Click on the User Mapping page (at left)
  36. Check the Map checkbox for the clinic database
  37. Check the db_owner checkbox under Database role membership for: clinic
  38. Click on OK
  39. Open the clinicSQLServer.cfg file in this folder
  40. Replace the orange text in the following line with the password chosen in step 33:

    connectionString = "Server=HAL\SQLEXPRESS;Initial Catalog=clinic;User Id=clinic;Password=password"

  41. Move the clinicSQLServer.cfg file from this folder to the dbiScript\data folder
  42. In the dbiScript\apps\clinic\clinic.js file change the following line

    app.dbiScriptProperties.dataConfig = "../data/clinic.cfg"

    to

    app.dbiScriptProperties.dataConfig = "../data/clinicSQLServer.cfg"

  43. Navigate to http://localhost/dbiScript/apps/clinic/