We help IT Professionals succeed at work.

Problem connecting to SQL session with users outside the domain

269 Views
Last Modified: 2013-11-05
I Have a SQL server running on a 2 nodes Cluster with windows 2000 Advance Server, since a few days ago I have the problem that any user outside my domain can connect to this server, i'm using a home made aplication for the users tasks, but it is not the problem because even trying to connect with the SQL Administrator it is not possible. also i have the problem tha in the domain i can connect using the name of the server but not if i use the Server's IP. even if i am in the server it self.
Comment
Watch Question

the_b1ackfoxTechnophile

Commented:
Check your authentication.  If it is set to domain (or windows authentication) I suspect this is whats causing the issue...  I would set authentication to mixed mode authentication.

Author

Commented:
Hi, thanks for your replay, it's not an issue over the SQL server Authentication, i'm using sql and windows authentication, i think it's an issue over the DNS, but i have no clue what to check
the_b1ackfoxTechnophile

Commented:
try connecting to the SQL server with query analyser using it's IP address.  If if works, the the issue is DNS related.

Author

Commented:
I already tried that since the very begining, and no, I can not connect using Query analyser with IP (localy in the node or in any worksatation). In fact this system has 3 IP's and 3 names (physical, Cluster, SQL) ot that six "ways" to connect the only one that it's working it's by SQL name. Now I have done a lot of more troubleshuting, if I'm in the domain, i can connect by name of the SQL instance, if i'm not I can not connect any way, but checking with WireShark, on domain when i can not connect SMB responds NOT_OBJECT_FOUND ,  if i connect to one of ther server's shearings I can connect using name and IP  if I'm on domain, if iIm not even if I connect to the shearing ì cannot connect neither domain or IP and i get a respond from SMB of STATUS_LOGON_FAILURE, Because o this messages from SMB I Think I have a problem between my Cluster and my Domain Controller, but I can not find where or why. I already checked configuration on my AD, and not found problems.

Author

Commented:
i couldn't find the exact resolution to this problem, i had to reinstall the whole SQL server (i was lucky i had not to install the whole cluster) and it worked just fine again
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
the_b1ackfoxTechnophile

Commented:
no objections...  Asker has provided an acceptable technical solution which he arrived at without my help.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.