Add Database

 

To add a new Tracker database, start typing the bottom row of the grid on the Select Tracker Database screen as shown below.

 

Generate/AddDatabase.gif

 

You can press the tab key to move between columns. Here is the required information.

 

1. Whether this is the selected database. Check this box if you want to connect to this database right now.

 

2. Enter the Server Name or IP address of your SQL Server. This can be a domain name like (local) or JEFF-PC\SQL2008JEFF, an IP address, or a URL like tcp:sql2k###.discountasp.net. Note that the server must be accessible to the current machine in order for Tracker Reporter to work. If you have a program like Microsoft SQL Server Management Studio, you can connect there and use the same Server Name for Tracker Reporter. You can also check the connection string in the web.config file for your instance of Tracker.Net to get this as well as the Database Name, User Name, and Password.

 

3. Next, enter the name of the database. Again, you can look in web.config for this information. The default name is Tracker.

 

4. The next step is to enter an optional description. This can help you keep the databases straight if you have multiple databases.

 

5. Finally, click the Change button to edit the username and password of the database.