Solved

Fix Connection to Database issue - Sage Construct

Posted on 2011-03-20
6
539 Views
Last Modified: 2012-05-11
I have a client who has an issue with Sage Construct. Sage Support has said they cannot help him with this issue as it is a network issue so he has called me in. The issue is that the program cannot access the Database which is stored on the local machine & the machine was running SQL Server 2005 the error was caused by an upgrade to Win 7 & in the process he changed the PC Name. The program was looking for the Database using the old PC name path.

I though this would be a simple change or edit somewhere but the guy had tore his PC apart trying to fix the issue himself. When i got there there was many errors so i uninstalled the whole program Sage Construct & SQL Server 2005.

When i attempt to reinstall from the disk it wants to install SQL 2008 rather than 2005  & it wants to use MSDE instead of ACT but aslo says that the MSDE\Setup.exe cannot be found on the disk.

I have installed without the MSDE but it states that there is a problem with an MSI file & Configuration of the Program Sage Construct cannot continue.

I have the old database file backed up but no program backup file as this guy did not complete a full backup of the program. Usually sage products which i have used have a built in backup util.

could anyone help please i was hoping that i reinstall the program switch the database files over and everything would fall back into place but so much has changed from the initial install i am not confident.

0
Comment
Question by:James Wilkinson
[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
  • 5
6 Comments
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 35179044
Please check Sage configuration for compatibility with Win 7
0
 

Author Comment

by:James Wilkinson
ID: 35180560
This version of Construct is Win 7 Compatible
0
 

Author Comment

by:James Wilkinson
ID: 35946282
How can i bring this question back to life i still have an issue. Sage Support are rubbish & they keep saying it is a network issue but the network is fine & we can see the database over the network etc etc.

HELP !!
0
Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

 

Author Comment

by:James Wilkinson
ID: 35946289
Could anyone give me details on how to create a new SQL User with full permissions. I would like to do this to rule out permission issues & i think they may be only one user able to access this database.

Thanks you
0
 

Accepted Solution

by:
James Wilkinson earned 0 total points
ID: 36026579
After many hours on the phone to Sage & demanding that they should be able to fix this issue, they did.

Some rogue update to the 2 Databases caused permission errors

It is now fixed
0
 

Author Closing Comment

by:James Wilkinson
ID: 36053163
i did not find much help & the issue was resolved by the software vender
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

623 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