connecting to sql server

i want to connect to an remote sql server 2005 from my office , where there remote sql server is in USA and my office is at india, i have done all the setting on the server where i have enabled remote connections and tcp/ip, i need to connect to the sqlserver using sql server management studio at my office, is it not possible to connect to an remote sql server without VPN

Few things to check

1. Does US SQL server machine has Firewall enabled? (considering opening the corresponding port)

2. Does INDIA machine has Firewall enabled?

3. If Windows Login is used to connect to US SQL server, is the login granted?

4. If you still see connection errors, you may consider to post the error message, error number and connecting scenario to "SQL Server Data Access " forum.

Thanks.

This posting is provided AS IS with no warranties, and confers no rights

Connecting to an instance of MSDE (SQL Server) on a remote machine

I have recently installed MS Office 2003 on a new machine running as a
storage machine on a peer to peer XP Professional network. I followed all
the instructioons and allowed only the login password to be changed.
I am now hoping to connect to the SQL Server instance from a desktop PC
(i.e. remotely). I have installed SQL Server2000 developer edition on my
local machine and have tried to conncet through the login presented as part
of the query analyser.
I can see the remote SQL Server instance in the drop down box and am
entering my loginID and password. I am assuming that my login ID should be
"sa" (default) and my password should match that which I set when I installed
the MSDE SQL Server on the remote machine.
When I go to connect a dialogue box pops up for about 30 secs informing that
the computer is attenmpting connection before I get an error message (Msg No.
17, Level 16, State 1: SQL Server does not exist or access denied).
I am logged on as adminsiatrator on both machines, and as far as I can tell
I should be able to connect. Is there anything I am missing?
hi Andrew,
andrew wrote:
> I have recently installed MS Office 2003 on a new machine running as a
> storage machine on a peer to peer XP Professional network. I
> followed all the instructioons and allowed only the login password to
> be changed.
> I am now hoping to connect to the SQL Server instance from a desktop
> PC (i.e. remotely). I have installed SQL Server2000 developer
> edition on my local machine and have tried to conncet through the
> login presented as part of the query analyser.
> I can see the remote SQL Server instance in the drop down box and am
> entering my loginID and password. I am assuming that my login ID
> should be "sa" (default) and my password should match that which I
> set when I installed the MSDE SQL Server on the remote machine.
> When I go to connect a dialogue box pops up for about 30 secs
> informing that the computer is attenmpting connection before I get an
> error message (Msg No. 17, Level 16, State 1: SQL Server does not
> exist or access denied).
> I am logged on as adminsiatrator on both machines, and as far as I
> can tell I should be able to connect. Is there anything I am missing?
this kind of excpetion is a generic MDAC exception, as reported in
http://support.microsoft.com/default...06&Product=sql
chances are you installed MSDE on the remote pc without enabling it's
network protocols (default behavior for MSDE installations) or the remote
WinXP is protected by WinXP sp2 Windows Firewall...
for the protoccols case, please verify via the Server Network Utility
(svrnetcn.exe) the desired protocol is enable...
for Windows Firewall,
http://support.microsoft.com/default.aspx?kbid=841249
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Connecting to a remote SQL Server

I am trying to connect to a SQL Server that is located in my home office from
remote office location. I've tried to setup a connection using Enterprise
Mgr, but it is not working. Can someone provide the steps if any to help?
Thanks
Sonya,
Have you tried registering the server using the IP address?
HTH
Jerry
"Sonya" <Sonya@.discussions.microsoft.com> wrote in message
news:4AE2C68B-3B14-4A88-A38F-716276A824EC@.microsoft.com...
>I am trying to connect to a SQL Server that is located in my home office
>from
> remote office location. I've tried to setup a connection using Enterprise
> Mgr, but it is not working. Can someone provide the steps if any to help?
> Thanks
|||Yes but it didn't find it. I can ping it, I tried to see if registered my
laptop db svr but it didn't.
"Sonya" wrote:

> I am trying to connect to a SQL Server that is located in my home office from
> remote office location. I've tried to setup a connection using Enterprise
> Mgr, but it is not working. Can someone provide the steps if any to help?
> Thanks
|||Sonya wrote:[vbcol=seagreen]
> Yes but it didn't find it. I can ping it, I tried to see if registered my
> laptop db svr but it didn't.
> "Sonya" wrote:
You'll most likely have Firewalls in between the 2 servers, so you need
to make sure that these allow SQL Server communication. If both
servers/pc's are installed with default settings, it will be port 1433
that is used. You can check this fairly easy by doing a telnet command
to the server (in a cmd prompt type "telnet YourRemoteServerIpAdresse
1433"). If you get to a blank screen, you have contact to the server on
that port. If the port it blocked you'll get an error message after a
short while telling you that the host could not be reached (...I can't
remember the exact message...).
Regards
Steen

Connecting to a remote SQL Server

I am trying to connect to a SQL Server that is located in my home office fro
m
remote office location. I've tried to setup a connection using Enterprise
Mgr, but it is not working. Can someone provide the steps if any to help?
ThanksSonya,
Have you tried registering the server using the IP address?
HTH
Jerry
"Sonya" <Sonya@.discussions.microsoft.com> wrote in message
news:4AE2C68B-3B14-4A88-A38F-716276A824EC@.microsoft.com...
>I am trying to connect to a SQL Server that is located in my home office
>from
> remote office location. I've tried to setup a connection using Enterprise
> Mgr, but it is not working. Can someone provide the steps if any to help?
> Thanks|||Yes but it didn't find it. I can ping it, I tried to see if registered my
laptop db svr but it didn't.
"Sonya" wrote:

> I am trying to connect to a SQL Server that is located in my home office f
rom
> remote office location. I've tried to setup a connection using Enterprise
> Mgr, but it is not working. Can someone provide the steps if any to help?
> Thanks|||Sonya wrote:[vbcol=seagreen]
> Yes but it didn't find it. I can ping it, I tried to see if registered my
> laptop db svr but it didn't.
> "Sonya" wrote:
>
You'll most likely have Firewalls in between the 2 servers, so you need
to make sure that these allow SQL Server communication. If both
servers/pc's are installed with default settings, it will be port 1433
that is used. You can check this fairly easy by doing a telnet command
to the server (in a cmd prompt type "telnet YourRemoteServerIpAdresse
1433"). If you get to a blank screen, you have contact to the server on
that port. If the port it blocked you'll get an error message after a
short while telling you that the host could not be reached (...I can't
remember the exact message...).
Regards
Steen

Connecting to a remote SQL Server

I am trying to connect to a SQL Server that is located in my home office from
remote office location. I've tried to setup a connection using Enterprise
Mgr, but it is not working. Can someone provide the steps if any to help?
ThanksSonya,
Have you tried registering the server using the IP address?
HTH
Jerry
"Sonya" <Sonya@.discussions.microsoft.com> wrote in message
news:4AE2C68B-3B14-4A88-A38F-716276A824EC@.microsoft.com...
>I am trying to connect to a SQL Server that is located in my home office
>from
> remote office location. I've tried to setup a connection using Enterprise
> Mgr, but it is not working. Can someone provide the steps if any to help?
> Thanks|||Yes but it didn't find it. I can ping it, I tried to see if registered my
laptop db svr but it didn't.
"Sonya" wrote:
> I am trying to connect to a SQL Server that is located in my home office from
> remote office location. I've tried to setup a connection using Enterprise
> Mgr, but it is not working. Can someone provide the steps if any to help?
> Thanks|||Sonya wrote:
> Yes but it didn't find it. I can ping it, I tried to see if registered my
> laptop db svr but it didn't.
> "Sonya" wrote:
>> I am trying to connect to a SQL Server that is located in my home office from
>> remote office location. I've tried to setup a connection using Enterprise
>> Mgr, but it is not working. Can someone provide the steps if any to help?
>> Thanks
You'll most likely have Firewalls in between the 2 servers, so you need
to make sure that these allow SQL Server communication. If both
servers/pc's are installed with default settings, it will be port 1433
that is used. You can check this fairly easy by doing a telnet command
to the server (in a cmd prompt type "telnet YourRemoteServerIpAdresse
1433"). If you get to a blank screen, you have contact to the server on
that port. If the port it blocked you'll get an error message after a
short while telling you that the host could not be reached (...I can't
remember the exact message...).
Regards
Steen