Link to home
Start Free TrialLog in
Avatar of Dracoryu
Dracoryu

asked on

Problem connecting to SQL session with users outside the domain

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.
Avatar of the_b1ackfox
the_b1ackfox
Flag of United States of America image

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.
Avatar of Dracoryu
Dracoryu

ASKER

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
try connecting to the SQL server with query analyser using it's IP address.  If if works, the the issue is DNS related.
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.
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
ASKER CERTIFIED SOLUTION
Avatar of Dracoryu
Dracoryu

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
no objections...  Asker has provided an acceptable technical solution which he arrived at without my help.