1. For access please add the user's username to AD group
PRIV-G-eTracker-UNV
The AD group is used in the sql server database for authorization.
2. As part of zendesk ticket #215099, ODBC connections need to be setup for some staff to the eTracker SQL server database.
ORC or ORC delivery start by logging into the pc with an admin account.
Navigate to C:\Windows\SysWOW64 and open odbcad32.exe
(Q: can an end user right click on odbcad32.exe and use elevated rights? Then an admin account is not needed)
Click on System DSN
Click on Add.
Choose SQL server and Finish.
Name = eTracker TST (or PRD)
Server = mssql-tst-db01,13870 ( or mssql-prd-db01,13870 )
Click on Next.
Choose "With Windows NT authentication using the network login ID". Choose "Connect to SQL server to obtain default settings for the additional configuration options".
Click on Next.
Change the default database to "eTracker"
Click on Next.
Leave the options as they are.
Click on Finish.
Click on Test Datasource.
It should say "TESTS COMPLETED SUCCESSFULLY!"
Click OK at all the 3 windows.