why cant my other computers connect to a sql server?

Question

Hello, I have a small business and we use a reservation operating system program that uses an sql server on a "master" computer. Recently I have switched the master from the office to another workstation outside and made the office a "client". The reason wy I didd that is because the main computer in the office wasnt meeting the specs that a master should. We now have a brand new computer that all the workstations can "see" and they know its there but when I try to connect them to the sql server on it, they say connection not established or connection failed. Why is this and how can I fix it? (When I click about on the sql service manager, below is what it is and what version it is.) Thanks for all your help in advance! Microsof sql srever service manager version 8.00.760 Copyright 1991-2000 Microsoft Corporation

Answer 1

I would check the ODBC settings in the front-end application since the location of the sql db has been changed

Answer 2

I have in basic terms had this difficulty one month or per chance 2 months interior the previous. I in elementary words thoroughly reinstall my drivers downloaded from DGTSoft. you are able to google for "DGTSoft Drivers replace application". It installs the in simple terms proper and outstanding drivers on your abode living house windows 8 immediately. want it truly is positive for you.