smartassembly required sql server database

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

To set the maps folder: If the chosen SQL Server instance has not been used by SmartAssembly before, you will need to supply a network path where SmartAssembly can store map files.

You can type the map folder path in a text box in Database Options section on click Choose.

Changing the map folder location will have an immediate effect on all computers connected to the chosen database.

Make sure the path is accessible and dont change it accidentally.

SmartAssembly must have read and write access to the network path where map files are stored from all of the computers that you will use to download the error reports.

Using SQL authentication By default, SmartAssembly uses Windows authentication when connecting to the SQL Server.

To use SQL authentication instead, follow these steps: Using an XML editor, open ProgramDataRed GateSmartAssembly 8SmartAssembly.settings.

Find the node. Check that the DatabaseEngine attribute is set to 1 (this means that SQL Server will be used for error reports, rather than SQLite file).

Set the value of the Server attribute to the computer name and SQL server instance in the format MyServerSQLExpress.

Set the value of the DbCreatorConnectionString attribute as follows.

Data SourceMyServerSQLExpress; Initial Catalogmaster; User IdYourUserName; PasswordYourPassword Set the value of the ConnectionString attribute as follows.

This will be used for subsequent connections to the database.

Data SourceMyServerSQLExpress; Initial CatalogSmartAssembly; User IdYourUserName; PasswordYourPassword If you ommit the DbCreatorConnectionString attribute, SmartAssembly will use the ConnectionString attribute to create the database, and for any subsequent connections.

If you ommit both DbCreatorConnectionString and ConnectionString attributes, SmartAssembly will use a default connection string: Server0;Integrated securitySSPI;databaseSmartAssembly; (where 0 is the value of the Server attribute).

Smartassembly Required Sql Server Database