Solved

Conflict with SQL Server Database Instance and Acornis BAckup Software

Posted on 2011-02-18
2
563 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
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ms sql + top 1 for each customer 3 43
how to eliminate duplicates in a string variable in t-sql? 30 63
Acrinis True image 2 55
sql query help 2 44
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

914 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

21 Experts available now in Live!

Get 1:1 Help Now