Solved

Still can't connect remotely to MSSQL server

Posted on 2004-08-27
11
344 Views
Last Modified: 2008-02-26
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
0
Comment
Question by:dean3740
  • 6
  • 5
11 Comments
 
LVL 34

Expert Comment

by:arbert
Comment Utility
Do you have any firewalls between you and the outside machines?  Is windows firewall running?  Can the other machines ping your MSDE machine?
0
 

Author Comment

by:dean3740
Comment Utility
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
 
LVL 34

Expert Comment

by:arbert
Comment Utility
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
 

Author Comment

by:dean3740
Comment Utility
Yes. By outside machines I mean over the Internet. Let me try the ping and I'll update you.
0
 

Author Comment

by:dean3740
Comment Utility
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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 34

Expert Comment

by:arbert
Comment Utility
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
 

Author Comment

by:dean3740
Comment Utility
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
 
LVL 34

Accepted Solution

by:
arbert earned 250 total points
Comment Utility
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
 

Author Comment

by:dean3740
Comment Utility
Hey Arbert

I'm still trying the solution, please give me a few and i'll keep you posted. Thanks.
0
 
LVL 34

Expert Comment

by:arbert
Comment Utility
No problem :)
0
 

Author Comment

by:dean3740
Comment Utility
Worked fine. Thanks.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now