By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,466 Members | 1,172 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,466 IT Pros & Developers. It's quick & easy.

QUESTION: Connecting with SQL Admin across domains

P: n/a
BD
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

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.