Solved

MS SQL 2005 how to use remote Management Studio?

Posted on 2010-08-26
6
493 Views
Last Modified: 2012-08-14
Hello Experts, I am trying to remotely access an MS SQL 2005 server using the management studio, but using the IP\instance only works locally in the server itself, not from a PC that is not in the network.
I tried opening ports 1433 and 1434 the place where the server is and I can see some hits in the port itself, but the management studio ends up saying that the server/instance could not be found.
I just installed SP3 for the SQL 2005 and still nothing, any ideas?
thank you.
0
Comment
Question by:darwin_roach
[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
  • 3
  • 2
6 Comments
 
LVL 4

Expert Comment

by:thepanch
ID: 33537371
i guess your server is only visible from the LAN and not from internet, if so, you have some ways to do it:

1- create a NAT over your Server
2- Do a VPN, there are software like hamachi that does it for you and free
3- go to dmz on the server
4- use software like no-ip on the server to do like a "NAT" and then using no-ip server as a bridge

i hope iit works
0
 

Author Comment

by:darwin_roach
ID: 33537442
to give you more information, it has a public IP with a Firewall blocking all ports but these two and a couple for remote access, so no NAT in the middle except the one I have on my side for the remote side (would that affect?).

The VPN is a solution but I'd like that to be the last resource to be honest.
0
 
LVL 4

Expert Comment

by:thepanch
ID: 33537699
can you ping the server from other location?
if so, then is firewall issue, then you'll have to open the ports, in the firewall Hardware, in the antivirus suite (if it has firewall) on windows OS, and other software that blocks your computer to the outside.
 
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!

 
LVL 26

Accepted Solution

by:
Chris Luttrell earned 500 total points
ID: 33537705
You said "I tried opening ports 1433 and 1434" but was that through the firewall?  Most security people wouldn't allow that for "security" reasons. :)
I guess you already checked that the SQL instance allows remote connections like the image shows.  If that is checked and you cannot open the ports through the firewall, your only option will be via VPN, that is how our company operates also.
Good luck,
Chris
SQL-2005-Remote-Connections1.png
0
 

Author Comment

by:darwin_roach
ID: 33537739
Thanks, yes, sorry, I do have the firewall but in transparent mode, meaning it is not doing NAT.
Regarding the allowing of the remote connections, yes, I did configure that.

I will perform a VPN then.

Thanks for the time.
0
 

Author Closing Comment

by:darwin_roach
ID: 33537756
It is not exactly what I wanted to do in the end, but it works.

Thanks
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSIS how to COMPARE a data column from different servers? 6 125
SQL Agent Timeout 5 69
sql query help 2 62
SQL Query with Sum and Detail rows 2 62
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

740 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