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

CONNECTING SQL MAIL TO MAIL SEVER

Is SQL mail apart of the installation or is a service that
can be turned on and off after install.Try this link -
http://support.microsoft.com/defaul...kb;en-us;263556
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"JOHN" <anonymous@.discussions.microsoft.com> wrote in message
news:098501c3deb8$c4b411f0$a401280a@.phx.gbl...

quote:

---

> Is SQL mail apart of the installation or is a service that
> can be turned on and off after install.

---

|||In message <098501c3deb8$c4b411f0$a401280a@.phx.gbl>, JOHN
<anonymous@.discussions.microsoft.com> writes

quote:

---

>Is SQL mail apart of the installation or is a service that
>can be turned on and off after install.

---

It isn't a proper Windows Service, and no there nothing extra to
install.
Here is some more info on SQL Mail-
INF: How to Configure SQL Mail
http://support.microsoft.com/defaul...kb;EN-GB;263556
How to Use SQL Mail in MS SQL Server 7.0 with MS Outlook and MS Exchange
Server
http://www.microsoft.com/technet/pr...il.asp?frame=tr
ue
Support WebCast: Troubleshooting Microsoft SQL Mail
http://support.microsoft.com/servic...1/wcblurb091301
.asp
HOW TO: Troubleshoot Your SQL Mail Issue
http://support.microsoft.com/defaul...kb;en-us;321183
INF: Troubleshooting SQLMail with Microsoft Exchange Server
http://support.microsoft.com/defaul...kb;en-us;153159
INF: Frequently Asked Questions - SQL Server - SQL Mail
http://support.microsoft.com/defaul...kb;en-us;311231
INF: Common SQL Mail Problems
http://support.microsoft.com/defaul...kb;en-us;315886
This KB is also very helpful when you are having errors-
INFO: List of Extended MAPI Numeric Result Codes
http://support.microsoft.com/defaul...kb;EN-US;238119
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org