hi,
Ahmet Aşçı wrote:
> I M SURE THAT MSDE IS LISTENING ON TCP 1433 PORT
>
> I M USING THIRT PARTY PROGRAM TO CONFIGURE FOR MSDE
>
> WHEN I CONNECT LOCAL MSDE DATABASE FROM OUT OF OFFICE
>
> THE PROGRAM SAID THAT : DATABASE DOES NOT EXIST OR ACCES DEINED
>
> TO LOGIN I AM USING USER:SA PASS NULL
do you mean that only local connections are available? (local connection to
the machine hosting MSDE, while connections coming from the lan are
refused?) if this is the case, MSDE installs by default disabling remote
connections and you have to enable them at install time, providing the
DISABLENETWORKPROTOCOLS=0 additional parameter or, later at run time, via
Server Network Protocols utility...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply
>> Stay informed about: REMOTE CONNECTION FOR MSDE