Install And Uninstall Problem

I am having very simular problems with installation and uninstallation as Laydee is having.

There had never been another instance of any type installed on my local computer, I installed SQLExpress because we want to begin migrating to something for the future, and after reviewing all the other options out there decided SQL Server 2005 would be the most efficient use of time and resources.

The initial installation was successful, and we were doing well, writing the new GUI in VB6, then decided we would try VB 2005 in order to take advantage of the .NET framework, stored queries, etc. the first time we accessed the database (Thank God it wasn't the production database) it corrupted something, somewhere and we never could get anything to work. In addition, even the sa login on the instance (the only instance, btw) SQLExpress wouldn't work.

Consequently did an uninstall. But it apparently did not uninstall cleanly.

Re-installed, and could not re-create the instance SQLExpress, since the installation package thinks it's still installed.

Uninstalled again, completely. Online E-Book, sample databases, the whole 9 yards. Even went into the program files directory and deleted the associated directory, and did a re-install. Still was unable to create the named instance SQLExpress. same problem, it thinks that instance already exist.

Uninstalled again, deleted the directory, even went through the registry with a fine toothed comb getting rid of anything that appeared to refer to that instance (SQLExpress), which is no easy task since that instance is also the name of the software package. Re-installed. Same game.

We are about to the point of giving up since we have spent so much time just on trying to get the engine installed again properly that we are considering other, apparently more reliable options. To bad. We already bought SQL Server 2005, and it appears it will be sitting in the vault unopened. If something is this unstable we can't risk installing it on the production systems.

So before I have to declare this whole debacle a total loss, anyone have any suggestions?

 

 

View Replies


ADVERTISEMENT

Cannot Install Or Uninstall Anything After Uninstall SQL Server Express In A &&"wrong&&" Order

 
My computer is a Dell Optiplex with 3G Hz CPU, 3G memory and Windows XP SP2.
 
First the computer adminstrator installed a Visual Basic 2005 Express which worked well. Then he installed a SQL Server Express but seemed not working well. So he uninstalled it and try to reinstall. But he did not use the official Visua Studio 2005 "uninstall" tool nor uninstall it in the "correct" order (understandable because he is not our DBA). Then we can never reinstall SQL express.
 
Finally I was granted administrator priviledge and tried to reinstall SQL Express for seveal times but always failed. I uninstalled VB Express and .Net Framework 2.0 (with some failure messages but finally they were gone). Then I cannot uninstall any software. For example, I cannot uninstall seemingly trivial software like VB101SampesAll or SQL Server 2000 Books Online. I cannot install VB Express, .Net Framawork or any other downloaded Microsoft software. Mostly the error code is 29527.
 
Any thoughts? Thanks in advance.

View Replies View Related

Uninstall/Install

Hi,

I am wondering if I am going to encounter any problems when I uninstall SQL Server 2005 standard edition and install SQL Server 2005 Express Edition.

I am asking this as I found out today that a project I am developing (have been working on this for a few weeks now) that we're to be using Express edition. I am just hoping that I'm not going to come across any problems by doing this?

View Replies View Related

Install/uninstall Problem

I can't install SQL Server 2005 Express. The installer complains that there are beta components left on my system. I probably did something wrong during the uninstall of the beta. Now I'm lost as how to proceed to get the Express Edition installed. I have tried the cleanup program available on MS web without success. Anyone that have any ideas as how to identify what components that haven't been uninstalled properly, and then how to remove these manually???
/Raymond

View Replies View Related

Should I Uninstall MSDE And Install Developer Edition?

I know people have put up this question before but I wanted some updated feedback.
I just bought Visual Studio Tools for MS Office and it comes with SQL Developer Edition. I am currently using VS.net 2003 and using MSDE with MS SQL Web Data Administrator to build my dbs then export the sql script.
I was wondering if I should uninstall the MSDE and install the DEv Ed so I can develop all the triggers, constraints etc through Enterprise Manager, therefore having a better setup DB. I know you can do all that through code but why reinvent the wheel.
One last question, with the Dev Ed you just export the schema and scripts to a machine with SQL Server installed once the DB is ready for deployment ? Is this correct?
I lied one more question, does the uninstall of MSDE leave much of a mess, what is the best way to get rid of it.
Thanks in advance
Pete

View Replies View Related

Cannot Install SQL Server 2005 After Running Uninstall

After going through "Add and Remove Programs" and removing all components of SQL Server 2005 Standard Edition on my desktop I get an error telling me there is a copy already installed and to remove it before continuing. Well nothing shows up under "Add and Remove Programs"; Windows cleanup shows none of the SQL Server components; a check of the register (HOTKEYS.../unistall) have no SQL Server entries; under services all SQL Server services are disabled and not running.
 
I have followed all the steps in http://support.microsoft.com/kb/909967 (Describes how to uninstall an instance of SQL Server 2005 manually).
 
Anyone out there got a solution? (Visual Studio 2005 eval is loaded on the box)

View Replies View Related

SQL 2005 Uninstall/Install Problem WMI Configuration Related

Hi,

I'm the following encountering WMI error message when invoking SQL2005 setup.

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine CAPRICORN Error:2147942405 (0x80070005).

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=70342


I'ver found other postings related to WMI errors and tried the WMI fix batch, but to no avail. I noted the error code I have is 2147942405 which is different from other postings. And from examining setup log generated, this seems to be security related, but cannot find much help combing thru msdn/google, etc

Any help is greatly appreciated.

-James Lin

SCC LOG

================================================================

SCCOpenPerformer Added machine: CAPRICORN
RegisterAddCheckArticleCallbackFunction registered callback function

Calling add article callback function for article: WMIServiceWin32OSWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceWin32OSWorking
Article type: 4, ARTICLE_WMI_TYPE_VALUES
Number of value: 2
Value: 1
Type: ARTICLE_WMI_TYPE_PROPERTY
Namespace: cimv2
Class name: Win32_OperatingSystem
Property name: OSLanguage
Property type: 2
Value: 2
Type: ARTICLE_WMI_TYPE_PROPERTY
Namespace: cimv2
Class name: Win32_OperatingSystem
Property name: SystemDirectory
Property type: 2

Calling add article callback function for article: WMIServiceWin32CompSystemWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceWin32CompSystemWorking
Article type: 4, ARTICLE_WMI_TYPE_VALUES
Number of value: 1
Value: 1
Type: ARTICLE_WMI_TYPE_PROPERTY
Namespace: cimv2
Class name: Win32_ComputerSystem
Property name: NumberOfProcessors
Property type: 2

Calling add article callback function for article: WMIServiceWin32ProcessorWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceWin32ProcessorWorking
Article type: 4, ARTICLE_WMI_TYPE_VALUES
Number of value: 1
Value: 1
Type: ARTICLE_WMI_TYPE_PROPERTY
Namespace: cimv2
Class name: Win32_Processor
Property name: CpuStatus
Property type: 2

Calling add article callback function for article: WMIServiceReadRegWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceReadRegWorking
Article type: 4, ARTICLE_WMI_TYPE_VALUES
Number of value: 1
Value: 1
Type: ARTICLE_WMI_TYPE_REGISTRY
DefKey: 0x80000002
Subkey name: SOFTWAREMicrosoftWindowsCurrentVersion
Value name: ProgramFilesDir
Registry type: 4

Calling add article callback function for article: WMIServiceWin32DirectoryWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceWin32DirectoryWorking
Article type: 3, ARTICLE_WMI_TYPE_CLASS
Namespace: cimv2
WQL Query: Select * from Win32_Directory where name='C:\'

Calling add article callback function for article: WMIServiceCIMDataWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceCIMDataWorking
Article type: 3, ARTICLE_WMI_TYPE_CLASS
Namespace: cimv2
WQL Query: Select * from CIM_DataFile where name='C:\'

Calling add article callback function for article: XMLDomDocument
Callback function returned TRUE
Adding Article...
Article Id: XMLDomDocument
Article type: 1, ARTICLE_TYPE_GENERIC_FUNCTION
RegisterCallbackFunction registered callback function
Callback filter = 0x6

Performing check on local machine CAPRICORN
Connecting to CAPRICORN machine
ConnectServer returned 0 (0x0)
ConnectServer returned 0 (0x0)
Openning namespace \rootcimv2
GetNamespace \rootcimv2 returned 0 (0x0)
Creating class instance Win32_ComputerSystem
CreateInstanceEnum Win32_ComputerSystem returned 0 (0x0)
Enumerating the first class of Win32_ComputerSystem
EnumClass of Win32_ComputerSystem returned 2147942405 (0x80070005)
Creating class instance Win32_OperatingSystem
CreateInstanceEnum Win32_OperatingSystem returned 0 (0x0)
Enumerating the first class of Win32_OperatingSystem
EnumClass of Win32_OperatingSystem returned 2147942405 (0x80070005)
Creating class instance Win32_OperatingSystem
CreateInstanceEnum Win32_OperatingSystem returned 0 (0x0)
Enumerating the first class of Win32_OperatingSystem
EnumClass of Win32_OperatingSystem returned 2147942405 (0x80070005)
Creating class instance Win32_Processor
CreateInstanceEnum Win32_Processor returned 0 (0x0)
Enumerating the first class of Win32_Processor
EnumClass of Win32_Processor returned 2147942405 (0x80070005)
Openning namespace \rootdefault
GetNamespace \rootdefault returned 0 (0x0)
Getting method EnumValues in StdRegProv class
GetMethod returned 0 (0x0)
Executing method EnumValues in StdRegProv class
ExecMethod returned 2147942405 (0x80070005)

Processing article WMIServiceWin32OSWorking
Scc Error:  50026 (0xc36a)
Error code: 2147942405 (0x80070005)
Calling callback function for reason: 0x2
Callback function returned TRUE

Processing article WMIServiceWin32CompSystemWorking
Scc Error:  50026 (0xc36a)
Error code: 2147942405 (0x80070005)
Calling callback function for reason: 0x2
Callback function returned TRUE

Processing article WMIServiceWin32ProcessorWorking
Scc Error:  50026 (0xc36a)
Error code: 2147942405 (0x80070005)
Calling callback function for reason: 0x2
Callback function returned TRUE

Processing article WMIServiceReadRegWorking
Scc Error:  50024 (0xc368)
Error code: 2147942405 (0x80070005)
Calling callback function for reason: 0x2
Callback function returned TRUE

Processing article WMIServiceWin32DirectoryWorking
Openning namespace \rootcimv2
GetNamespace \rootcimv2 returned 0 (0x0)
Scc Error:  50022 (0xc366)
Error code: 70347 (0x112cb)
Calling callback function for reason: 0x2
Callback function returned TRUE

Processing article WMIServiceCIMDataWorking
Openning namespace \rootcimv2
GetNamespace \rootcimv2 returned 0 (0x0)
Scc Error:  50022 (0xc366)
Error code: 70347 (0x112cb)
Calling callback function for reason: 0x2
Callback function returned TRUE

Processing article XMLDomDocument
Scc Error:  0 (0x0)
Error code: 0 (0x0)
Calling callback function for reason: 0x4
Callback function returned TRUE
SccPerformer closed.


 

View Replies View Related

WMI Error (not Install/uninstall -- Performance Monitor Derived Class)

Trying to use WMI to monitor a SQLExpress DB and not getting anywhere.  In fact, wmiprvse.exe croaks.

Here's the query I'm running from within CIM Studio:
select * from Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSDatabases

(Just did a search for SQL and found this class)

When trying to get an instance, WMIPRVSE throws this exception:
The exception unknown software exception (0xc000000d) occurred int he application at location 0x7814454d.

Ok to that, then another msgBox shows up  with a title of

"Multiview Message" and text as below:
Win32: The remote procedure call failed.
An error occurred while attempting to retrieve the list of objects.

Any suggestions on this would be appreciated.  Or perhaps another WMI class to use?

(XP Pro SP2, current with the patches; SQLExpress and MSDE both running)

thanks

View Replies View Related

Can't Uninstall SQL Server 2005 Or Install .NET 3.0 64bit After Installing Office 2007

Well I had no response on the 64bit NET forum so I am posting here !!

Windows Automatic Update has just failed to install .NET 3.0 (x64)
WAU decided for itself that I needed this update

Add Remove Programs reports the following (x64) programs ...
.NET Framework 2.0
.NET Framework 2.0 SDK
MS SQL SERVER 2005
VS2005 64bit prerequisites
VS2005 64bit Remote Debugger

MSinfo32 reports
OS Name Microsoft(R) Windows(R) Server 2003 Standard x64 Edition
Version 5.2.3790 Service Pack 2 Build 3790
Other OS Description R2
OS Manufacturer Microsoft Corporation
System Name DEV-1
System Manufacturer Dell Inc.
System Model Dell DXC051
System Type x64-based PC
Processor EM64T Family 15 Model 6 Stepping 4 GenuineIntel ~3392 Mhz
Processor EM64T Family 15 Model 6 Stepping 4 GenuineIntel ~3392 Mhz
BIOS Version/Date Dell Inc. A05, 31/03/2006

BTW this is a fresh install because I was completely and utterly unable to uninstall SqlServer2005 which was necessitated by foolishly installing Office 2007 (Office 2003 being no longer available!)

View Replies View Related

Cannot Install SQL Srv 2005 Service Pack 2 (KB 921896) / Uninstall SQL Srv 2005

I tried to uninstall SQL Server 2005 and it was failed.

 

I tried to install SP2 for SQL Server 2005, and it was failed too!

Here are the log file SUMMARY.TXT (is it enough?).

Can anyone tell me what the problem is?

 

Time: 05/17/2007 16:51:41.483
KB Number: KB921896
Machine: XXXXXX
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
     /quiet
     /allinstances
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected                         Language  Level  Patch Level       Platform  Edition
Express Database Services (SQLEXPRESS)    ENU       RTM    2005.090.1399.00  x86       EXPRESS

**********************************************************************************
Products Disqualified & Reason
Product                                   Reason

**********************************************************************************
Processes Locking Files
Process Name          Feature               Type          User Name                  PID

**********************************************************************************
Product Installation Status
Product                   : Express Database Services (SQLEXPRESS)
Product Version (Previous): 1399
Product Version (Final)   :
Status                    : Failure
Log File                  : D:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9Express_Hotfix_KB921896_SQLEXPR.EXE
SQL Express Features      : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
Error Number              : 1332
Error Description         : *** Shared String ID 1332 Not Found ***
----------------------------------------------------------------------------------

**********************************************************************************
Summary
     One or more products failed to install, see above for details
     Exit Code Returned: 1332

View Replies View Related

If Your SQL Server Uninstall File Is Corrupt, How To Uninstall ?

Hi everyone,

Can any one let me know if SQL Server 7.0 Uninstall file(Uninst.isu) is corrupted, How do you Uninstall SQL Server 7.0

I had installed Destktop version of sql server 7.0 on Windows 98.

Please let me know, if anyone has Solution.

Cheers
Hemant

View Replies View Related

Uninstall SqlExpress Instance When Uninstall My Application

Hi,
My application setup install the application and also a named instance of sqlexpress.
I would, when user uninstall my application, uninstall also the named instance of sqlexpress programmatically.
 
I try with an uninstall custom action with:
 
msiexec /x <Product code>
 
where <Product code> is the product code of my sqlexpress named instance found in the registry.
 
this give me error because only one msi can be execute at time.
 
There are solutions for this problem?
 
Thank you very much.
Andrea
 

View Replies View Related

Standard Edition Fails To Install, Express Edition Fails To Uninstall

We are trying to install the Standard Edition of SQL Server 2005. We already have SQL Express installed. Standard won't install and Express won't uninstall.

We have tried every suggestion we can find and some we made up. When we try to install Standard, we get to the bit where you choose what you want to install and the only thing available is workstation components.

There are so many cases of this on the Internat that I can't believe MS have not solved the issue. And I am stunned that they want to charge us more money to talk to us about how to fix something we just paid them an arm and a leg for!

What do I need to tell you to get some idea of where to go next with this?

View Replies View Related

Sql Sp 4 Uninstall?

Is there any way to uninstall SQL sp4 or sp5 after they have been installed on SQL Server 6.5 sp3/NT 4.0 sp3?
Thanks,
Doug Brown

View Replies View Related

Uninstall SQL 7.0

Hello!
I tried to uninstall SQL Server 7.0.
And I have got error message:
" uninstallShieid has detected that c:mssql7Binnsqlmangr.exe in
use. please close the application using this file and launch
uninstallShield again."
I closed all aplications and I stopped all services at SQL Server
Service Manager. Somebody knows what else uninstallShield programm
wants me to do?.
Thank you,
Alona

View Replies View Related

SP2 Uninstall????

Hi,

I'm using SQL Server 7.0.

Does anyone know how to uninstall SP2?

Thanks,
Darrin

View Replies View Related

SQL 7 Uninstall HELP!!!

Hello,

I need some space on my machine. I have SQL 7 on it, and I want to completely remove it from my system. I have done the following:

1. Used the SQL Uninstall to uninstall
2. Removed MSSQL7 folder using win explorer
3. MSSQL folder in (HKEY_LOCALMACHINESOFTWAREMICROSOFTMSSQL7)
4. Rebooted the machine

Yet I see traces of SQL7 on my machine! When I tried to reinstall, it told me that there was a license already on the machine.

What do I need to do to completely wipe it out?

View Replies View Related

How To Uninstall Sql 6.5

How do I completely unistall sql6.5 on a NT 4 server without getting any problems. I wish to install sql7. I do not need to upgrade any databases
thanks
Pete

View Replies View Related

Uninstall SQL Express

I mistakenly installed SQL express using remote desktop, now I cannot do anything in it. Nobody could help with that either but based on posts with the same message, I tried uninstalling sql server. It wouldn't uninstall nor can I repair or reinstall. Uninstalling thru Add or Remove Programs only resulted in the program listing being removed from Add or Remove Programs. Most of the sql server programs are still installed. They can be run but continue to malfunction. When I try a new installation, I get a message that the programs are already installed. How can I correct this without reinstalling Win XP? Please help. Your valuable feedback is greatly appreciated.

View Replies View Related

Uninstall Second Instance

Hello there!I have on a machine (named SV-ISDEV) two MSSQL instances installed. Thelocal and the SV-ISDEVPREPROD. Now I want to unistall the PREPRODinstance.Which is the correct way to do this?Do I have to run the installation again?Thanks

View Replies View Related

How Can I Uninstall MDAC

i need to uninstall MDAC from my system. my operating system is windows2000 proffessional.


pls help me.... its very urgent.....

View Replies View Related

Tried To Uninstall Replication

I had replication installed between my two SQL servers with no problems until I changed the Primary Key attribute on one of the replicating tables. After that one change, I continued to receive errors for one week about failed replication (due to this one table!). I tried removing Replication so that I could "reinstall" it, but my Publicating server will not show the option to 'Install Publishing..' in the Server Tool. I followed the advice found on "SWYNK.com/ch17.asp" as it stated:

"Uninstalling Replication Completely
Carefully consider all options before you opt to remove replication entirely from the system. This operation shuts down all replication to all subscribing servers, and it does so in a somewhat brute force manner by removing the replication option from the server and deleting the distribution database.

There are three steps for uninstalling replication in SQL Server, as follows:

1)Discontinue all replication services, all publication and subscription services, between this system and other servers with which it is working.
2)Turn off the replication option at the server engine level.
3)Drop the distribution database. "

I still cannot get the option to Install Publishing again. In fact, I continue to get the option to "Uninstall Publishing.." in the Server tool. I stopped/started services dozens of times with no luck. Any help would be great !!!!

View Replies View Related

Uninstall Publishing

Hello sir,

I want to install a replication, i still receive this message:
->2-If Replication is uninstalled, all publications will be
eliminated and the distribution database[if it exist]will be
dropped. After the process has completed, this session will be
disconnected from the SQL Server. Do you want to unistall
replication?

I don't understand why!!!
Advice me :((

View Replies View Related

How Do I Uninstall SQL Server 6.5??

Running version 6.5 on Windows 2000 and I am unable to find an obvious uninstall utility from the start menu or installation cd...can someone please inform me of how to do this?? Thanks!

View Replies View Related

How To Uninstall Sql 7.0 Clean

I have some problem in the unattended unsintall for SQL 7.0
with
isuninst.exe -fc:mssqluninst.isu

The other way to manual uninstall clean , as I read from this forum is :
1. delete the c:mssql7 directory
2. remove the entries for sql 7.0 in registry and reboot

But what are the registries created by the SQL 7.0 that have to be deleted ?
Is it the whole subtree
hkey_local_machinesoftwaremicrosoftmssqlserver ??

Any precaution ?
Thx. in advance.

View Replies View Related

SQL SP2 Uninstall Needed....

Hi,

Somehow, ignorantly, I managed to install SQL 7 SP2 on a computer that didn't have SQL 7 yet, only 6.5. Don't ask me how it allowed this,
but it did. In any case, now I have a problem. When I try to install SQL 7, it tells me I can't install an older version than what already exists,
and that I should uninstall it first. Well, I looked in the Control Panel, but there's no entry there to uninstall. I deleted all the SQL 7.0 keys I could
find in the registry, and still it refuses to install. Can anyone tell me just what the heck I have to delete in order to get SQL 7 to install on this
machine?

Thanks!

Joe

View Replies View Related

Uninstall Of 7.0 Leaving 6.5

I upgraded from SQL 6.5 to 7.0. Because I got a number of errors I went back
to 6.5. Now I want to try again to upgrade to 7.0. How can I do that?

Do I have to uninstall 7.0 and reinstall?

If I uninstall 7.0 will that blow away 6.5?

Thanks
JJ

View Replies View Related

Problem With Sql 6.5 Uninstall

hello

sql 7.0 was previously installed alongside sql 6.5 in the same directory. i now need to uninstall 6.5. microsoft cautions the following -

Caution If you are installing Microsoft® SQL Server™ version 7.0 alongside SQL Server 6.x on the same computer, do not install SQL Server 7.0 in the same directory as SQL Server 6.x.

will there be a problem if i try to use the standard uninstall utility for 6.5? what is the work around for this? please advise.

View Replies View Related

Forced Uninstall

I am not able to uninstall the trial version of MS SQL 7 from my desktop.
Can anyone tell me the procedure for a "forced uninstall"?

Thanks,

JW

View Replies View Related

Uninstall SQL 7.0 Beta

While trying to 'tidy up' I ran into this error when trying to ininstall an SQL 7.0 beta: 'Unable to locate the installation log file C:MSSQL7Uninst.isu Uninstall will not continue'.

Search confirms that such a file is not present. I would reinstall (with the final product) then try Uninstall again, but disk space prohibits this.

Ideas to get around this?

View Replies View Related

Uninstall Sqlexpress

Hi friends
I insalled Visual Studio 2005 standard edi on XP machine. as you all know it also installs sqlexpress. i want to uninstall this sqlexpress as i also have sql server 2005 standard edition on my machine.

but i dont see any option to uninstall in add/remove programs or in start menu for sqlexpress.
any ideas on this ?
Thanks for your help.

Cheers

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved