Stuck with a SQL2005 installation

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

Stuck with a SQL2005 installation

Author

Topic

Jim77
Constraint Violating Yak Guru

440 Posts

Posted - 2007-08-07 : 07:59:52

Hi there guys I am hitting my head against a brick wall trying to install SQL 2000 and SQL 2005 side by side and wonder if someone has a suggestion that may help please.

My operating system is win xp 32 bit, I have recently purchased this machine and it came with office 2007 already pre installed which comes with a named instance version of sql 2005 business contact manager, I then installed a default instance of sql 2000 (with SP 4)client tools and the server with no problem , I then purchased a cd of Microsoft SQL Server 2005 Standard Edition (32-Bit)for me to install to run alongside the 2000 version that is currently running on the same machine when all hell broke loose.

I selected the option saying install server components, tools , books online etc etc.

I agree to the licence agreement

Setup then installs Microsoft SQL Server 2005 Setup support Files succesfully, I press next...

Welcome to the Microsoft SQL Server installation wizard then comes up, I press next

System Configuration check brings back 14 successsful status messages and one warning message namely Edition Change Check warning
saying :

quote:
Edition Change Check (Warning)
Messages
Edition Change Check

To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter

.

I ignore above and press Next..

It then comes up with registration information which i succesfully complete, pressing Next

I then select all the components to install and press next

I then set it up to be a named instance 'MSSQL2005DATA', fine >> pressed next

Then I set it up to run under the local system account , fine. >> pressed next.

Then using windows authentication mode pressed next >>

Left collation settings as per default pressed next >>

Install the default configuration in the report server installation options message box, I pressed next >> which then comes up with the following message :

(SQL Server Setup failed to obtain system account information for the ASPNET account.To proceed, reinstall the .net framework and then run SQL server Setup again)

i don't have a copy of the .net framework so I select the install but do not configure the server option.

Setup then comes up with Ready to install message box which i then press the install button, which shows the following:

Setup Progress Files Status:
SQL SETUP Support Setup Finished

OWC11 Setup failed, Refer to log

coming up with a error:

ERROR 1706 Setup cannot find the required files,Check your connection to the network, or cd rom, For other potential solutions to this problem, see c:\Program Files\Microsoft Office\Office11\1033\Setup.chm

I then press ok

and the setup progress fails to install :

OWC11
SQL SErver Database Services
Analysis Services
Reporting Services
Notification Services
Integration Services
Workstation Components

but I can't view any of these log files the only one that is available to view is sqlsetup0014_PCName_OWC11_1.log which comes up with the same message

MSI (s) (78:48) [12:44:04:581]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (78:48) [12:44:04:581]: Note: 1: 1706 2: -2147483647 3: OWC11.MSI
MSI (s) (78:48) [12:44:04:581]: SOURCEMGMT: Processing URL source list.
MSI (s) (78:48) [12:44:04:581]: Note: 1: 1402 2: UNKNOWN\URL 3: 2
MSI (s) (78:48) [12:44:04:581]: Note: 1: 1706 2: -2147483647 3: OWC11.MSI
MSI (s) (78:48) [12:44:04:581]: Note: 1: 1706 2: 3: OWC11.MSI
MSI (s) (78:48) [12:44:04:581]: SOURCEMGMT: Failed to resolve source
MSI (s) (78:48) [12:49:43:192]: Product: Microsoft Office 2003 Web Components -- Error 1706. Setup cannot find the required files. Check your connection to the network, or CD-ROM drive. For other potential solutions to this problem, see C:\Program Files\Microsoft Office\OFFICE11\1033\SETUP.CHM.

Error 1706. Setup cannot find the required files. Check your connection to the network, or CD-ROM drive. For other potential solutions to this problem, see C:\Program Files\Microsoft Office\OFFICE11\1033\SETUP.CHM.

I have tried installing office 2003 to get the 0wc11.dll but to no avail it still gives me the same error..

Sorry this is a long winded post but can anyone shed a ray of light here.

Thank you.

Jim77
Constraint Violating Yak Guru

440 Posts

Posted - 2007-08-07 : 10:29:19

I got it to work eventually it seemed I had to reinstall office 2003 web components and then

OWC11 installed succesfully and had a chain reaction on the rest of the setup which were all succesful, I dont understand why I need office 2003 web components when i am running office 2007 though !

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-08-07 : 11:06:59

sql server uses it for graphs.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

Jim77
Constraint Violating Yak Guru

440 Posts

Posted - 2007-08-07 : 11:33:45

I must of overlooked that part in the SQL 2005 pre-requisites document thanks Spirit1, that means I got to have office 2003 web components on all my 2005 servers should i choose to migrate ? thats a bit of a drawback.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-08-07 : 11:53:56

no you don't. they get installed by SS if you don't have them
with you they probably wanted to change a 2007's dll or something and failed... only MS knows

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

D Mac
Starting Member

1 Post

Posted - 2007-08-11 : 14:25:24

SQL Server 2005 Developer Install Failure

I got the required SQL Service Pack 2 and installed
it. I too am having difficulty w/OWC11 install which
is resulting in multiple install failures of the SQL
Server 2005 Developer on Vista Business.

Is the required C:\Program Files\Microsoft OfficeOFFICE11\1033\setup.chm available as a stand alone
file? or is it more involved to make this thing sprout
wings and fly?

Thx for your consideration

David MacCormick

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-08-11 : 14:41:27

you can download owc11.exe install from MS homepage somewhere

i don't know how that behaves on vista though-

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2008-03-13 : 22:47:53

This thread just helped me, I was installing SQL 2005 on my new lappy, so I googled...

Thanks Mladen, the owc11 install did the trick, even on Vista!

Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-03-14 : 06:27:34

excellent! glad it helped!

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources