Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Access to Database Denied
Message
 
 
To
05/03/2010 09:52:26
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01450193
Message ID:
01452821
Views:
32
Thank you, Tracy.

>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.aspx
>
>Comodo:
>http://forums.comodo.com/frequently-asked-questions-faq-for-comodo-firewall/configuring-comodo-for-ms-sql-server-in-a-local-network-t5196.0.html
>
>In 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
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform