Solved

Still can't connect remotely to MSSQL server

Posted on 2004-08-27
11
378 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 Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

 

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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

685 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