Hi there

Using port query, I have verified tcp port 1433 is open :

=============================================

Starting portqry.exe -n xxx.xxx.xxx.x -e 1433 -p TCP ...

Querying target system called:

xxx.xxx.xxx.x

Attempting to resolve IP address to a name...

IP address resolved to xxxx.xxxxx.COM

querying...

TCP port 1433 (ms-sql-s service): LISTENING
portqry.exe -n xxx.xxx.xxx.x -e 1433 -p TCP exits with return code 0x00000000.

I have also tested the SQL Connection UPD port 1434 and have the following after running port query :

=============================================

Starting portqry.exe -n xxx.xxx.xxx.x -e 1434 -p UDP ...

Querying target system called:

xxx.xxx.xxx.x

Attempting to resolve IP address to a name...

IP address resolved to xxxxx.xxxxx.COM

querying...

UDP port 1434 (ms-sql-m service): LISTENING or FILTERED

Sending SQL Server query to UDP port 1434...

Server's response:

ServerName xxxxx
InstanceName SQLEXPRESS
IsClustered No
Version 14.0.1000.169
tcp 1433
np \\xxxx\pipe\MSSQL$SQLEXPRESS\sql\query

==== End of SQL Server query response ====

UDP port 1434 is LISTENING
portqry.exe -n xxx.xxx.xxx.x -e 1434 -p UDP exits with return code 0x00000000.

With all this in place,when i try to access evolution via the remote pc, it gets stuck at @ loading add-ins

Hi Moe Sorry for the late response on your query

At this stage are you able at least to connect and open MS SQL Management Studio on the same SQL instance on which your Evolution company is located on?

Also, please consider the article I found on the old Online KB. I realise the wording in your message is a bit different but please at least check out the advice provided in this article: 

kb.pastel.co.za/article.php

Kind regards

Bennie 

Hi Moe Sorry for the late response on your query

At this stage are you able at least to connect and open MS SQL Management Studio on the same SQL instance on which your Evolution company is located on?

Also, please consider the article I found on the old Online KB. I realise the wording in your message is a bit different but please at least check out the advice provided in this article: 

kb.pastel.co.za/article.php

Kind regards

Bennie 

Good Morning Bennie

I am able to open MS SQL Management Studio on the same SQL instance. When i try to locate the company via evolution remotely, the following happens :

1. If i use an IP address\SQLEXPRESS i get connection open error, server does not exist or access denied

2. If i use the servername\SQLEXPRESS i get an error unable to connect to server XX\SQLEXPRESS, reason "login failed for use 'sa' 

* case 1, all ports are open and verified via portqry

* case 2, if i use the same password to login via management studio i am able to login in to sqlexpress database object, so the password is DEFINITELY correct

Regards

Mohammed

Hi Mohammed

Please implement  the following (if not done already so)

Open the link below to access a detailed Evolution configuration guide (as found on the new Sage Online KB),  that needs to be implemented after MS SQL has been installed. 

The name of the KBA is called: 

Evolution Network: Sage Evolution Network and Workstation Configurations after MS SQL has been installed

and can be found here 

https://za-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=200324121432309&page=1&position=1&q=EVOLUTION%20NETWORK%20AND%20WORKSTATION%20CONFIGURATIONS%20AFTER%20MS%20SQL%20HAS%20BEEN%20INSTALLED&searchaliases=custom_za_en_twohundredevo;&guest=0

You will be requested to Sign Up if you haven't done so yet but the process is very quick and easy 

Finally, please also note the guide explains the instructions on setting up at least 4 ports on the server's and workstations' Firewall, allowing the correct network protocols and a couple other important settings.

If after you confirmed all is in place and still observe the above error, please feel free to contact me again and we'll fix it for you 

Kind Regards

Bennie