Posted by BD on 11/15/05 23:52

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

• Next in forum: Re: QUESTION: Connecting with SQL Admin across domains
• Prev in forum: SQL-Server DBA-Full Time, Permanent, National Institutes of Health
• Thread view: QUESTION: Connecting with SQL Admin across domains

[Reply to this message]