Home All Groups Group Topic Archive Search About

2005: How to install SQL-DMO samples (and DEVTOOLS folder)?

Author
22 Mar 2006 6:10 AM
google
Thiis really ticking me off.....

How the heck do you get the SQL-DMO sample code installed from the 2005
installer?  I have performed both full server and workstation installs
with every option checked.   According to BOL, under the topic "SQLDMO
Samples", it says:

=============================================
To install the samples during SQL Server installation
On the Setup Type page, select Custom.

On the Select Components page, under Components, select Code Samples.

Samples are installed as a self-extracting file. To extract the
samples, double-click Unzip_sqldmo.exe, located at C:\Program
Files\Microsoft SQL Server\90\Tools\Devtools\Samples\Sqldmo.

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

However, I have no DevTools subdirectory.  No matter what rinstaller I
run, I still get no such directory. Anbd, I've never seen the "Setup
Type" page referenced above.
I've tried to install it on a server install, and a workstation (client
tools) install.

ANy help wpould be greatly appreciated.





Microsoft SQL Server Setup
------------------------------

None of the selected features can be installed or upgraded. Setup
cannot proceed since no effective change is being made to the machine.
To continue, click Back and then select features to install. To exit
SQL Server Setup, click Cancel.

------

Author
22 Mar 2006 9:55 PM
Jasper Smith
The samples are installed by choosing Advanced on the Feature selection page
of setup however you can simply download the updated samples and sample
databases here
http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com


<goo***@dcbarry.com> wrote in message
Show quote
news:1143007804.536517.260590@u72g2000cwu.googlegroups.com...
> Thiis really ticking me off.....
>
> How the heck do you get the SQL-DMO sample code installed from the 2005
> installer?  I have performed both full server and workstation installs
> with every option checked.   According to BOL, under the topic "SQLDMO
> Samples", it says:
>
> =============================================
> To install the samples during SQL Server installation
> On the Setup Type page, select Custom.
>
> On the Select Components page, under Components, select Code Samples.
>
> Samples are installed as a self-extracting file. To extract the
> samples, double-click Unzip_sqldmo.exe, located at C:\Program
> Files\Microsoft SQL Server\90\Tools\Devtools\Samples\Sqldmo.
>
> ================================================================
>
> However, I have no DevTools subdirectory.  No matter what rinstaller I
> run, I still get no such directory. Anbd, I've never seen the "Setup
> Type" page referenced above.
> I've tried to install it on a server install, and a workstation (client
> tools) install.
>
> ANy help wpould be greatly appreciated.
>
>
>
>
>
> Microsoft SQL Server Setup
> ------------------------------
>
> None of the selected features can be installed or upgraded. Setup
> cannot proceed since no effective change is being made to the machine.
> To continue, click Back and then select features to install. To exit
> SQL Server Setup, click Cancel.
>
> ------
>
Author
23 Mar 2006 1:04 AM
google
Jasper (and all others):

Thanks for the reply Jasper,  but how do I get to the dialog with
"Feature selection page" with the advanced tab?


Right now there are some  paths  I try without success:

1) Control Panel  >Add Remove Programs
2)  select "Microsoft SQL Server" -- "Change"
3)  On Fature Maint: Click on: "TO Install a new component, click here"

4)   Navigate to Setup.exe in the "Servers" directory of the install
CD.
5)  System Config Check Launches (click next, it passes ALL OK), click
next
5) "Tools Setup" dialog displays -- click "Change Installed
Components".

6)  "Feature Selection" is displayed.

        The two main trees are Client COmponents and "Documentation,
Samples and Sample Data".
      In this case, all are shown with "RED X" - no installed.

7) Change "Documentation, Samples and Sample Data". to :Entire Feature
will be installed."
8) A message is displayed indicates that the components I selected are
already installed.


=== anopther path =====



1) Control Panel  >Add Remove Programs
2)  select "Microsoft SQL Server" -- "Change"
3)  Select ( )  SQL  2005  common componets / Workstation Components
(click next)
4)  System Config Check Launches (click next, it passes ALL OK), click
next
5) "Tools Setup" dialog displays -- click "Change Installed
Components".

6)  "Feature Selection" is displayed.
        The two main trees are Client COmponents and "Documentation,
Samples and Sample Data".
        All are shown with the disk icon indicating that a feature has
already been installed.  (The only choice I can make is to deinsstall
an option to free up space.)

There is no "advanced" button on this dialog, only a "disk cost"
button, along with Help/Back/Next/Cancel buttons.   Proceeding forward
accomplishes nothing.

--- similar results if instead of Workstation component in step 3
above, I choose a server instance.

My other alternative is the following

1) Control Panel  >Add Remove Programs
2) Choose "Microsoft SQL Server 2005 Samples", Change
3) CLick Modify
4) Microsoft SQL Samples is displayed as an installed option.  Click
next.
5)  Indicates sucessful install.  (But nothing is actually installed).


Any additional step by step would be appreciated to get to point in
your instructions.

Thanks,

d.





Jasper Smith wrote:
Show quote
> The samples are installed by choosing Advanced on the Feature selection page
> of setup however you can simply download the updated samples and sample
> databases here
> http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en
>
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
>
Author
23 Mar 2006 2:49 AM
Gail Erickson [MS]
It sounds like you're experiencing an elusive bug that we're trying to
reproduce and fix.  Basically, setup thinks the samples are already
installed so it's ignoring your request.  You should follow Jasper's
recommendation and download the samples (and sample databases if you don't
have those) from the download center.

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

<goo***@dcbarry.com> wrote in message
Show quote
news:1143075873.081903.80050@j33g2000cwa.googlegroups.com...
> Jasper (and all others):
>
> Thanks for the reply Jasper,  but how do I get to the dialog with
> "Feature selection page" with the advanced tab?
>
>
> Right now there are some  paths  I try without success:
>
> 1) Control Panel  >Add Remove Programs
> 2)  select "Microsoft SQL Server" -- "Change"
> 3)  On Fature Maint: Click on: "TO Install a new component, click here"
>
> 4)   Navigate to Setup.exe in the "Servers" directory of the install
> CD.
> 5)  System Config Check Launches (click next, it passes ALL OK), click
> next
> 5) "Tools Setup" dialog displays -- click "Change Installed
> Components".
>
> 6)  "Feature Selection" is displayed.
>
>        The two main trees are Client COmponents and "Documentation,
> Samples and Sample Data".
>      In this case, all are shown with "RED X" - no installed.
>
> 7) Change "Documentation, Samples and Sample Data". to :Entire Feature
> will be installed."
> 8) A message is displayed indicates that the components I selected are
> already installed.
>
>
> === anopther path =====
>
>
>
> 1) Control Panel  >Add Remove Programs
> 2)  select "Microsoft SQL Server" -- "Change"
> 3)  Select ( )  SQL  2005  common componets / Workstation Components
> (click next)
> 4)  System Config Check Launches (click next, it passes ALL OK), click
> next
> 5) "Tools Setup" dialog displays -- click "Change Installed
> Components".
>
> 6)  "Feature Selection" is displayed.
>        The two main trees are Client COmponents and "Documentation,
> Samples and Sample Data".
>        All are shown with the disk icon indicating that a feature has
> already been installed.  (The only choice I can make is to deinsstall
> an option to free up space.)
>
> There is no "advanced" button on this dialog, only a "disk cost"
> button, along with Help/Back/Next/Cancel buttons.   Proceeding forward
> accomplishes nothing.
>
> --- similar results if instead of Workstation component in step 3
> above, I choose a server instance.
>
> My other alternative is the following
>
> 1) Control Panel  >Add Remove Programs
> 2) Choose "Microsoft SQL Server 2005 Samples", Change
> 3) CLick Modify
> 4) Microsoft SQL Samples is displayed as an installed option.  Click
> next.
> 5)  Indicates sucessful install.  (But nothing is actually installed).
>
>
> Any additional step by step would be appreciated to get to point in
> your instructions.
>
> Thanks,
>
> d.
>
>
>
>
>
> Jasper Smith wrote:
>> The samples are installed by choosing Advanced on the Feature selection
>> page
>> of setup however you can simply download the updated samples and sample
>> databases here
>> http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en
>>
>> --
>> HTH,
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>>
>>
>

AddThis Social Bookmark Button