AyaNova service management & work order software
AyaNova Support Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Firewalls Ports etc MsSQL Express Expand / Collapse
Author
Message
Posted 5/29/2009 12:58:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 5/30/2009 4:03:44 AM
Posts: 6, Visits: 130
We have one PC in our organisation that seems to have a problem with the firewall. The only difference with this pc is that its running Sophos firewall. We are using the same config file as our other admin PC's without issue. On this PC we get the message that our server may not be configured to accept remote connections. Our biggest problem is that we have to use sophos on this machine for as it has sensitive data and sophos is a prerequisite specified by the client whom the data belongs to.
Anyone tell me which ports and programs I need to make exceptions for?
Thanks in advance. Steve Lipton.
Post #4663
Posted 5/29/2009 2:40:42 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: 2 days ago @ 7:34:22 AM
Posts: 2,190, Visits: 5,029
abscon (5/29/2009)
We have one PC in our organisation that seems to have a problem with the firewall. The only difference with this pc is that its running Sophos firewall. We are using the same config file as our other admin PC's without issue. On this PC we get the message that our server may not be configured to accept remote connections. Our biggest problem is that we have to use sophos on this machine for as it has sensitive data and sophos is a prerequisite specified by the client whom the data belongs to.
Anyone tell me which ports and programs I need to make exceptions for?
Thanks in advance. Steve Lipton.

Hi Steve

You will want to check with Sophos themselves to see if there is something specific you need to set on the networked computer itself that is running Sophos firewall as they will know best what is needed.

On the server itself where SQL is running, as per step #4 of the network AyaNova SQL configuration http://www.ayanova.com/AyaNova5webHelp/network_sql_server_2005_config.htm (or if using SQL Express then the AyaNova 5 Help file section is http://www.ayanova.com/AyaNova5webHelp/network_sql_express_configurat.htm) if there is a firewall enabled on the "server" computer where the SQL Express configuration is installed and setup,  set exceptions for sqlserver.exe and sqlbrowser.exe, and/or UDP port 1434 and 1433 in some cases.

You will also what to make sure that remote connections are enabled in SQL too - see forum topics such as http://forum.ayanova.com/Topic4256-111-1.aspx ,  http://forum.ayanova.com/Topic3582-111-1.aspx?Highlight=SQL+Server+does+not+allow+remote+connections and the web site http://www.datamasker.com/SSE2005_NetworkCfg.htm has 5 things to check.

Another suggestion is to do a search online with the specific text of the error you receive trying to attach to the AyaNova database from this computer, as well as the word Sophos as that might return links of others that have encountered and their solutions

Do post back what resolved it for you of the one networked computer running Sophos firewall unable to connect to the SQL database.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #4664
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: AyaNova Sales & Support

Permissions Expand / Collapse

All times are GMT -8:00, Time now is 7:06am

Powered by InstantForum.NET v4.1.4 © 2010
Execution: 0.031. 9 queries. Compression Disabled.