Server authentication
Posted: Tue 10 May 2005 14:48
Hello,
I am using SDAC 3.00.2.9 sith Delphi 6+ SP2. On an XP machine. SQL Server 7.0 on a remote machine.
My problem is :- When i intend to use windows authentication, everything is fine, no problem.. But if i switch "Authentication" to "auServer", my project continues with the Windows authentication. On debug, if i make MSConnection.Connected := true; then a login prompt appears :- the server authentication starts... But in runtime, no login prompt appears (LoginPrompt parameter is True - the server and database name are entered.)
And, When i click the connect button in runtime, the program connects using Windows Auth.
Even i have written a very small debuggine application, the result did not change.
So, what do you recommend? what i am doing wrong?
Thanks.
I am using SDAC 3.00.2.9 sith Delphi 6+ SP2. On an XP machine. SQL Server 7.0 on a remote machine.
My problem is :- When i intend to use windows authentication, everything is fine, no problem.. But if i switch "Authentication" to "auServer", my project continues with the Windows authentication. On debug, if i make MSConnection.Connected := true; then a login prompt appears :- the server authentication starts... But in runtime, no login prompt appears (LoginPrompt parameter is True - the server and database name are entered.)
And, When i click the connect button in runtime, the program connects using Windows Auth.
Even i have written a very small debuggine application, the result did not change.
So, what do you recommend? what i am doing wrong?
Thanks.