Arise Software Ltd

Support and Help Docs

20. November 2015 00:37
by Admin
0 Comments

GDMA SQL Server Login

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.

Comments are closed