Board index » delphi » Trusted connection to SQL server?

Trusted connection to SQL server?

How can I use a trusted connection with NT authentication to SQLserver using
the native driver, leaving username and password empty. I have no problem
using ODBC but I cant get it working with the native driver.

Thanks,
Jos

 

Re:Trusted connection to SQL server?


Make sure in BDE Config there is no Default Username like MyName or something
like this for MS SQL Driver.
If you don't supply one in the concrete alias, BDE looks up this default name.
Try with a blank Username in MS SQL Driver Config.

HTH
Bernd

--
Bernd Ua - Software-Haus Brumund GmbH
u...@nospambrumund.de
// to reply, remove nospam from email adress :-)
// obviously this needs to be stated, too :  please no unsolicited private email
unless explicitly invited

Re:Trusted connection to SQL server?


Username and password has to be a space

Quote
Spaendonck AA wrote in message <7grsq8$c...@forums.borland.com>...
>How can I use a trusted connection with NT authentication to SQLserver
using
>the native driver, leaving username and password empty. I have no problem
>using ODBC but I cant get it working with the native driver.

>Thanks,
>Jos

Re:Trusted connection to SQL server?


Thanks for your reply but..

In the SQL Server Client Configuration Utility I set Default Network to
Named Pipes. Starting ISQL/w using a Trusted Connection without username and
password works fine. Now I created an alias, using BDE Administrator, to the
same server I tried in ISQL/w. I left USER NAME empty. In the Native MS SQL
driver under the configuration tab I have also made USER NAME empty.  When I
try to activate the alias and I leave Username and Password in the Database
login dialog empty I get the error: Unknown user name or password. Login
failed.
Did I overlook something, or should this work?

Thanks
Jos

Other Threads