I am using windows XP SP2 and SQL Server 2000. I can successfully connect to a database from the host computer via 127.0.0.1 and also with the local IP (which is 192.168.1.6).
But when when I try to connect to that database from another PC via 192.168.1.6, it doesn't work.
I tried to allow ports in the firewall and it still didn't work. I also tried turning the firewall off and it still didn't work.
I can ping 192.168.1.6 successfully from other computers.
I tried WampServer which worked.
I also did some TCP/IP settings which Microsoft asked me to do and it still didn't work.
I think it has something to do with SQL Server permission and/or the listening IP, since the error message says that the database does not exist or that access is denied (but I know that the database exists).
How should I continue my error searching process?