Solved

Fix Connection to Database issue - Sage Construct

Posted on 2011-03-20
6
532 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
  • 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

815 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now