?
Solved

MS SQL 2005 how to use remote Management Studio?

Posted on 2010-08-26
6
Medium Priority
?
509 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
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.  

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

770 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