<div>
btw, i'm using SQL Authentication.
</div>


<div>
Hi Bogdan,<br />
<br />
Thanx very much!!! It works.<br />
<br />
I appreciate the help!<br />
<br />
Regards,<br />
Johan Swart
</div>


Hi Bogdan,

Thanx very much!!! It works.

I appreciate the help!

Regards,
Johan Swart

<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
PLEASE HELP!<br />
<br />
I am currently developing an app that connects to a SQL Server 2000 database. I would very much like to make use of the SQL Server Application Role functionality, but I cannot seem to get it working. I have tried using a ADOStoredProc, ADOQuery, ADOCommand and even the ADOConnection directly to execute the stored procedure to activate using the Application Role.<br />
<br />
What I could understand from all the documentation is that I must switch the current open connection from the user login password (in my case using Windows Authentication) by using a stored procedure called master.dbo.sp_SetAppRole with parameters @rolename and @password.<br />
<br />
I have successfully tested this in SQL Query Analyzer, but cannot get this working from within Delphi.<br />
<br />
Regards,<br />
Johan Swart<br />

</div>
</div>


Hi all,

PLEASE HELP!

I am currently developing an app that connects to a SQL Server 2000 database. I would very much like to make use of the SQL Server Application Role functionality, but I cannot seem to get it working. I have tried using a ADOStoredProc, ADOQuery, ADOCommand and even the ADOConnection directly to execute the stored procedure to activate using the Application Role.

What I could understand from all the documentation is that I must switch the current open connection from the user login password (in my case using Windows Authentication) by using a stored procedure called master.dbo.sp_SetAppRole with parameters @rolename and @password.

I have successfully tested this in SQL Query Analyzer, but cannot get this working from within Delphi.

Regards,
Johan Swart


SQL Server Application Role Activation from within Delphi

Delphi is the most powerful Object Pascal IDE and component library for cross-platform Native App Development with flexible Cloud services and broad IoT connectivity. It provides powerful VCL controls for Windows 10 and enables FMX development for Windows, Mac and Mobile. Delphi is your choice for ultrafast Enterprise Strong Development™. Look for increased memory for large projects, extended multi-monitor support, improved Object Inspector and much more. Delphi is 5x faster for development and deployment across multiple desktop, mobile, cloud and database platforms including 32-bit and 64-bit Windows 10.