Solved

Fix Connection to Database issue - Sage Construct

Posted on 2011-03-20
6
525 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:Wilkinson1546
  • 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:Wilkinson1546
ID: 35180560
This version of Construct is Win 7 Compatible
0
 

Author Comment

by:Wilkinson1546
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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 

Author Comment

by:Wilkinson1546
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:
Wilkinson1546 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:Wilkinson1546
ID: 36053163
i did not find much help & the issue was resolved by the software vender
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This video discusses moving either the default database or any database to a new volume.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

762 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

19 Experts available now in Live!

Get 1:1 Help Now