TUniStoredProc problem

jrheisler · Post by **jrheisler** » Sun 27 Nov 2011 20:04

I am using TUniStoredProc to access stored procedures in SQL Server. The problem I have is that when I go to use TUniStoredProc I am prompted to login to my sql server database. I can not log in using the TUniConnectDialog which TUniStoredProc uses because I am using SQL Server with windows authorization.

How do I get past this problem?

jrheisler · Post by **jrheisler** » Mon 28 Nov 2011 13:39

There is an error when you do this. I am attaching a screen shot. The error is:

Login failed for user 'sa'.

[/img]

AndreyZ · Post by **AndreyZ** » Tue 29 Nov 2011 08:52

To solve the problem, you should set the Authentication specific option to auWindows. Here is an example:

Code: Select all

UniConnection.SpecificOptions.Values['Authentication'] := 'auWindows';