cjrbus
asked on
MS SQL Server Access behind sonicwall
I can't access SQL Server from behind a sonicwall tz190. I've tried opening the appropriate ports. Anyone successful with this?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Does the computer making the call the the external SQL Server need DNS setting configured? This is really confusing because the person who set up this router put the computers in question on the DMZ.
OK...that makes a lot more sense. i was wondering if the DMZ was part of this. why is the computer part of the DMZ? i would think that if the DMZ host is accessing the database with the SA account, then you should only need to reference via IP. however, if using Domain credentials, I would think it would need to have access to a domain controller within the LAN. that type of connectivity would require DNS to resolve properly...that's my theory anyway.
Typically the servers in the DMZ would not be part of the domain because they are in the DMZ.
So I would think to connect via the IP address only instead of worrying about name resolution. Are you using a SQL Login or a Windows Login to get to the SQL Server from this machine in the DMZ?
So I would think to connect via the IP address only instead of worrying about name resolution. Are you using a SQL Login or a Windows Login to get to the SQL Server from this machine in the DMZ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
sure...glad it was an easy fix and thanks for the points!
ASKER