Authentication Problem

Thread View: microsoft.public.sqlserver

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Jon Hunt Fri, 21 Mar 2003 15:14

Author: 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

Re: Authentication Problem

Author: bb_43
Date: Sun, 23 Mar 2003 22:44

18 lines
1846 bytes

In article <Xns93459B03C6090softworks@195.129.110.133>, Jon Hunt <jhunt@NOSPAM-softworks-computing.com> wrote:
>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?
>
>

You can't use Windows Authentication with TCP unless the application is local 
to the SQL Server.

The problem is by design. See MS KnowledgeBase for IIS and SQL Server

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads