Link to home
Start Free TrialLog in
Avatar of James Wilkinson
James WilkinsonFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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.

Avatar of Alpesh Patel
Alpesh Patel
Flag of India image

Please check Sage configuration for compatibility with Win 7
Avatar of James Wilkinson

ASKER

This version of Construct is Win 7 Compatible
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 !!
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
ASKER CERTIFIED SOLUTION
Avatar of James Wilkinson
James Wilkinson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
i did not find much help & the issue was resolved by the software vender