Solved

Still can't connect remotely to MSSQL server

Posted on 2004-08-27
11
365 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
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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

774 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