Receiving error message locating server

Ruby Moshenko 0 Reputation points
2024-06-08T19:13:59.6933333+00:00

one main PC uses SAGE 50 and we had issues with that system. Since that has been up and running our other computers are not able to access TBW work stations. We get the following error messeage

SQL Network

interfaces

Error locating server

We have called SAGE not on their end, contacted phone company not on their end

Please help!!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,104 questions
{count} votes

2 answers

Sort by: Most helpful
  1. MikeyQiaoMSFT-0444 1,255 Reputation points
    2024-06-11T09:25:02.88+00:00

    Hi,Ruby MoshenkoWe cannot provide troubleshooting measures for your client software failure, I suggest you should investigate the basics of implementing a connection with the SQL Server instance.

    1. Make sure your server name is correct, e.g., no typo on the name.
    2. Make sure your instance name is correct and there is actually such an instance on your target machine. [Update: Some application converts \ to . If you are not sure about your application, please try both Server\Instance and Server\Instance in your connection string]
    3. Make sure the server machine is reachable, e.g, DNS can be resolve correctly, you are able to ping the server (not always true).
    4. Make sure SQL Browser service is running on the server.
    5. If firewall is enabled on the server, you need to put sqlbrowser.exe and/or UDP port 1434 into exception.

    Best Regards,

    Mikey Qiao


    If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.


  2. Ruby Moshenko 0 Reputation points
    2024-06-13T15:53:50.23+00:00

    it ended up being the firewall we had taken it off a couple of times but when the rival group did it and we reset all came back online

    thank you

    0 comments No comments