i am having a heck of a time -- i know SP2 makes sql server 2005
incompatiable... however, i need an instance INSTALLED first and that is
where the problem lies.
i of course built my system and put office on before visual studio - so
office put sql express on the system (which worked by the way) -- so i had to
uninstall sql express, because i wanted to use sql developer.
when i try to install sql developer it doesn't install owc , sql server or
the workstation tools.
how do I get sql installed on vista so i can continue working?
thanks
SandyHi Sandy
"Sandy Ryan" wrote:
> i am having a heck of a time -- i know SP2 makes sql server 2005
> incompatiable... however, i need an instance INSTALLED first and that is
> where the problem lies.
> i of course built my system and put office on before visual studio - so
> office put sql express on the system (which worked by the way) -- so i had to
> uninstall sql express, because i wanted to use sql developer.
> when i try to install sql developer it doesn't install owc , sql server or
> the workstation tools.
> how do I get sql installed on vista so i can continue working?
> thanks
> Sandy
Did you check what the readme says about Vista issues?
http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/ReadmeSQL2005SP2.htm#_windows_vista or the log files such as SQLSTP.log
John|||i did read this, but this relates to SP2 - not the base installation WHICH
has to be there before apply SP2 -- and that's what i'm having trouble with.
any clues?
"John Bell" wrote:
> Hi Sandy
> "Sandy Ryan" wrote:
> > i am having a heck of a time -- i know SP2 makes sql server 2005
> > incompatiable... however, i need an instance INSTALLED first and that is
> > where the problem lies.
> > i of course built my system and put office on before visual studio - so
> > office put sql express on the system (which worked by the way) -- so i had to
> > uninstall sql express, because i wanted to use sql developer.
> > when i try to install sql developer it doesn't install owc , sql server or
> > the workstation tools.
> > how do I get sql installed on vista so i can continue working?
> > thanks
> > Sandy
> Did you check what the readme says about Vista issues?
> http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/ReadmeSQL2005SP2.htm#_windows_vista or the log files such as SQLSTP.log
> John
>|||Hi Sandy
So what messages are you getting when it fails? What does SQLStp.log say?
John
"Sandy Ryan" wrote:
> i did read this, but this relates to SP2 - not the base installation WHICH
> has to be there before apply SP2 -- and that's what i'm having trouble with.
> any clues?
> "John Bell" wrote:
> > Hi Sandy
> >
> > "Sandy Ryan" wrote:
> >
> > > i am having a heck of a time -- i know SP2 makes sql server 2005
> > > incompatiable... however, i need an instance INSTALLED first and that is
> > > where the problem lies.
> > > i of course built my system and put office on before visual studio - so
> > > office put sql express on the system (which worked by the way) -- so i had to
> > > uninstall sql express, because i wanted to use sql developer.
> > > when i try to install sql developer it doesn't install owc , sql server or
> > > the workstation tools.
> > > how do I get sql installed on vista so i can continue working?
> > > thanks
> > > Sandy
> >
> > Did you check what the readme says about Vista issues?
> > http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/ReadmeSQL2005SP2.htm#_windows_vista or the log files such as SQLSTP.log
> >
> > John
> >
> >|||John
I searched my system and couldn't find the ssqlstp.log -
but the summary log says:
Microsoft SQL Server 2005 9.00.1399.06
==============================OS Version : Professional (Build 6000)
Time : Fri Feb 23 10:12:20 2007
Machine : SWTAB2
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLSupport_1.log
----
Machine : SWTAB2
Product : OWC11
Error : 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.
----
Machine : SWTAB2
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.8003.0
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_OWC11_1.log
Last Action : InstallExecute
Error String : 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 Number : 1706
----
Machine : SWTAB2
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_BackwardsCompat_1.log
----
Machine : SWTAB2
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLSupport_2.log
----
Machine : SWTAB2
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLNCLI_1.log
----
Machine : SWTAB2
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_BackwardsCompat_2.log
----
Machine : SWTAB2
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLSupport_3.log
----
Machine : SWTAB2
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLNCLI_2.log
----
Machine : SWTAB2
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_BackwardsCompat_3.log
----
Machine : SWTAB2
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLSupport_4.log
----
Machine : SWTAB2
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_BackwardsCompat_4.log
----
Machine : SWTAB2
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLSupport_5.log
----
Machine : SWTAB2
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLNCLI_3.log
----
Machine : SWTAB2
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SqlWriter_1.log
----
Machine : SWTAB2
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_BackwardsCompat_5.log
----
Machine : SWTAB2
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLSupport_6.log
----
Machine : SWTAB2
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLNCLI_4.log
----
Machine : SWTAB2
Product : Microsoft SQL Server 2005 Books Online (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_BOL_1.log
----
Machine : SWTAB2
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_BackwardsCompat_6.log
----
Machine : SWTAB2
Product : SQLXML4
Error : An installation package for the product SQLXML4 cannot be
found. Try the installation again using a valid copy of the installation
package 'sqlxml4.msi'.
----
Machine : SWTAB2
Product : SQLXML4
Product Version : 9.00.3042.00
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLXML4_1.log
Last Action : InstallFinalize
Error String : An installation package for the product SQLXML4 cannot be
found. Try the installation again using a valid copy of the installation
package 'sqlxml4.msi'.
Error Number : 1706
---
"John Bell" wrote:
> Hi Sandy
> So what messages are you getting when it fails? What does SQLStp.log say?
> John
> "Sandy Ryan" wrote:
> >
> > i did read this, but this relates to SP2 - not the base installation WHICH
> > has to be there before apply SP2 -- and that's what i'm having trouble with.
> >
> > any clues?
> >
> > "John Bell" wrote:
> >
> > > Hi Sandy
> > >
> > > "Sandy Ryan" wrote:
> > >
> > > > i am having a heck of a time -- i know SP2 makes sql server 2005
> > > > incompatiable... however, i need an instance INSTALLED first and that is
> > > > where the problem lies.
> > > > i of course built my system and put office on before visual studio - so
> > > > office put sql express on the system (which worked by the way) -- so i had to
> > > > uninstall sql express, because i wanted to use sql developer.
> > > > when i try to install sql developer it doesn't install owc , sql server or
> > > > the workstation tools.
> > > > how do I get sql installed on vista so i can continue working?
> > > > thanks
> > > > Sandy
> > >
> > > Did you check what the readme says about Vista issues?
> > > http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/ReadmeSQL2005SP2.htm#_windows_vista or the log files such as SQLSTP.log
> > >
> > > John
> > >
> > >|||also
all the path error messages - the files ARE There
"Sandy Ryan" wrote:
> John
> I searched my system and couldn't find the ssqlstp.log -
> but the summary log says:
> Microsoft SQL Server 2005 9.00.1399.06
> ==============================> OS Version : Professional (Build 6000)
> Time : Fri Feb 23 10:12:20 2007
> Machine : SWTAB2
> Product : Microsoft SQL Server Setup Support Files (English)
> Product Version : 9.00.1399.06
> Install : Successful
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLSupport_1.log
> ----
> Machine : SWTAB2
> Product : OWC11
> Error : 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.
> ----
> Machine : SWTAB2
> Product : Microsoft Office 2003 Web Components
> Product Version : 11.0.8003.0
> Install : Failed
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_OWC11_1.log
> Last Action : InstallExecute
> Error String : 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 Number : 1706
> ----
> Machine : SWTAB2
> Product : Microsoft SQL Server 2005 Backward compatibility
> Product Version : 8.05.1054
> Install : Successful
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_BackwardsCompat_1.log
> ----
> Machine : SWTAB2
> Product : Microsoft SQL Server Setup Support Files (English)
> Product Version : 9.00.1399.06
> Install : Successful
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLSupport_2.log
> ----
> Machine : SWTAB2
> Product : Microsoft SQL Server Native Client
> Product Version : 9.00.1399.06
> Install : Successful
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLNCLI_1.log
> ----
> Machine : SWTAB2
> Product : Microsoft SQL Server 2005 Backward compatibility
> Product Version : 8.05.1054
> Install : Successful
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_BackwardsCompat_2.log
> ----
> Machine : SWTAB2
> Product : Microsoft SQL Server Setup Support Files (English)
> Product Version : 9.00.1399.06
> Install : Successful
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLSupport_3.log
> ----
> Machine : SWTAB2
> Product : Microsoft SQL Server Native Client
> Product Version : 9.00.1399.06
> Install : Successful
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLNCLI_2.log
> ----
> Machine : SWTAB2
> Product : Microsoft SQL Server 2005 Backward compatibility
> Product Version : 8.05.1054
> Install : Successful
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_BackwardsCompat_3.log
> ----
> Machine : SWTAB2
> Product : Microsoft SQL Server Setup Support Files (English)
> Product Version : 9.00.1399.06
> Install : Successful
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLSupport_4.log
> ----
> Machine : SWTAB2
> Product : Microsoft SQL Server 2005 Backward compatibility
> Product Version : 8.05.1054
> Install : Successful
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_BackwardsCompat_4.log
> ----
> Machine : SWTAB2
> Product : Microsoft SQL Server Setup Support Files (English)
> Product Version : 9.00.1399.06
> Install : Successful
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLSupport_5.log
> ----
> Machine : SWTAB2
> Product : Microsoft SQL Server Native Client
> Product Version : 9.00.1399.06
> Install : Successful
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLNCLI_3.log
> ----
> Machine : SWTAB2
> Product : Microsoft SQL Server VSS Writer
> Product Version : 9.00.1399.06
> Install : Successful
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SqlWriter_1.log
> ----
> Machine : SWTAB2
> Product : Microsoft SQL Server 2005 Backward compatibility
> Product Version : 8.05.1054
> Install : Successful
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_BackwardsCompat_5.log
> ----
> Machine : SWTAB2
> Product : Microsoft SQL Server Setup Support Files (English)
> Product Version : 9.00.1399.06
> Install : Successful
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLSupport_6.log
> ----
> Machine : SWTAB2
> Product : Microsoft SQL Server Native Client
> Product Version : 9.00.1399.06
> Install : Successful
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLNCLI_4.log
> ----
> Machine : SWTAB2
> Product : Microsoft SQL Server 2005 Books Online (English)
> Product Version : 9.00.1399.06
> Install : Successful
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_BOL_1.log
> ----
> Machine : SWTAB2
> Product : Microsoft SQL Server 2005 Backward compatibility
> Product Version : 8.05.1054
> Install : Successful
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_BackwardsCompat_6.log
> ----
> Machine : SWTAB2
> Product : SQLXML4
> Error : An installation package for the product SQLXML4 cannot be
> found. Try the installation again using a valid copy of the installation
> package 'sqlxml4.msi'.
> ----
> Machine : SWTAB2
> Product : SQLXML4
> Product Version : 9.00.3042.00
> Install : Failed
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0001_SWTAB2_SQLXML4_1.log
> Last Action : InstallFinalize
> Error String : An installation package for the product SQLXML4 cannot be
> found. Try the installation again using a valid copy of the installation
> package 'sqlxml4.msi'.
> Error Number : 1706
> ---
> "John Bell" wrote:
> > Hi Sandy
> >
> > So what messages are you getting when it fails? What does SQLStp.log say?
> >
> > John
> >
> > "Sandy Ryan" wrote:
> >
> > >
> > > i did read this, but this relates to SP2 - not the base installation WHICH
> > > has to be there before apply SP2 -- and that's what i'm having trouble with.
> > >
> > > any clues?
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi Sandy
> > > >
> > > > "Sandy Ryan" wrote:
> > > >
> > > > > i am having a heck of a time -- i know SP2 makes sql server 2005
> > > > > incompatiable... however, i need an instance INSTALLED first and that is
> > > > > where the problem lies.
> > > > > i of course built my system and put office on before visual studio - so
> > > > > office put sql express on the system (which worked by the way) -- so i had to
> > > > > uninstall sql express, because i wanted to use sql developer.
> > > > > when i try to install sql developer it doesn't install owc , sql server or
> > > > > the workstation tools.
> > > > > how do I get sql installed on vista so i can continue working?
> > > > > thanks
> > > > > Sandy
> > > >
> > > > Did you check what the readme says about Vista issues?
> > > > http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/ReadmeSQL2005SP2.htm#_windows_vista or the log files such as SQLSTP.log
> > > >
> > > > John
> > > >
> > > >|||Hi
"Sandy Ryan" wrote:
> also
> all the path error messages - the files ARE There
>
Have you tried copying the CD to the local hard disc? Where did you get the
installation from? Is it corrupted?
John|||msdn subscription
i have it on the local machines cd - i'll try copying it over
"John Bell" wrote:
> Hi
> "Sandy Ryan" wrote:
> > also
> > all the path error messages - the files ARE There
> >
> Have you tried copying the CD to the local hard disc? Where did you get the
> installation from? Is it corrupted?
> John|||"Sandy Ryan" wrote:
> i am having a heck of a time -- i know SP2 makes sql server 2005
> incompatiable... however, i need an instance INSTALLED first and that is
> where the problem lies.
> i of course built my system and put office on before visual studio - so
> office put sql express on the system (which worked by the way) -- so i had to
> uninstall sql express, because i wanted to use sql developer.
> when i try to install sql developer it doesn't install owc , sql server or
> the workstation tools.
> how do I get sql installed on vista so i can continue working?
> thanks
> Sandy
I found the following similar problem and resolution. I am not sure if this
is exactly what you experienced, but it sounds close.
I installed:
-Vista Ultimate x64
-Sql Server 2005 Express Edition (via Visual Studio 2005 Pro)
At this point, Sql Express is installed, but NOT Management Studio. I then
tried to Install Sql Dev edition. I discovered that it was considered an
Upgrade from Sql Express. But the kicker: it would NOT install the
Workstation Tools because it thought it didnâ't qualify for an Upgrade! I
think this is a bug personally. Even though Sql Express was installed AND is
a valid upgrade path to Sql Dev, the problem is that it didnâ't see Management
Studio, and therefore assumed you donâ't have rights to install Dev edition
Workstation Tools (completely stupid).
Resolution:
-Go to Programs and Features
-Right Click Microsoft Sql Server 2005 and select Uninstall
-Check ONLY the box that says Workstation Tools (donâ't uninstall Sql Express
unless you donâ't want it)
-Click Next and finish the Uninstall of the Workstation Components
-Run setup for Sql Dev edition
Worked like a charm. I now have Sql 2005 Express and Sql Dev 2005 editions
running, and the Dev edition tools wherewith to manage them (and BTW, there
are reasons you want to keep Sql Express depending on what you are
developing). Apparently, Sql Dev edition has now been tricked into thinking
itâ's a clean install since the Express edition of the workstation tools were
removed (no longer an â'unsupported upgradeâ' scenario). It will therefore go
ahead with Dev edition Workstation tools, and Management Studio also gets
installed.
Tip: Remember to run SP2 for both Sql Express and Sql Dev at this point.
Also, I believe an alternative resolution is to simply install Sql Express
Management Studio after Sql Express (Visual Studio), and THEN run the Sql Dev
edition install, and it will in fact upgrade everything properly. I cannot
confirm this, but I recall having a conversation with a friend at Microsoft
who said that worked for him.
I hope this post helps some poor souls out there!
-David P.|||You helped out this poor soul.
Thanks David.|||David
Thanks for the information
Unfortuntately it didn't work, I'm still getting SQLXMK4; OWC11 and
Workstation errors so they don't install
any other thoughts?
thanks
Sandy
"David Pugmire" wrote:
>
> "Sandy Ryan" wrote:
> > i am having a heck of a time -- i know SP2 makes sql server 2005
> > incompatiable... however, i need an instance INSTALLED first and that is
> > where the problem lies.
> > i of course built my system and put office on before visual studio - so
> > office put sql express on the system (which worked by the way) -- so i had to
> > uninstall sql express, because i wanted to use sql developer.
> > when i try to install sql developer it doesn't install owc , sql server or
> > the workstation tools.
> > how do I get sql installed on vista so i can continue working?
> > thanks
> > Sandy
> I found the following similar problem and resolution. I am not sure if this
> is exactly what you experienced, but it sounds close.
> I installed:
> -Vista Ultimate x64
> -Sql Server 2005 Express Edition (via Visual Studio 2005 Pro)
> At this point, Sql Express is installed, but NOT Management Studio. I then
> tried to Install Sql Dev edition. I discovered that it was considered an
> Upgrade from Sql Express. But the kicker: it would NOT install the
> Workstation Tools because it thought it didnâ't qualify for an Upgrade! I
> think this is a bug personally. Even though Sql Express was installed AND is
> a valid upgrade path to Sql Dev, the problem is that it didnâ't see Management
> Studio, and therefore assumed you donâ't have rights to install Dev edition
> Workstation Tools (completely stupid).
> Resolution:
> -Go to Programs and Features
> -Right Click Microsoft Sql Server 2005 and select Uninstall
> -Check ONLY the box that says Workstation Tools (donâ't uninstall Sql Express
> unless you donâ't want it)
> -Click Next and finish the Uninstall of the Workstation Components
> -Run setup for Sql Dev edition
> Worked like a charm. I now have Sql 2005 Express and Sql Dev 2005 editions
> running, and the Dev edition tools wherewith to manage them (and BTW, there
> are reasons you want to keep Sql Express depending on what you are
> developing). Apparently, Sql Dev edition has now been tricked into thinking
> itâ's a clean install since the Express edition of the workstation tools were
> removed (no longer an â'unsupported upgradeâ' scenario). It will therefore go
> ahead with Dev edition Workstation tools, and Management Studio also gets
> installed.
> Tip: Remember to run SP2 for both Sql Express and Sql Dev at this point.
> Also, I believe an alternative resolution is to simply install Sql Express
> Management Studio after Sql Express (Visual Studio), and THEN run the Sql Dev
> edition install, and it will in fact upgrade everything properly. I cannot
> confirm this, but I recall having a conversation with a friend at Microsoft
> who said that worked for him.
> I hope this post helps some poor souls out there!
> -David P.
>|||David
Thanks for the help - unfortunately I'm still getting errors on SQLS=XML4;
OWC11 and Workstation tools when i attempt to load (eventhough SQLXML4 is
already installed)
Any other suggestions?
"David Pugmire" wrote:
>
> "Sandy Ryan" wrote:
> > i am having a heck of a time -- i know SP2 makes sql server 2005
> > incompatiable... however, i need an instance INSTALLED first and that is
> > where the problem lies.
> > i of course built my system and put office on before visual studio - so
> > office put sql express on the system (which worked by the way) -- so i had to
> > uninstall sql express, because i wanted to use sql developer.
> > when i try to install sql developer it doesn't install owc , sql server or
> > the workstation tools.
> > how do I get sql installed on vista so i can continue working?
> > thanks
> > Sandy
> I found the following similar problem and resolution. I am not sure if this
> is exactly what you experienced, but it sounds close.
> I installed:
> -Vista Ultimate x64
> -Sql Server 2005 Express Edition (via Visual Studio 2005 Pro)
> At this point, Sql Express is installed, but NOT Management Studio. I then
> tried to Install Sql Dev edition. I discovered that it was considered an
> Upgrade from Sql Express. But the kicker: it would NOT install the
> Workstation Tools because it thought it didnâ't qualify for an Upgrade! I
> think this is a bug personally. Even though Sql Express was installed AND is
> a valid upgrade path to Sql Dev, the problem is that it didnâ't see Management
> Studio, and therefore assumed you donâ't have rights to install Dev edition
> Workstation Tools (completely stupid).
> Resolution:
> -Go to Programs and Features
> -Right Click Microsoft Sql Server 2005 and select Uninstall
> -Check ONLY the box that says Workstation Tools (donâ't uninstall Sql Express
> unless you donâ't want it)
> -Click Next and finish the Uninstall of the Workstation Components
> -Run setup for Sql Dev edition
> Worked like a charm. I now have Sql 2005 Express and Sql Dev 2005 editions
> running, and the Dev edition tools wherewith to manage them (and BTW, there
> are reasons you want to keep Sql Express depending on what you are
> developing). Apparently, Sql Dev edition has now been tricked into thinking
> itâ's a clean install since the Express edition of the workstation tools were
> removed (no longer an â'unsupported upgradeâ' scenario). It will therefore go
> ahead with Dev edition Workstation tools, and Management Studio also gets
> installed.
> Tip: Remember to run SP2 for both Sql Express and Sql Dev at this point.
> Also, I believe an alternative resolution is to simply install Sql Express
> Management Studio after Sql Express (Visual Studio), and THEN run the Sql Dev
> edition install, and it will in fact upgrade everything properly. I cannot
> confirm this, but I recall having a conversation with a friend at Microsoft
> who said that worked for him.
> I hope this post helps some poor souls out there!
> -David P.
>|||I also was having a problem installing SQL 2005 Developer edition on Vista. I
ended up copying the install to my hard drive and then right clicking on the
setup.exe and choose properties. I then went to the compatability tab and
checked the box that said run in compatability mode for Windows XP Service
Pack2 and also checked the box that said run this prgram as administrator. I
then ran the setup.exe by double clicking on it and I no longer got any
errors.
"Sandy Ryan" wrote:
> David
> Thanks for the help - unfortunately I'm still getting errors on SQLS=XML4;
> OWC11 and Workstation tools when i attempt to load (eventhough SQLXML4 is
> already installed)
> Any other suggestions?
> "David Pugmire" wrote:
> >
> >
> > "Sandy Ryan" wrote:
> >
> > > i am having a heck of a time -- i know SP2 makes sql server 2005
> > > incompatiable... however, i need an instance INSTALLED first and that is
> > > where the problem lies.
> > > i of course built my system and put office on before visual studio - so
> > > office put sql express on the system (which worked by the way) -- so i had to
> > > uninstall sql express, because i wanted to use sql developer.
> > > when i try to install sql developer it doesn't install owc , sql server or
> > > the workstation tools.
> > > how do I get sql installed on vista so i can continue working?
> > > thanks
> > > Sandy
> >
> > I found the following similar problem and resolution. I am not sure if this
> > is exactly what you experienced, but it sounds close.
> >
> > I installed:
> > -Vista Ultimate x64
> > -Sql Server 2005 Express Edition (via Visual Studio 2005 Pro)
> >
> > At this point, Sql Express is installed, but NOT Management Studio. I then
> > tried to Install Sql Dev edition. I discovered that it was considered an
> > Upgrade from Sql Express. But the kicker: it would NOT install the
> > Workstation Tools because it thought it didnâ't qualify for an Upgrade! I
> > think this is a bug personally. Even though Sql Express was installed AND is
> > a valid upgrade path to Sql Dev, the problem is that it didnâ't see Management
> > Studio, and therefore assumed you donâ't have rights to install Dev edition
> > Workstation Tools (completely stupid).
> >
> > Resolution:
> > -Go to Programs and Features
> > -Right Click Microsoft Sql Server 2005 and select Uninstall
> > -Check ONLY the box that says Workstation Tools (donâ't uninstall Sql Express
> > unless you donâ't want it)
> > -Click Next and finish the Uninstall of the Workstation Components
> > -Run setup for Sql Dev edition
> >
> > Worked like a charm. I now have Sql 2005 Express and Sql Dev 2005 editions
> > running, and the Dev edition tools wherewith to manage them (and BTW, there
> > are reasons you want to keep Sql Express depending on what you are
> > developing). Apparently, Sql Dev edition has now been tricked into thinking
> > itâ's a clean install since the Express edition of the workstation tools were
> > removed (no longer an â'unsupported upgradeâ' scenario). It will therefore go
> > ahead with Dev edition Workstation tools, and Management Studio also gets
> > installed.
> >
> > Tip: Remember to run SP2 for both Sql Express and Sql Dev at this point.
> > Also, I believe an alternative resolution is to simply install Sql Express
> > Management Studio after Sql Express (Visual Studio), and THEN run the Sql Dev
> > edition install, and it will in fact upgrade everything properly. I cannot
> > confirm this, but I recall having a conversation with a friend at Microsoft
> > who said that worked for him.
> >
> > I hope this post helps some poor souls out there!
> >
> > -David P.
> >
. apparently not. Maybe it requires business edition..|||
|||Using the Developer edition helped me as well....I was also stumped with the Enterprise Edition. Thanks 
|||I'm having that exact same issue! so I just need to install SQL dev edition? I'm trying to install enterprise...|||yeah that should work mate.
. apparently not. Maybe it requires business edition..|||
|||I'm having that exact same issue! so I just need to install SQL dev edition? I'm trying to install enterprise...|||yeah that should work mate.