hi,
[quoted text, click to view]

this is a general MDAC message indicatin connection problem(s)... please
have a look at
http://support.microsoft.com/default.aspx?scid=kb;en-us;328306&Product=sql
http://support.microsoft.com/default.aspx?kbid=841249
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

On PC that has a default installation of MSDE and XP SP2, what ports
need to be open to allow remote connection to the MSDE?

I have temporariliy stopped the XP Firewall on the remote PC. Created
an alias in the Client Network Utility on the pc trying to connect to
the MSDE but the registration still fails it shows the following error
message.

SQL Server does not exist or access is denied,
ConnectionOpen(Connect()).

I am a memebr of the sys admin role and I have also tried as the SA
account both display the same error message.

hi,
[quoted text, click to view]

a default instance requires TCP/IP 1433 port, while for named instance (with
dynamic port assignement) you have to check the assigned port using the
Server Network Utiliy (svrnetcn.exe) or inspecting the registry, say
HKLM\SOFTWARE\Microsoft\Microsoft SQL
Server\InstanceName\MSSQLServer\SuperSocketNetLib\Tcp
TcpPort

and of course UDP 1434...
you can close UDP 1434 assigning a static port to the named instance, but
that requires definig server alias on the Client Network Utility
(cliconfg.exe) on each remote client...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply