How To Create a SQL Database for Use with 20/20 DataShed

This tutorial uses the "Microsoft SQL Management Studio Express" for example screen shots and if you use your own favourite database management console this discussion may be helpful to you.

This tutorial assumes that you have already connected to the SQL Server.

Create the Database

1. Open "Microsoft SQL Management Studio Express" on your computer and connect to your SQLServer instance.

   

2. Right-click on the "Databases" node and select "New Database..." from the context menu.

   

3. In the "New Database" properties dialogue box, type a name for the new database and click "OK".

   

4. The new database will be created and you will see it in the list of databases. The database will be empty of course -- that's good. 20/20 DataShed will create the necessary tables and other database objects automatically when you connect and setup 20/20 DataShed for the first time.

   

Create the Login

Before 20/20 DataShed can connect to your new database, you must have a suitable user account with "db_owner" privelages in the new database. If you already have a user account which you use for this purposes, then you can ignore these instructions and just map your preferred user account to this new database and provide "db_owner" privelages to that user.

Otherwise, proceed through these instructions to create a new login for your new database.

1. Expand the "Security" node for the SQL instance. You will find this in the tree under the root node, not under the database node. (There is a "Security" node under the database, but that's not the one used in this tutorial.)

2. Right-click on the "Logins" node and select "New Login..." from the context menu.

   

3. When the "New Login" dialogue box opens, do the following:

   1. Type a new name for the user account.
   2. Select "SQL Server authentication" and type a new password to use with this account.
   3. UN-check the "Enforce password expiration" option.
   4. And select your new database as the "Default database".
   5. Then click "OK". The new login will be created.
   

4. The new login has been created, but now you must "map" this account to the new database that you've created. Right-click on the login name and select "Properties" from the context menu.

   

5. When the properties dialogue box opens, do the following:

   1. Select "User Mapping" page.
   2. Check the box beside your new database name. You should then see the page update and your new username will appear in the "User" column.
   3. With the new database still selected, check the box called "db_owner" in the bottom pane of the window.
   4. Click "OK".
   

The database is now created and there is a user account which 20/20 DataShed can use to connect to the database. That's all that needs to be done manually -- the necessary tables and other database objects will be created automatically by 20/20 DataShed.

Send Feedback