Hi I downloaded MSDE2005 and I tried to set up an ODBC connection to a
database I created. I can see the database using client but I got this
error through the ODBC manager

[Microsoft][SQL Native Client]An error has occurred while
establishing a connection to the server. When connecting to
SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow
remote connections.


Can anyone, please tell me what I need to do to get this setup? I tried
to dabble with the TCIP and remote setting but nothing worked.

Regards

Hi there,

look here:

http://www.datamasker.com/SSE2005_NetworkCfg.htm

HTH, Jens Suessmeyer.