Page 1 of 1

TUniStoredProc problem

Posted: Sun 27 Nov 2011 20:04
by jrheisler
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?

Posted: Mon 28 Nov 2011 13:39
by jrheisler
There is an error when you do this. I am attaching a screen shot. The error is:

Login failed for user 'sa'.

Image[/img]

Posted: Tue 29 Nov 2011 08:52
by AndreyZ
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';