August 27, 2008 at 4:00 am
Dear all,
we have 2 sqlserver2005's present in different locations in two different buildings . One in my building and another one in 2nd building.
I should able to connect database present in sqlserver in another building through my server, through internet, we have windows xp on both , Is it possible to connect through INTERNET , if so whats the procedure. Pls help
Regards,
chaitanya
August 27, 2008 at 4:32 am
What do you mean by "connect"?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 27, 2008 at 4:55 am
connect in the sense "access the database " present in the server
August 27, 2008 at 5:12 am
Yes you can connect to the sql server provided you configure link server .refer BOL has for Link server configurations.
August 27, 2008 at 10:10 am
It is not a good procedure to expose your SQL server to the internet. If you are doing so, it would be a good idea to have a firewall up and all your service packs and CU's applied.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply