"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:3cq5dpF6qk3gpU1@individual.net...
> hi Chris,
> Chris Marsh wrote:
>> Hi,
>>
>> I am trying to connect remotely to a client's MSDE database with my
>> SQL Enterprise Manager so I can administer the database. I have
>> established a VPN to the client which I can ping and terminal serve
>> into the server but I cannot register the server with the SQL
>> Enterprise Manager. I have even tried turning off my Windows
>> Firewall.
>> What connection property am I missing at either the client site or at
>> my office that is preventing me from connecting?
>
> what kind of exception are you prompted with, at connection try?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>

Chris Marsh wrote:
> Hi,
>
> I am trying to connect remotely to a client's MSDE database with my
> SQL Enterprise Manager so I can administer the database. I have
> established a VPN to the client which I can ping and terminal serve
> into the server but I cannot register the server with the SQL
> Enterprise Manager. I have even tried turning off my Windows
> Firewall.
> What connection property am I missing at either the client site or at
> my office that is preventing me from connecting?

>I enter the IP into the Server line (leave Windows Auth or switch to SQL
>Auth) and then I get the messagebox:
>
> SQL Server registraion failed bause of hte connection falure displayed
> below.....
>
> SQL Server does not exist or access denied.
> ConnectionOpen (Connect())
>
> Yes | No
>
> Thanks!
>
>
> "Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
> news:3cq5dpF6qk3gpU1@individual.net...
>> hi Chris,
>> Chris Marsh wrote:
>>> Hi,
>>>
>>> I am trying to connect remotely to a client's MSDE database with my
>>> SQL Enterprise Manager so I can administer the database. I have
>>> established a VPN to the client which I can ping and terminal serve
>>> into the server but I cannot register the server with the SQL
>>> Enterprise Manager. I have even tried turning off my Windows
>>> Firewall.
>>> What connection property am I missing at either the client site or at
>>> my office that is preventing me from connecting?
>>
>> what kind of exception are you prompted with, at connection try?
>> --
>> Andrea Montanari (Microsoft MVP - SQL Server)
>> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
>> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
>> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
>> interface)
>> --------- remove DMO to reply
>>
>
>

Chris Marsh wrote:
> I enter the IP into the Server line (leave Windows Auth or switch to
> SQL Auth) and then I get the messagebox:
>
> SQL Server registraion failed bause of hte connection falure displayed
> below.....
>
> SQL Server does not exist or access denied.
> ConnectionOpen (Connect())

<cmarsh@synergy-intl.com> wrote:

>Hi,
>
>I am trying to connect remotely to a client's MSDE database with my SQL
>Enterprise Manager so I can administer the database. I have established a
>VPN to the client which I can ping and terminal serve into the server but I
>cannot register the server with the SQL Enterprise Manager. I have even
>tried turning off my Windows Firewall.
>
>What connection property am I missing at either the client site or at my
>office that is preventing me from connecting?
>
>Thanks,
>
>Chris
>