20. November 2015 00:37
by Admin
0 Comments
GDPro/GDMA applications use a specific SQL Server login for access as the login requires dbowner permissions to allow it to drop temporary report tables, for example.
We have made it easy to add the default SQL Server login using the Arise DB Tool. This tool can be freely distributed and used in a commercial environment.
The software is provided "as is" and the author disclaims all warranties with regard to this software including all implied warranties of merchantability and fitness. In no event shall the author be liable for any special, direct, indirect, or consequential damages or any damages whatsoever resulting from loss of use, data or profits, whether in an action of contract, negligence or other torturous action, arising out of or in connection with the use or performance of this software.
SQL Server Authentication Mode
Do the following in SQL Server Management Studio (this can be downloaded and installed from Microsoft)



Add GDMA Login using Arise DB Tool
Login to SQL Server

Click Users

Tick Yes in step 1

If an error message displays, it maybe due to the login already in SQL Server and needs redoing:
In SQL Server Management Studio, do the following:

And:

Once done, redo the steps to add the login using the Arise DB Tool.