x Want to participate? Join the group to interact
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 18 replies
  • Subscribers 25 subscribers
  • Views 8941 views
  • Users 0 members are here
Browse Forums
Announcements
646
topics
57
replies
General Discussion
2k
topics
5k
replies
Intelligence Reporting
348
topics
833
replies
Moe Vanker

ERROR DURING SYSTEM TREE LOAD! [TBRILLIANT PACKAGE MANAGER ERROR.E01]

SOLVED
Posted By

Good Afternoon 

I am faced with an error suddenly when opening SAGE 200 premium. The error reads as follows :

ERROR DURING SYSTEM TREE LOAD!

[TBRILLIANT PACKAGE MANAGER ERROR.E01]

A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider:SQL Network Interfaces, error"26 - Error Locating Server/Instance Specified)

I have tried uninstalling and reinstalling on the desktop but get the same error. When i try to locate the company it locates the SQL Server and company and the company appears on the list 

Regards

Moe

Parents
  • 0

    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

  • 0 in reply to Moe Vanker

    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 

  • 0 in reply to Bennie Pienaar

    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

Reply
  • 0 in reply to Bennie Pienaar

    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

Children

*Community Hub is the new name for Sage City