Hi,
I visited a client's site yesterday to do a test of my app that uses a SQL Server database. They wanted to see the installation of SQL Server so we went through that, installing on a Windows XP Pro system. Upon completion of the install I ran the surface area configuration manager to allow remote TCP/IP connections. I also checked the firewall to ensure port 1433 was allowed (the firewall was actually switched off).
They had a small network setup just for this test and had it configured as a workgroup. The remote PCs could access shared folders on the PC with SQL Server on it, but they could not see SQL Server at all. We tried connecting with my app which uses the Windows API to enumerate all available servers and databases, it found none. We checked using the ODBC applet and still couldn't find any servers.
Has anybody any ideas what could have caused this problem and how to fix it?