Solved

Conflict with SQL Server Database Instance and Acornis BAckup Software

Posted on 2011-02-18
2
594 Views
Last Modified: 2016-10-27
Hello Experts,

I have SQL Server Express running a backend database for one of my Appliications on a Windows XP computer...

The SQL Server instance was stopped and would not restart after Acronis Backup software was installed.

1. When you try to restart the Service you get permission errors (Loacal System, User Administrator etc)
2. I tried uninstalling and re-installing the SQL Instance for my Application

- The Uninstall failed but it acts like the instance has been removed ("No Instances available" in Add New Programs now) allthough a new install thinks the instance is still there and won't install

Has anyone heard of a conflict between Acronis Backup Software install and previously installed (and functioning) SQL Instances?

Thanks!
0
Comment
Question by:Saxitalis
[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
2 Comments
 
LVL 38

Accepted Solution

by:
Jim P. earned 500 total points
ID: 34935502
I haven't heard of an issue between Acronis and SQL, but you never know.

As far as this:
The Uninstall failed but it acts like the instance has been removed ("No Instances available" in Add New Programs now) although a new install thinks the instance is still there and won't install

By default SQL tries to install to the path: x:\Program Files\Microsoft SQL Server\MSSQL.1 (or 2,3,...).

And if you have an incomplete SQL uninstall (which is every single one I've ever done) you run into path and registry conflicts. Make sure you have copies of your .mdf/.ldf files off to the side. Then delete the MSSQL.x paths that aren't for Acronis. After that download a registry cleaner and delete the SQL Server registry entries.

Then from there the install should work.
0
 

Author Closing Comment

by:Saxitalis
ID: 35047326
Thanks - this issue has not been resolved because it is not possible to access the computer at this time but I am going to try your solution when opportunity permits...
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article outlines why you need to choose a backup solution that protects your entire environment – including your VMware ESXi and Microsoft Hyper-V virtualization hosts – not just your virtual machines.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

730 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