Link to home
Start Free TrialLog in
Avatar of Markr71
Markr71Flag for United Kingdom of Great Britain and Northern Ireland

asked on

Can I connect to SQL server over the internet?

At the moment I am having to remote into SQL server to run queries.  How do I connect to SQL server from my machine so that I can use Query Analyser and Enterprise Manager locally?

The databases are held on external SQL 2005 servers and I want to set my machine up to connect to these DBs.

Is this possible?
Avatar of chapmandew
chapmandew
Flag of United States of America image

I would purchase some VPN software if I were you.  It will be the most secure way to do it.  You really don't want to make your sql server that public so you can connect to it over the internet.

http://www.cisco.com/en/US/products/sw/secursw/ps2308/

Avatar of Markr71

ASKER

So there is no secure way for me to use SQL tools on my machine to query a DB on our SQL Server?
Is the SQL Server over the internet?
Avatar of Markr71

ASKER

Yes it is held on our servers in the USA.  We are in the UK.  I assume that if I get a VPN set up I can just log into the servers using SSMS?  

I was hoping to be able to set this up myself without having to get the tech department involved, but maybe I'll have to.

Avatar of Markr71

ASKER

If I did want to connect to the server over the internet, how would I do it?  Apparently I am able to connect to the server if I wish to, so security doesn't seem to be an issue with this data!
Oh...so, you are staying on your own private network to connect?
Avatar of Markr71

ASKER

I believe so. Yes.
Avatar of Netocrat
Netocrat

First of all, SQL Enterprise Manager and Query Analyzer are designed for MS SQL Server 2000. You wish to use MS SQL 2005, so you need SQL Management Studio instead. To connect to a remote SQL 2005 server you just need to run SQL Management Studio, add a new server in its tree and specify the SQL server IP address, username and password. That's it.
Avatar of Markr71

ASKER

The servers in the USA aren't on our company network.  That is why I'm having to remote into it at the moment, but as you can imagine this is a bit of a pain.

I have downloaded SSMSE, but there is no option to connect to servers other than the ones locally.
Can you try to connect via IP address?
Avatar of Markr71

ASKER

Using SSMSE?
Avatar of Markr71

ASKER

No. When I type the details that I use to Remote into the server, I get error 18456.

ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial