Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-12-16 : 08:07:21
|
| santosh writes "HiI am having MS SQL Server 2000 installed on Windows 2002 Professional at our USA.I am in India and have MS SQL Server 2000 installed on my machine which is Windows 2000 Professional OSnow i want to connect to the Remote MS SQL Server in USA using Enterprise Manager in india and view the databases." |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-12-16 : 08:53:02
|
| By Windows 2002 Pro do you mean Windows XP? What exactly is your question? There is not one asked. Did you want to know how to connect remotely? Whoever is setting up your SQL Server should give you the connection info, weather that's for a VPN with RDP or whatever they decide you need to use.Daniel, MCP, A+SQL Server DBAwww.dallasteam.com |
 |
|
|
gkrishn
Starting Member
16 Posts |
Posted - 2005-12-16 : 09:49:36
|
| Are you on same network? |
|
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2005-12-16 : 10:02:31
|
| This get's asked a lot.I feel if people understood the Why's of their situation there would be a lot less asking of HowConsider what would happen if a bad man wanted to connect to the Server you are trying to connect to in the other office. Would the firewall at the other office have standard port 1433 open? Would they have ANY TCP-IP port to the server open to an "outsider!"? Password or not, many properly configured networks don't even want to give you the road to get there. As in NO communications AT ALL to the SQL SERVER beyond the firewall using a direct IP/dns name/NAT translated IP. That is why you may need to be recognized as an insider with a VPN(a tunnel which effectively places you on the LAN in the other office) or terminal server(remote control of a virtual PC on the LAN in the other office), so you aren't an "outsider". Or a web admin tool that uses an insider, (a LAN web account from a LAN Web Server) to publish SQL information through a firewall by acting as your agent."it's definitely useless and maybe harmful". |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-17 : 15:19:46
|
| would this helpso many questions are being asked of this latelyhttp://sqlteam.com/forums/topic.asp?TOPIC_ID=59208 |
|
|
|
|
|
|
Remotely database connection through enterprise manager