[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 550
  • Last Modified:

Fix Connection to Database issue - Sage Construct

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
James Wilkinson
Asked:
James Wilkinson
  • 5
1 Solution
 
Alpesh PatelAssistant ConsultantCommented:
Please check Sage configuration for compatibility with Win 7
0
 
James WilkinsonNetwork ManagerAuthor Commented:
This version of Construct is Win 7 Compatible
0
 
James WilkinsonNetwork ManagerAuthor Commented:
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
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
James WilkinsonNetwork ManagerAuthor Commented:
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
 
James WilkinsonNetwork ManagerAuthor Commented:
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
 
James WilkinsonNetwork ManagerAuthor Commented:
i did not find much help & the issue was resolved by the software vender
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now