ReneeC


I have a real installation mess n my hands. I'm attempting to install Sql Server Developer edition on a new Thinkpad with Vista Ultimate. There are no issues with limited resources. This copy of Vista Ultimate came with a trial copy of Office 2007 and SQLExpress was intalled with it. I unistalled SQLExpress being unaware of the Vista Compatibility problems. SQL Developer did not install after I removed SQLE. After researching this on the net, I read that developer could be installed as an upgrade if SQLE is on the system. So Installed SQLE with advanced tools deliberately not installing the tools. That installation went well. So then I tried to reinstall SQL Developer and received a message about having to setup via command line because of an exisiting instance. So I installed Developer with the folowing command line from an MSDN DVD.

E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x86\Servers>start /wait setup.exe ADDLOC
AL=SQL_Engine INSTANCENAME=MHASQLE UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

I chose the advanced options specifiying that the tools be installed. That installation failed to install the tools and I believe there was an error in the core data engine installation. I received an error message to check the logs but to be honest, there are meagbytes of log files and I don't really know what to check.

The core log looked like this:

Microsoft SQL Server 2005 Setup beginning at Mon Oct 29 11:11:04 2007
Process ID : 4816
E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x86\Servers\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/9/29 11:11:3
Complete: LoadResourcesAction at: 2007/9/29 11:11:3, returned true
Running: ParseBootstrapOptionsAction at: 2007/9/29 11:11:3
Loaded DLL:E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x86\Servers\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/9/29 11:11:4, returned true
Running: ValidateWinNTAction at: 2007/9/29 11:11:4
Complete: ValidateWinNTAction at: 2007/9/29 11:11:4, returned true
Running: ValidateMinOSAction at: 2007/9/29 11:11:4
Complete: ValidateMinOSAction at: 2007/9/29 11:11:4, returned true
Running: PerformSCCAction at: 2007/9/29 11:11:4
Complete: PerformSCCAction at: 2007/9/29 11:11:4, returned true
Running: ActivateLoggingAction at: 2007/9/29 11:11:4
Complete: ActivateLoggingAction at: 2007/9/29 11:11:4, returned true
Running: DetectPatchedBootstrapAction at: 2007/9/29 11:11:4
Complete: DetectPatchedBootstrapAction at: 2007/9/29 11:11:4, returned true
Running: LaunchPatchedBootstrapAction at: 2007/9/29 11:11:4
Error: Action "LaunchPatchedBootstrapAction" threw an exception during execution. Error information reported during run:
"c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 1706
Aborting queue processing as nested installer has completed
Message pump returning: 1706

I believe residual office files are throwing the installation off but that could be an erroneous conclusion as the OWC portion always fails with a 1706.

What I need is basic SQL functionality and it's really important that I have the Studio Management Console.

Does anyone have any suggestions as to what log to check toward getting a core data engine installed along with the olls and documentation for SQL Developer





Re: Difficulty in Installing SQL Developer on Vista Ultimate

Vidhya Sagar


In the link below developer edition is not supported on vista

http://www.microsoft.com/sql/editions/developer/sysreqs.mspx

But With respect to the below link, Developer can be installed on vista with service pack 2

http://technet.microsoft.com/hi-in/library/ms143506.aspx

Im not sure whether developer edition can be installed on windows vista, both the links are from microsoft.







Re: Difficulty in Installing SQL Developer on Vista Ultimate

ReneeC

I've encountered these contradicitions myself. I have no idea what it means that i can apply a service pack to a product that I cannot install to begin with.

If you read other threads here, there is every indication that it can be installed. I just don't know how







Re: Difficulty in Installing SQL Developer on Vista Ultimate

Vidhya Sagar

Try this link http://www.webservertalk.com/archive132-2005-12-1331825.html, this may help you.






Re: Difficulty in Installing SQL Developer on Vista Ultimate

ReneeC

Vidya,

This really doesn't descibe what I've going through. Your link involved someone who was trying to make Developer and SQLE co-exist. I've said pretty clearly the I removed SQLE and then read that Developer would upgrade over top of SQLE.

My current question is, how can i clean up the current installation to eliminate all of the SQL so i can attmpt to re-install Developer.






Re: Difficulty in Installing SQL Developer on Vista Ultimate

Deepak Rangarajan

Can you try uninstalling Sql express completely from registry and then give a try with installing developer edition ! pls refer the link for the same, http://support.microsoft.com/kb/909967 which is applicable to sql 2005 express also.

Regards
Deepak





Re: Difficulty in Installing SQL Developer on Vista Ultimate

ReneeC

will do right away! Thank you!!!




Re: Difficulty in Installing SQL Developer on Vista Ultimate

ReneeC

I think this story may have a happy ending.

Your KB article was a good start. But they always have a problem which is that they are done in almost laboratory conditions and by the time you get to the middle something strange always becomes critical path. For example in my case, when i got to the part about the support files, the control panel showed that they were installed but there were really no files there. The MSI file in install responded with, "it's already installed" and when I attempted a repair wit the MSI file the message was, "It's not installed." Those things always happen. There were no GUID entries in the registry like the article said there would be. This set of conditions, here is what I did: (It was crude)

1.) Being a new system there was no data to preserve. So I didn't have to worry about data preservation.

2.) There were a couple of SQL services that I could not stop with any utility.

3.) I deleted all files in the Program Files\SQLxxxx directories. This worked except for the running service.

4.) I searched the registry and removed every registry entry with SQL in it and every root having SQL in it was deleted.

5.) I rebooted and the services did not restart and was able to delete all remaing files.

I was then able to fully install the dataengine, documentation and Tools in developer 2005. There were some hiccups.

The was a failure on the domain helper but I'm not in a domain at all.

At one point, the installer actually failed but the installation continued and that really surprised me.

I am very appreciative to you for your help and sad that I had to use such brute force tactics with this system. But right now it appears to be working and i am downloading SP2 at the moment.

I just tested things out and the Management Studio Console connects beautifully to the server.

Again, thank you.






Re: Difficulty in Installing SQL Developer on Vista Ultimate

ReneeC

SP2 went in fine !