Solved

Still can't connect remotely to MSSQL server

Posted on 2004-08-27
11
387 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 34

Expert Comment

by:arbert
ID: 11916873
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
ID: 11917272
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
ID: 11917611
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

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

Author Comment

by:dean3740
ID: 11917841
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
 
LVL 34

Expert Comment

by:arbert
ID: 11918181
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
ID: 11918263
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
ID: 11918380
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
ID: 11929903
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
ID: 11931504
No problem :)
0
 

Author Comment

by:dean3740
ID: 11935661
Worked fine. Thanks.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

623 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