To install SamplingDB do the following:
1. If you have never installed SamplingDB, you follow the following steps:
a) Make sure that CLR extensions are enabled.
-- In a query window in SQL management studio select the desired database from the database dropdown and type the fhe following:
sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO
-- Then execute. You need to make sure that the account you use to login has sufficient privileges.
b) Making a database trustworthy.
alter database SamplingDBTest set trustworthy on
You may need to set the database to be owned by a not windows account for CLR objects to work. This is done by the following commands in a query window in SQL Server:
alter authorization on database::Sampling to sa
In the above replace Sampling by your sampling database name.
c) Installing SamplingDB by running the installer and following instructions.
If you have a license for the machine, now is the best time to install it using the "Upgrade Machine License" button above.
You can paste the license into the text area or load it from a file received from PrimeThought.
d) Now you can install SamplingDB into the database by clicking the "Install" button. This will install the license into the database as well.
e) Test that the install is successful.
A good way to test is by running the following command:
Select Sampling.getVersion()
You should get an output similar to the following:
f) Create the Sampling Tables.
This is done by clicking the Create Database Option.
This creates the following Tables:
1. MetadataTables
2. Settings
3. Sheets
4. SheetTypes
and the following view:
SheetDescriptors