We help IT Professionals succeed at work.

Sage Line 50 Manufacturing database

MRK78
MRK78 asked
on
2,383 Views
Last Modified: 2013-12-11
We have installed a new SBS2008 server in a customer and migrated the sage line 50 manufacturing database to the new server.  We are now unable to get the clients to connect to the new server.  We havechecked the line 50 config, changed all the DSN connections in ODBC manager and even scoured the registry on the clients for references to the old server.  When we stop SQL on the old server, the client cannot run L50 manufacturing, when we restart it, the client does connect but it is to the old server.  Does anyone have any suggestions for where to look for the setting that is still telling the client to go to the old server.
   I have even un-installed/re-installed on one client.  We have also done a fresh install on a new machine on the domain and configured the DSN 's in ODBC, but it will still only connect when SQL is running on the old server.

Any help would be much appreciated.
Comment
Watch Question

Bruce DenneySage 50 Consultant and Integrator
CERTIFIED EXPERT

Commented:
You need to point the Manufacturing product at the new server, there is a config tool in the start menu to do this.
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Bruce DenneySage 50 Consultant and Integrator
CERTIFIED EXPERT

Commented:
Running the Manufacturing Config tool allows you to change the settings without having to delete the connection.udl file.

The solution the questioner found is a more difficult way of doing something simple

The OP make no mention of having used the Manufacturing config tool it only mentions the line 50 config.  

This solution is a poor solution to the problem and should not be left.

Author

Commented:
I did mention running the manufacturing config tool which did not resolve the issue, having spoken to Dage, they told me to delete the .udl file to resolve the issue, hence the reason i posted it and you should read and maybe re-read before calling something a poor solution.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.