Either go to the Comodo forums and find out how to configure Comodo for SqlServer access or uninstall it and use the windows firewall in which case you still need to configure it correctly:
Windows Firewall:
http://msdn.microsoft.com/en-us/library/cc646023.aspxComodo:
http://forums.comodo.com/frequently-asked-questions-faq-for-comodo-firewall/configuring-comodo-for-ms-sql-server-in-a-local-network-t5196.0.htmlIn the future, when prompted for a service you know you are using, don't block unless you know for certain that you want it blocked. Do some research on how sqlserver and SSRS communicate.
>I think I finally figured what causes the problem/error shown below. Once in a while when I turn on my PC Comodo reports that ReportingServices is trying to connect to Internet (or something to that extend). I usually click on Deny. And after that I cannot access my SQL Server until I reboot. Does it make sense?
>
>>Are you using Windows or SQL Server authentication in app? What is default database for the login? What database are you login to?
>>
>>>
>>>Every so often when I start my app (VFP9) that uses SQL 2005, I get the message:
>>>
>>>Connection failed:
>>>SQL State: '08004'
>>>SQL Server Error: 4060
>>>Server rejected the connection; Access to selected database has been denied
>>>
>>>
>>>Then I have to restart my computer and 9 out of 10 times things start working. What causing this problem of database access being denied?
>>>
>>>TIA
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"