Authentication Problem

Article View: microsoft.public.sqlserver

Article #1

Back to microsoft.public.sqlserver Previous Next

From: Jon Hunt
Date: Fri, 21 Mar 2003 15:14

15 lines
1689 bytes

We have developed an application in Borland Delphi (using BDE) that has 
been accessing MSSQL v7 and 2000 databases using SQL authentication and we 
have never had any problems. However, we have now been asked to use Windows 
authentication only. If we remove the Username from the BDE and use Named 
Pipes to connect all works well, however if we use TCP to connect we get a 
message..."Username ('null') is not a trusted SQL connection" or similar. 
According to the MS documentation, the username should be ignored if the 
server is configured to use Windows authentication only.

Can anyone shed some light on this?


-- 
---------------------------
Jon Hunt

Technical Details

Message-ID: <Xns93459B03C6090softworks@195.129.110.133>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-01!sn-xit-08!supernews.com!easynet-quince!easynet.net!newsfeed.kabelfoon.nl!195.129.110.21.MISMATCH!bnewsfeed00.bru.ops.eu.uu.net!bnewsifeed00.bru.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10034a,c3c8a8998e741c3c,start
X-Google-Attributes: gid10034a,public
X-Google-Thread: 107d2f,c3c8a8998e741c3c,start
X-Google-Attributes: gid107d2f,public
X-Google-ArrivalTime: 2003-03-21 07:14:31 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-01!sn-xit-08!supernews.com!easynet-quince!easynet.net!newsfeed.kabelfoon.nl!195.129.110.21.MISMATCH!bnewsfeed00.bru.ops.eu.uu.net!bnewsifeed00.bru.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail
Newsgroups: microsoft.public.sqlserver,borland.public.bde
Subject: Authentication Problem
From: Jon Hunt <jhunt@NOSPAM-softworks-computing.com>
Organization: Softworks Computing Ltd
Message-ID: <Xns93459B03C6090softworks@195.129.110.133>
User-Agent: Xnews/5.04.25
Date: 21 Mar 2003 15:14:19 GMT
Lines: 15
NNTP-Posting-Host: host70.softworks-computing.com
X-Trace: 1048259659 reading.news.pipex.net 4843 62.17.135.70
X-Complaints-To: abuse@uk.uu.net