Tags: corrupt, database, installation, instances, loss, microsoft, mysql, oracle, power, running, server, sql, suffered, tampered

Your SQL Server installation is either corrupt or has been tampered with...

On Database » Microsoft SQL Server

8,722 words with 4 Comments; publish: Sun, 01 Jun 2008 23:56:00 GMT; (25045.90, « »)

SQL Server 2005 (running side by side with SQL Server 2000). The problem is

with one of my SQL Server 2005 instances.

I suffered a power loss. Now, I can't connect to one of my installed

instances via Enterprise Manager and I can't start the service directly

either via the Services applet. The full error message is:

Your SQL Server installation is either corrupt or has been tampered with

(Error getting instance ID from name.). Please uninstall and then re-run

setup to correct this problem.

OK, so how do I go about uninstalling an instance? I don't need to install

the entire product do I? Oh, please, please say no!!!

Thanks for your advice!

- Joe Geretz -

All Comments

Leave a comment...

  • 4 Comments
    • Hmmm - sounds to me your registry is screwed!

      You could try this (at your own risk) before you go down the route of

      reinstalling.

      http://support.microsoft.com/default.aspx?scid=kb;en-us;290301

      Immy

      "Joseph Geretz" <jgeretz.sqlserver.todaysummary.com.nospam.com> wrote in message

      news:OeVQHNBFHHA.3304.sqlserver.todaysummary.com.TK2MSFTNGP05.phx.gbl...

      > SQL Server 2005 (running side by side with SQL Server 2000). The problem

      > is with one of my SQL Server 2005 instances.

      > I suffered a power loss. Now, I can't connect to one of my installed

      > instances via Enterprise Manager and I can't start the service directly

      > either via the Services applet. The full error message is:

      > Your SQL Server installation is either corrupt or has been tampered with

      > (Error getting instance ID from name.). Please uninstall and then re-run

      > setup to correct this problem.

      > OK, so how do I go about uninstalling an instance? I don't need to install

      > the entire product do I? Oh, please, please say no!!!

      > Thanks for your advice!

      > - Joe Geretz -

      >

      #1; Sun, 01 Jun 2008 23:57:00 GMT
    • Hi Immy,

      Are you saying there's no documented procedure for uninstalling an instance?

      I'd much rather completely uninstall and reinstall SQL SErver 2005 than mess

      around with the Registry. But I'm hoping I won't have to.

      Thanks,

      Joe Geretz

      "Immy" <therealasianbabe.sqlserver.todaysummary.com.hotmail.com> wrote in message

      news:OGNrc$GFHHA.4080.sqlserver.todaysummary.com.TK2MSFTNGP02.phx.gbl...

      > Hmmm - sounds to me your registry is screwed!

      > You could try this (at your own risk) before you go down the route of

      > reinstalling.

      > http://support.microsoft.com/default.aspx?scid=kb;en-us;290301

      > Immy

      > "Joseph Geretz" <jgeretz.sqlserver.todaysummary.com.nospam.com> wrote in message

      > news:OeVQHNBFHHA.3304.sqlserver.todaysummary.com.TK2MSFTNGP05.phx.gbl...

      >> SQL Server 2005 (running side by side with SQL Server 2000). The problem

      >> is with one of my SQL Server 2005 instances.

      >> I suffered a power loss. Now, I can't connect to one of my installed

      >> instances via Enterprise Manager and I can't start the service directly

      >> either via the Services applet. The full error message is:

      >> Your SQL Server installation is either corrupt or has been tampered with

      >> (Error getting instance ID from name.). Please uninstall and then re-run

      >> setup to correct this problem.

      >> OK, so how do I go about uninstalling an instance? I don't need to

      >> install the entire product do I? Oh, please, please say no!!!

      >> Thanks for your advice!

      >> - Joe Geretz -

      >

      #2; Sun, 01 Jun 2008 23:58:00 GMT
    • The setup program has an option to fix the registry entries for you. Also, uninstalling is like any

      application.

      --

      Tibor Karaszi, SQL Server MVP

      http://www.karaszi.com/sqlserver/default.asp

      http://www.solidqualitylearning.com/

      "Joseph Geretz" <jgeretz.sqlserver.todaysummary.com.nospam.com> wrote in message news:ekiA6vKFHHA.1816.sqlserver.todaysummary.com.TK2MSFTNGP06.phx.gbl...

      > Hi Immy,

      > Are you saying there's no documented procedure for uninstalling an instance? I'd much rather

      > completely uninstall and reinstall SQL SErver 2005 than mess around with the Registry. But I'm

      > hoping I won't have to.

      > Thanks,

      > Joe Geretz

      > "Immy" <therealasianbabe.sqlserver.todaysummary.com.hotmail.com> wrote in message

      > news:OGNrc$GFHHA.4080.sqlserver.todaysummary.com.TK2MSFTNGP02.phx.gbl...

      >> Hmmm - sounds to me your registry is screwed!

      >> You could try this (at your own risk) before you go down the route of reinstalling.

      >> http://support.microsoft.com/default.aspx?scid=kb;en-us;290301

      >> Immy

      >> "Joseph Geretz" <jgeretz.sqlserver.todaysummary.com.nospam.com> wrote in message

      >> news:OeVQHNBFHHA.3304.sqlserver.todaysummary.com.TK2MSFTNGP05.phx.gbl...

      >> SQL Server 2005 (running side by side with SQL Server 2000). The problem is with one of my SQL

      >> Server 2005 instances.

      >> I suffered a power loss. Now, I can't connect to one of my installed instances via Enterprise

      >> Manager and I can't start the service directly either via the Services applet. The full error

      >> message is:

      >> Your SQL Server installation is either corrupt or has been tampered with (Error getting instance

      >> ID from name.). Please uninstall and then re-run setup to correct this problem.

      >> OK, so how do I go about uninstalling an instance? I don't need to install the entire product do

      >> I? Oh, please, please say no!!!

      >> Thanks for your advice!

      >> - Joe Geretz -

      >>

      >

      #3; Sun, 01 Jun 2008 23:59:00 GMT
    • I was unable to uninstall the instance because the uninstall program didn't

      show that instance. I searched my registry for all occurrences of the

      instance name (stuff showed up like MSSQL$TENX) and deleted them. The

      service is gone, no more errors on startup and Enterprise Manager no longer

      shows the instance.

      Problem solved, thanks for all your advice.

      - Joseph Geretz -

      "Tibor Karaszi" <tibor_please.no.email_karaszi.sqlserver.todaysummary.com.hotmail.nomail.com> wrote in

      message news:e6dhjfMFHHA.4768.sqlserver.todaysummary.com.TK2MSFTNGP05.phx.gbl...

      > The setup program has an option to fix the registry entries for you. Also,

      > uninstalling is like any application.

      > --

      > Tibor Karaszi, SQL Server MVP

      > http://www.karaszi.com/sqlserver/default.asp

      > http://www.solidqualitylearning.com/

      >

      > "Joseph Geretz" <jgeretz.sqlserver.todaysummary.com.nospam.com> wrote in message

      > news:ekiA6vKFHHA.1816.sqlserver.todaysummary.com.TK2MSFTNGP06.phx.gbl...

      >> Hi Immy,

      >> Are you saying there's no documented procedure for uninstalling an

      >> instance? I'd much rather completely uninstall and reinstall SQL SErver

      >> 2005 than mess around with the Registry. But I'm hoping I won't have to.

      >> Thanks,

      >> Joe Geretz

      >> "Immy" <therealasianbabe.sqlserver.todaysummary.com.hotmail.com> wrote in message

      >> news:OGNrc$GFHHA.4080.sqlserver.todaysummary.com.TK2MSFTNGP02.phx.gbl...

      >> Hmmm - sounds to me your registry is screwed!

      >> You could try this (at your own risk) before you go down the route of

      >> reinstalling.

      >> http://support.microsoft.com/default.aspx?scid=kb;en-us;290301

      >> Immy

      >> "Joseph Geretz" <jgeretz.sqlserver.todaysummary.com.nospam.com> wrote in message

      >> news:OeVQHNBFHHA.3304.sqlserver.todaysummary.com.TK2MSFTNGP05.phx.gbl...

      >> SQL Server 2005 (running side by side with SQL Server 2000). The

      >> problem is with one of my SQL Server 2005 instances.

      >> I suffered a power loss. Now, I can't connect to one of my installed

      >> instances via Enterprise Manager and I can't start the service directly

      >> either via the Services applet. The full error message is:

      >> Your SQL Server installation is either corrupt or has been tampered

      >> with (Error getting instance ID from name.). Please uninstall and then

      >> re-run setup to correct this problem.

      >> OK, so how do I go about uninstalling an instance? I don't need to

      >> install the entire product do I? Oh, please, please say no!!!

      >> Thanks for your advice!

      >> - Joe Geretz -

      >>

      >>

      >

      #4; Mon, 02 Jun 2008 00:00:00 GMT