Connect to SQL server from none domain machine

[ccaprio]

I have an SQL 2000 server and an NT server with an application that needs to connect to the sql server.

The NT server is logged in locally to the machine, therefore not part of the domain. However, the machine has an account on the domain. The SQL Server is setup for mixed mode.

The problem. I cannot get the application to login to the SQL server with the SQLDMO Connect command. It says server not available or access denied.

WHen I look at the security logs I get

Logon Failure:
Reason: Unknown user name or bad password
User Name: Administrator
Domain: IHQCTI02
Logon Type: 3
Logon Process: NtLmSsp
Authentication Package: NTLM
Workstation Name: \\IHQCTI02

The NT Server is sending IHQCTI02\Administrator user name(Current username logged in on NT server).

Even though I am using osql -S IHQAVOTUS -U timesync from command prompt and SQLDMO.Server.Connect IHQAVOTUS,timesync,timesync in the program.

Any thoughts

 

[SQLBill]

For any readers of this post....ccaprio has two other threads on this subject:

THREAD183-738721
THREAD183-738224

Each thread has different/additional information about this issue.

-SQLBill