Solved

Sage Line 50 Manufacturing database

Posted on 2010-09-15
4
2,217 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.
0
Comment
Question by:MRK78
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 10

Expert Comment

by:Bruce Denney
ID: 33684030
You need to point the Manufacturing product at the new server, there is a config tool in the start menu to do this.
0
 
LVL 3

Accepted Solution

by:
MRK78 earned 0 total points
ID: 33685916
As I said in the OP, i have changed the config details using the config tool, even did a new install.  Turns out there is a file called connection.udl on the server in the sage accounts folder (manufacturing ties in with accounts).  Search for connection.udl on the server, then rename .old or something.  Restart line 50 manufacturing on a client and it prompts for new server details.  Give new server details and it creates a new SQL database.  You can then restore the back up of the old server database to the new server and Voila, working again.
0
 
LVL 10

Expert Comment

by:Bruce Denney
ID: 33694384
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.
0
 
LVL 3

Author Comment

by:MRK78
ID: 33699619
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.
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Recommendation on POS Software for Retail 6 551
New Quickbooks install will not open 13 3,612
Sage Payroll 2 385
Corrupt QBW File 8 130
Hi, I've just fixed a problem with Sage 50 Accounts 2010 crashing when creating a new Company.  I've spent nearly 4 hours on it including three calls to the Sage helpdesk (they didn't work it out in the end - I did!) ... so I thought I'd share th…
Getting data out of MAS90 doesn’t have to be tedious or time consuming.  With any version of Excel using the included Microsoft Query function, you can access just about any data set or combination of data sets stored in your MAS90 MAS200 Software. …
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question