Connecting MSDE using ADO over TCPIP, XP

Gurus,
I've installed MSDE on an XP Professional server - to be used by the public
as part of a forum I'm building.
I can connect locally but fails when I connect locally using the option:
Network Library=dbmssocn
Please help me out here, I'm not a network/XP person and I'd like to get it
so that anyone can connect for testing and discussion purposes.
(I did manage to at least figure out how to enable connections to the web
server on the same machine where the forum is hosted but can't find any
switches for SQLServer..')
Mike Collier BSc( Hons) Comp Sci
Get a copy of AdoAnywhere Browser FREE if you register for the forum
quickly...
http://www.adoanywhere.com/forumCheck your NT Application Event log and verify that SQL Server is listening
on TCP.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Micke
1. Open up the Client Network Utility, located at:
c:\Windows\system32\cliconfg.exe
2. Click n the Alias Tab, make sure you add an Alias to access your MSDE
from either TCP/IP or Named Pipes.
We also use the same network library, and we have had to add the Name Pipes
Alias. This name can be any name you choose.
Peace in Christ
Marco Napoli
http://www.ourlovingmother.org
"Mike Collier" <mike@.adoanywhere.com> wrote in message
news:unqOqW52DHA.3224@.tk2msftngp13.phx.gbl...

quote:

---

> Gurus,
> I've installed MSDE on an XP Professional server - to be used by the
> public
> as part of a forum I'm building.
> I can connect locally but fails when I connect locally using the option:
> Network Library=dbmssocn
> Please help me out here, I'm not a network/XP person and I'd like to get
> it
> so that anyone can connect for testing and discussion purposes.
> (I did manage to at least figure out how to enable connections to the web
> server on the same machine where the forum is hosted but can't find any
> switches for SQLServer..')
> --
> Mike Collier BSc( Hons) Comp Sci
> Get a copy of AdoAnywhere Browser FREE if you register for the forum
> quickly...
> http://www.adoanywhere.com/forum
>
>

---

Connect to sql server 2000 via internet

I'm Building a windows application which updates an internet site's database.
Is it possible to connect directly to the sql server through the internet?
If so is it the most efficient way ? perhaps a web service or streaming is a better solution?
Thanks.If you can VPN into the server, using normal SQL Server connectivity will be best. Web Services certainly could do it, though this might not qualify as "most efficient." You could connect directly through the internet if the correct port (1433 as I recall) is open. Leaving this port open is not a great idea, security wise. That is why a VPN would be a better solution, if possible.