can't open adventure works example

after running msi, can't open this solution

C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project\Standard, select the file Adventure Works DW.sln

error msg
Microsoft Visual Studio

The application for project 'C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project\standard\Adventure Works DW Standard Edition.dwproj' is not installed.

Make sure the application for the project type (.dwproj) is installed.

error msg

Did you install it some other folder than the one stated below ? Or did you not install the samples libarary ? Then you won′t find the information in this folder. You can install the samples from disks afterwards, juzst launch the explorer and use the custom installation type.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||It's installed exactly where shown, but there are no instructions on how to install .dwproj|||ARe you installing SQL Server Express ? SQL Server Analysis Services isn′t shipped with Express so you should get the project files from another edition than express.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||yes I'm using sql express the advanced edition which is supposed to support the adventureworks sample|||Express does not support Analysis Services, you are trying to open the analysis services sample for adventure works, try one of the others.

Can't install sqlncli.msi

When trying to install sqlncli.msi on Windows XP SP2 I get the following
error
"The system administrator has set policies to prevent this installation"
Given that I am the system administrator ...
What do I need to do to resolve this ?
What policies have been set ?
Can you execute any msi? Or is it just with this windows
intaller package?
Try checking the local policies on the PC for windows
installer using the group policy editor snap in.
From the run command, run gpedit.msc
Go to Computer Configuration, then to Administrative
templates, then to Windows Components, then to Windows
Installer.
You could also be hitting this:
http://support.microsoft.com/kb/322963
Did you check the windows installer service on the PC
itself? Is it manual or running?
Did you also try updating your windows installer?
http://support.microsoft.com/kb/893803
-Sue
On Tue, 19 Jun 2007 12:41:14 -0600, "Michael Tissington"
<mtissington@.newsgroups.nospam> wrote:

>When trying to install sqlncli.msi on Windows XP SP2 I get the following
>error
>"The system administrator has set policies to prevent this installation"
>Given that I am the system administrator ...
>What do I need to do to resolve this ?
>What policies have been set ?

Can't install sqlncli.msi

When trying to install sqlncli.msi on Windows XP SP2 I get the following
error
"The system administrator has set policies to prevent this installation"
Given that I am the system administrator ...
What do I need to do to resolve this ?
What policies have been set ?Can you execute any msi? Or is it just with this windows
intaller package?
Try checking the local policies on the PC for windows
installer using the group policy editor snap in.
From the run command, run gpedit.msc
Go to Computer Configuration, then to Administrative
templates, then to Windows Components, then to Windows
Installer.
You could also be hitting this:
http://support.microsoft.com/kb/322963
Did you check the windows installer service on the PC
itself? Is it manual or running?
Did you also try updating your windows installer?
http://support.microsoft.com/kb/893803
-Sue
On Tue, 19 Jun 2007 12:41:14 -0600, "Michael Tissington"
<mtissington@.newsgroups.nospam> wrote:

>When trying to install sqlncli.msi on Windows XP SP2 I get the following
>error
>"The system administrator has set policies to prevent this installation"
>Given that I am the system administrator ...
>What do I need to do to resolve this ?
>What policies have been set ?

Can't install sqlncli.msi

When trying to install sqlncli.msi on Windows XP SP2 I get the following
error
"The system administrator has set policies to prevent this installation"
Given that I am the system administrator ...
What do I need to do to resolve this ?
What policies have been set ?
Can you execute any msi? Or is it just with this windows
intaller package?
Try checking the local policies on the PC for windows
installer using the group policy editor snap in.
From the run command, run gpedit.msc
Go to Computer Configuration, then to Administrative
templates, then to Windows Components, then to Windows
Installer.
You could also be hitting this:
http://support.microsoft.com/kb/322963
Did you check the windows installer service on the PC
itself? Is it manual or running?
Did you also try updating your windows installer?
http://support.microsoft.com/kb/893803
-Sue
On Tue, 19 Jun 2007 12:41:14 -0600, "Michael Tissington"
<mtissington@.newsgroups.nospam> wrote:

>When trying to install sqlncli.msi on Windows XP SP2 I get the following
>error
>"The system administrator has set policies to prevent this installation"
>Given that I am the system administrator ...
>What do I need to do to resolve this ?
>What policies have been set ?

cant install SQL Web Data Administrator

Hi

I am using Web Developer 2005 Express. I am trying to install the SQL Web Data Administrator (setup.msi), but it gives an error message saying that I need to install Framework 1.1, BUT I already have version 2, so no-go for me there.

Also I have been trying to install the Cassini version with zero luck. When I run the build.bat file I get the csc and gacutil errors. However, when I set up the Environmental variable PATH within My Computer\Properties\Advanced\Environmental Variables\user Variables as per the instructions on the Cassini discussion forum, no change, I do not get 200 bucks or pass GO .

Please tell me I am being stupid

Dose your system fit all the requirements?

System Requirements

Supported Operating Systems:Windows 2000

Can't install SQL Express

It fails because it can't find sqlncli.msi. I looked in the temp directory and it was there

Log excerpt:
User policy value 'SearchOrder' is 'nmu'
MSI (s) (B4:A4) [20:53:04:843]: User policy value 'DisableMedia' is 0
MSI (s) (B4:A4) [20:53:04:843]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (B4:A4) [20:53:04:843]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Looking for sourcelist for product {50A0893D-47D8-48E0-A7E8-44BCD7E4422E}
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Adding {50A0893D-47D8-48E0-A7E8-44BCD7E4422E}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Now checking product {50A0893D-47D8-48E0-A7E8-44BCD7E4422E}
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Media is enabled for product.
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Trying source c:\3a0fb7a85678459f3572f2\setup\.
MSI (s) (B4:A4) [20:53:04:859]: Note: 1: 2203 2: c:\3a0fb7a85678459f3572f2\setup\sqlncli.msi 3: -2147287037
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (B4:A4) [20:53:04:859]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Processing net source list.
MSI (s) (B4:A4) [20:53:04:859]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Processing media source list.
MSI (s) (B4:A4) [20:53:05:921]: SOURCEMGMT: Trying media source E:\.
MSI (s) (B4:A4) [20:53:05:921]: Note: 1: 2203 2: E:\sqlncli.msi 3: -2147287038
MSI (s) (B4:A4) [20:53:05:921]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (B4:A4) [20:53:05:921]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (B4:A4) [20:53:05:921]: SOURCEMGMT: Processing URL source list.
MSI (s) (B4:A4) [20:53:05:921]: Note: 1: 1402 2: UNKNOWN\URL 3: 2
MSI (s) (B4:A4) [20:53:05:921]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (B4:A4) [20:53:05:921]: Note: 1: 1706 2: 3: sqlncli.msi
MSI (s) (B4:A4) [20:53:05:921]: SOURCEMGMT: Failed to resolve source
MSI (s) (B4:A4) [20:54:31:734]: Product: Microsoft SQL Server Native Client -- Error 1706. An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'.I found an old post that led me to the solution. The proposed solution was to extract the files from SQLEXPR and install SQLNativeClient by hand and then un-install it. When I ran the .msi file, it found an apparent stealth installed SQLNativeClient (Add/Remove did not show it).

Installation completed

Rusty

can't install sample databases plus no documents or tutorials

I have downloaded and run all the .msi's for the sample databases. To install them I am suppose to use "SQL Server 2005 Setup, you need to click the Advanced button....". I don't seem to have a "SQL Server 2005 Setup" - did the docs revert back to SQL Server rather than SQL Express or what ?

R
Perhaps I was unclear on the problem (people have looked at my post but no one has replied). I am trying to follow the instructions at

http://download.microsoft.com/download/d/8/6/d865cf0c-c44b-401b-b426-b3bf5c628112/GettingStartedWithSQLSamples.htm
Don't know why that doesn't show up as an URL.

Anyway the intructions do not match what I have downloaded.

Any help would be greatly appreciated

Thanks

R
|||

I downloaded the files couple of days ago on my own for a training. I think the process described here is for non-Express version, but for express version (or as a standalone inspection) you can download the sample files here:

http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Thanks Jens for the reply and the link; however, that link is the crux of the problem. I have done everything specified on that link until I get to the point of using SQL Server 2005 Setup - which I don't have. I think I have a very neat application but it hard to implement it without a database to practice on.

R
|||

The first three steps of the Getting Started with SQL Server Samples document that your reference deal specifically with how to install the SqlSamples.msi file when you are installing SQL Server. These do not apply to SQL Express because we do not include the SqlSamples.msi as part of our installer package. (We do this to keep it small.) Steps starting with four still apply.

Rather, you need to install the samples separately by downloading SqlSamples.msi from the Samples page that Jens pointed to. You will see a bunch of links on that page that break the Sample installation files up by processor type, e.g. x86. The direct link for the x86 version is http://download.microsoft.com/download/a/1/8/a1872d6b-f740-4c52-a2c5-0eb5bdd1a7e3/SqlServerSamples.msi.

Once you've downloaded this file, just run it and it will install the Samples onto your computer. You can then use the Start menu (All Programs | Microsoft SQL Server 2005 | Documentation and Tutorials | Samples Directory) to open the directory and find the various sub-categories. Each specific sample has a read-me with more information about how to use it. For many, you will need AdventureWorksDB installed, which is also a separate download for Express and available on the same page with the samples. (i.e. the one that Jens gives.)