I went back to the list archives to explore this very issue, and found this message. Apparently, when connecting remotely to SQL Server using NT Authentication mode with Witango Studio (also, coincidentally with visual studio .net) the credentials sent are the local machine name, not the user logged into the local machine. Has anyone else observed this, or have an explanation? SQL server authentication uses clear text, which should be avoided for obvious reasons. Interestingly, when Access uses the logged in user to authenticate when it connects as a front end to SQL server. I have only a shallow knowledge of trusted relationships and windows networking, and this doesn't make much sense.

John


On Thursday, January 9, 2003, at 02:21 AM, Robert Garcia wrote:

You need to set the authentication to use SQL Server authentication, instead of NT Authority. Also make sure that you have set up a user in SQL Server, and your taf file is set to connect to the datasource as that user and password.

Robert.


<Picture 1.jpg>
On Thursday, January 9, 2003, at 02:00 AM, Jerome Keller wrote:

Hello,



I�m trying to configure a Tango server 5 on a computer with windows 2000 Pro (to test it as beta) and I try to connect by ODBC on another computer running SQL 2000 server on windows 2000 server.



I can connect & test it by �ODBC Data source Administrator�



<image.tiff>



But this is the message that I receive when tango server is trying to execute mae.taf. I try to find a solution is SQL server administration tool� Nothing.



Error

An error occurred while processing your request:

File: mae.taf
Position: Direct_DBMS
Class: DBMS
Main Error Number: 18456

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
28000
File: mae.taf
Position: Direct_DBMS
Class: Internal
Main Error Number: -4



Have u ever encountered these troubles� I mean Is it a way to configure SQL server to allow remote connection by ODBC?



Any suggests would be helpful,



Jerome.



*�� * ��*



=-=-=-=-=-=-=-=-=-=-=-=

�� M J�r�me Keller

������ Netway SA

� 216, Route d'ESCH

� L-1471 Luxembourg



��http://www.netway.lu



� Tel:��(+352) 48 91 91

� Fax: (+352) 48 91 90

-----------------------------------






--

Robert Garcia
BigHead Technology
2781 N Carlmont Pl
Simi Valley, CA 93065
Phone 805.522.8577
http://www.bighead.net/
http://www.theradmac.com/
[EMAIL PROTECTED]
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
               with unsubscribe witango-talk in the message body

Reply via email to