Still can't connect remotely to MSSQL server

Hello Everyone

I'm really having a frustrasting issue with trying to connect to a MSDE 2000 server remotely because I thought I had it but i don't. I've tested my connection through UDL and the test is successful, but outside machines say they cannot connect to my database. I went into the SQL Server Network Utility and enabled TCP\IP still nothing. On the local machine that houses the server, if I change the computer name to the ip address in UDL the connection works, but still outside computers cannot connect to the server. What am I not doing correctly? Anyone please help!

Dean
dean3740Asked:
Who is Participating?
 
arbertConnect With a Mentor Commented:
This is kind of a backwards approach--you usually secure the application first....But, whatever.


Here is the article on how to enable it--you should be able to disable accordingly:

http://support.microsoft.com/?kbid=317530
0
 
arbertCommented:
Do you have any firewalls between you and the outside machines?  Is windows firewall running?  Can the other machines ping your MSDE machine?
0
 
dean3740Author Commented:
I don't think I have a firewall on the machine that houses the actual server. I'm really not sure. How would I check for that? How would I ping?
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
arbertCommented:
Is the machine Xp or 2003?  If so, there is the built in windows firewall--it's in your network connection properties....

By outside machines, do you mean over the internet?  

Ping, you should be able to go to a DOS prompt and type

PING yourmsdemachinenamehere

and also try

PING yourmsdemachineipaddresshere
0
 
dean3740Author Commented:
Yes. By outside machines I mean over the Internet. Let me try the ping and I'll update you.
0
 
dean3740Author Commented:
OK. I can definitely ping my msdemachineipaddress by this:

C:\>PING mywebserver.com

It works fine. OK the OS of the machine is 2003. So i'm guessing its a firewall issue. So how exactly would i configure my machine to allow access over the INternet? Also would this be considered safe? What are pros and cons? Thanks
0
 
arbertCommented:
No, it's not safe by any means.  If you value your data, you DON'T put SQL Server directly on the internet.  Use a VPN (Windows 2003 supports PPTP VPN out of the box) or Remote Desktop...
0
 
dean3740Author Commented:
OK, thanks for the tip.  Well at the moment I would just like to see the database get accessed from the Internet. Once I see that that at least works, then I'll go ahead and focus on making it secure. I went into network connections but wasn't sure what needed to be altered for the database to be accessed across the Internet.
0
 
dean3740Author Commented:
Hey Arbert

I'm still trying the solution, please give me a few and i'll keep you posted. Thanks.
0
 
arbertCommented:
No problem :)
0
 
dean3740Author Commented:
Worked fine. Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.