Connecting to a default installation of MSDE on XP

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?
hi,
mark@.sherwood.org.uk wrote:
> 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?
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.shtmhttp://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
|||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,
mark@.sherwood.org.uk wrote:
> 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.
this is a general MDAC message indicatin connection problem(s)... please
have a look at
http://support.microsoft.com/default...06&Product=sql
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.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