November 12, 2010 at 4:12 am
How do I connect to SQL Server remotely and administer my datbase objects? I have an installation of SQL server 2008 in my company server. I want to acess the database from home PC
SQL SERVER 2008
Productversion = 10.0.2531.0
Productlevel = SP1
Edition = Enterprise Edition
OS = Windows 2003
I searched the net but couldn't find understandable links. A step by step info will help a lot. Thanks...
November 12, 2010 at 4:24 am
Open SQL Server Management Studio.
in the "Server Name" block, enter the desired server name.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 12, 2010 at 4:49 am
Do you have a VPN configured? Some way to access your company's network from home? If not then you will need to speak with the appropriate people at your company (probably the network people and your manager) and get the necessary tools installed and configured and the necessary remote access permissions granted (for accessing the network)
You should also review your company's policies for remote access to the network. Often there will be OS or software requirements for any machine accessing the network from outside.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 12, 2010 at 5:07 am
First, my apologies, didnt read your full question.sorry.
I have a similar "need', and use a static Desktop standing on my desk 24/7.
From home I VPN into our network, log onto this desktop, and work from it on the local LAN.
But alternatively you could just VPN and continue...
Does it make sense?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 12, 2010 at 8:51 am
dilipd006 (11/12/2010)
How do I connect to SQL Server remotely and administer my datbase objects? I have an installation of SQL server 2008 in my company server. I want to acess the database from home PCSQL SERVER 2008
Productversion = 10.0.2531.0
Productlevel = SP1
Edition = Enterprise Edition
OS = Windows 2003
I searched the net but couldn't find understandable links. A step by step info will help a lot. Thanks...
If you can do this from a home computer, without any IT assistance or VPN, someone probably isn't doing their job.
That would indicate that your server is open to the internet.
I would hope that is not the case - that it's behind a firewall.
Greg E
November 15, 2010 at 12:03 am
Thanks for the reply...we r using the firewall.but not VPN ..we can able to access our Client DB from our Sql server..but while trying to access our DB from home system it is not working
November 15, 2010 at 2:13 am
I would certainly hope it doesn't work, because if it did it would mean that any person in the world could attempt to access your SQL Server.
Speak to the network people at your company, ask them how to access the company's network from home.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 15, 2010 at 3:27 am
so i haveto first configure a VPN in my company and only then i can access my sql server remotely.
But i have one doubt...how i am able to connect to the client DB in US? when no vpn is configured in my company...
November 15, 2010 at 6:52 am
dilipd006 (11/15/2010)
so i haveto first configure a VPN in my company and only then i can access my sql server remotely.But i have one doubt...how i am able to connect to the client DB in US? when no vpn is configured in my company...
This sounds like more than just connecting to your companies network and SQL server.
Assuming you get a connection into your server, if you have a client db outside of your firewall, you would need similar configuration done for that too. But this would be done by them, and they would let you know how to access.
Many companies are very strict about allowing access from the outside, especially to machines that they do not manage.
This is a good thing for security.
Even if you have the ability to setup access within your company, unless you have specific training to do this, hire an expert.
This is not something your want to take any chance on getting wrong.
Greg E
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply