Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MS SQL 2005 how to use remote Management Studio?

Posted on 2010-08-26
6
Medium Priority
?
515 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 27

Accepted Solution

by:
Chris Luttrell earned 2000 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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
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…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

636 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