Setting the reports database

To use Automated Error Reporting or Feature Usage Reporting on more than one computer, the error reports must be saved on a central database. To do this: 

1. In the menu bar, click Options.
2. Scroll to Reports Database Options:
   
3. Select To allow sharing of reports, I want to store data in a SQL Server database
4. Click Choose...
   
   
5. Enter the name of your SQL Server.

   If you have multiple instances of SQL Server running on the same computer, append the SQL Server instance name to the computer name, in the format computername\instancename.

   All computers which will be used for downloading error reports must be able to access the computer hosting the SQL Server instance.

6. Click OK.
   

Setting the map file path

If your application is obfuscated, you must also be able to access the map file, which SmartAssembly uses to de-obfuscate error reports, from all of the computers.

To set the maps folder:

• If the chosen SQL Server instance has not been used by SmartAssembly before, you are asked to supply a network path where SmartAssembly can store map files.

  Note: SmartAssembly must have read and write access to this network path from all of the computers that you will use to download the error reports.
  

• If the chosen SQL Server instance has already been entered on another computer, the network path will be set automatically. To ensure that all computers share the same map file, it cannot be changed from within SmartAssembly. (To change the setting, see the instructions in About map files.)

Using SQL authentication

By default, SmartAssembly uses Windows authentication when connecting to the SQL server. To use SQL authentication instead, follow these steps:

1. Using an XML editor, open SmartAssembly.settings. By default, this file is located in %ProgramData%\Red Gate\SmartAssembly\ in Windows Vista and later, or %ProgramFiles%\Red Gate\SmartAssembly 6\ in older versions of Windows.
2. Find the <Database> node.
3. Check that the DatabaseEngine attribute is set to '1' (this means that SQL server will be used for error reports, rather than a .mdb file).
4. Set the value of the Server attribute to the computer name and SQL server instance in the format MyServer\SQLExpress.
5. Set the value of the MasterConnectionString attribute as follows. This will be used to create the error reports database.
Data Source=MyServer\SQLExpress; Initial Catalog=master; User Id=[YourUserName]; Password=[YourPassword]
6. Set the value of the ConnectionString attribute as follows. This will be used for subsequent connections to the database.
Data Source=MyServer\SQLExpress; Initial Catalog=smartassembly; User Id=[YourUserName]; Password=[YourPassword]

The resulting file should look like this:

<SmartAssembly.Settings> 
... 
  <Options> 
    <Database DatabaseEngine="1" Server="MyServer\SQLExpress" ConnectionString="Data Source=MyServer\SQLExpress; Initial Catalog=smartassembly; User Id=[YourUserName]; Password=[YourPassword]" MasterConnectionString="Data Source=MyServer\SQLExpress; Initial Catalog=master; User Id=[YourUserName]; Password=[YourPassword]"/> 
  </Options> 
...
</SmartAssembly.Settings>