[Solution]:Sharepoint installation cant find SQL DB Server
Today, the following command saved my day. EXEC xp_readerrorlog My SharePoint 2010 installation cant find the DB server. I was able to ping , tracert to the db server from my windows (SharePoint). The SQL server were running perfectly fine. My first suspect was the firewall. I disabled the servers firewall in both servers. This is fine to do because these are testing systems. But , my sharepoint installation still cant find the SQL server. After googling for few hours, i tried the above command to check which port was being used by the SQL service. The SQL service was using port 56033 ( i guess this because the dynamic port was set as 0 ). After i configure the TCP Port to 1433 and removed the dynamic port value, the SQL server start listening in 1433 and my SharePoint was able to find the SQL server now. Hope this helps someone out there. Happy troubleshooting!