Hi, all.

I am having some confusion with connecting to a SQL 2000 SP4 Server
across a one-way trust.

I have a SQL server in the trusting domain, and the Admin workstations
in the trusted domain.

I am not using domain-level authentication, I am only using SQL IDs.

If I log onto the workstation in the trusted domain with an ID in that
domain, and attempt to establish a connection to the server, it fails:

"A connection could not be established to %SERVERNAME%. Reason: SQL
Server does not exist or access denied. ConnectionOpen (Connect()).."

If I log onto the workstation using an ID in the trusting domain and
attempt the same thing, the connection works. Incidentally, my trusting
domain ID has Admin rights to the server.

I want to be able to connect to this box, but not be forced to use a
domain ID from the trusting domain.

Again, domain-level authentication was not how I configured the server;
I set it up for SQL Server IDs only.

Can anyone shed some wisdom on this one??

Thanks!!

BD

Craziness.

I went to my PC in the trusted domain, and mapped a drive to the server
in the trusting domain, using the trusting domain ID.

SQL Server authentication works now.

I'll have to think about this one... if anyone can explain this, I'd be
grateful.