Cannot connect to SQL Server 2008 on workgroup network

Question

Two Windows 7 computers connected through network (workgroup) and can ping each other. I have my database on one of them and need the other computer to connect to this database through my window application.

Here's what I have :

• both pcs are Windows 7 (ultimate & professional).
• I enabled TCP/IP under SQL Configuration Tools.
• I enabled the Browser service.
• I configured the connection string correctly.
• I tried connecting by ip address.
• I created a rule in my Windows Firewall to allow incoming connection yo SQL Server with its default port.
• I don't have another Firewall.
• I allowed external connection from SQL Server Management Studio.

Despite all this, I am still not able to connect to SQL Server on the other computer.

Can anybody help please?

Answer 1

It turned out to be a Firewall problem. I disabled Firewall and it worked. Even though I have the port opened as a rule, but there is something else in my Firewall which seem to be blocking the connection.

I ended up disabling Windows Firewall and installing another one.