Solved

MS SQL 2005 how to use remote Management Studio?

Posted on 2010-08-26
6
480 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
  • 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
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…

810 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