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?
LVL 1
cjrbusAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

digitapCommented:
I'm not sure what ports you're opening or version of SQL.  Here is a link for the ports used by SQL 2000.

http://technet.microsoft.com/en-us/library/cc875824.aspx


How did you open the ports?  Did you use the public server wizard?  are you running the enhanced or standard version of the sonicwall?  login to the sonicwall and go to System > Status.  on the right, it should indicate which.

http://www.fuzeqna.com/sonicwallkb/consumer/kbdetail.asp?kbid=7027
digitapCommented:
cjrbusAuthor Commented:
This is SQL Server 2008... I will take a look at these tomorrow when I have access to the router.
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

DBAduck - Ben MillerPrincipal ConsultantCommented:
UDP 1434 and the Port number of the SQL Server.

Go into SQL Configuration Manager and look at the TCP protocol and double click into it.  Then open the IP Address and look down at the bottom for IPAll.

The port number is there.  If it is a default instance (accessing it by only MACHINENAME) then it is most likely 1433 TCP.  Otherwise, if it is a named instance (MACHINE\INSTANCE) then by default it uses dynamic ports, which means that it is good for today, but it could change when rebooted.

So the best bet if you are going to get to it through a firewall, you would want to specify a static port that would not change.  Then put that TCP port in the firewall to allow it.
cjrbusAuthor Commented:
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.
digitapCommented:
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.
DBAduck - Ben MillerPrincipal ConsultantCommented:
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?
cjrbusAuthor Commented:
Hey thanks for all your help... I think one of the things missing was the gateway wan't set of the computer making the sql call.  Pretty simple.  Its crazy this problem has been outstanding for like a month.

Thanks all,

Chris

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
digitapCommented:
sure...glad it was an easy fix and thanks for the points!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Routers

From novice to tech pro — start learning today.