Another Sql 2005 Express Installation Problem

I am receiving the following message when trying to install Sql Server 2005 Express: "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 have verified that the sqlncli.mis file is included in the file being extracted by the installer and I have redownloaded the installation program 3 times from the MSDN site in case the file was corrupt.

Any ideas?I was able to solve my own problem by copying the 'sqlncli.msi' file to another folder during the failed installation.

Then after the failed installation I ran the sqlncli.msi by itself and it installed the Sql Native Client on its own just fine.

Then I ran the installation again and it made it past this point fine and completed the rest of the installation successfully.

This was on a Win2000 Professional machine. I am leaving this post here just in case anyone else runs across this.|||

Thanks a lot man "Johansec".

Your solution worked for me.

Another Sql 2005 Express Installation Problem

I am receiving the following message when trying to install Sql Server 2005 Express: "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 have verified that the sqlncli.mis file is included in the file being extracted by the installer and I have redownloaded the installation program 3 times from the MSDN site in case the file was corrupt.

Any ideas?I was able to solve my own problem by copying the 'sqlncli.msi' file to another folder during the failed installation.

Then after the failed installation I ran the sqlncli.msi by itself and it installed the Sql Native Client on its own just fine.

Then I ran the installation again and it made it past this point fine and completed the rest of the installation successfully.

This was on a Win2000 Professional machine. I am leaving this post here just in case anyone else runs across this.|||

Thanks a lot man "Johansec".

Your solution worked for me.

Another question regarding licensing

Hi all,
I read different statements below and now I'm totally confused. My case is
as following: We want install SQLServer 2000 Standard Edition on a single
processor server. Our application Saperion is the only application which uses
that SQL instance. For Saperion we have a concurrent licensing model. That
means we have defined about 40 user who could use these applicaton, but at
the same time only 20 user have access. So, in maximum 20 user can work with
Saperion with SQL as the database engine.
Now the question is what kind of license do I have to buy. I understand the
processor licensing model, but the device CAL's and User CAL's not!
Thank you for your kind help in this matter.
Regards,
KE
User and device CAL licensing is based on total numbers rather than
concurrent numbers. On the information given it seems you would need 40 user
CALs if you chose the User CAL model. Device CALs are licensed per end-user
device so if you have multiple users sharing a workstation for example then
device CALs may be more cost effective than user CALs.
That's my understanding, but don't take my word for it. Ask a Microsoft
representative if you want a definitive answer.
Lots of info on licensing here:
http://www.microsoft.com/sql/howtobuy/default.asp
You may find the FAQ helpful.
David Portas
SQL Server MVP
|||Hi David,
Thank you very much for your answer. 40 user CAL's are not logical for me,
because Saperion never allows us to have more than 20 users online. That
means maximum 20 users can use the SQL server at a certain time. Logical for
me would be 20 user CAL's. If I'm wrong, tell me why......
Best regards,
KE
"David Portas" wrote:

> User and device CAL licensing is based on total numbers rather than
> concurrent numbers. On the information given it seems you would need 40 user
> CALs if you chose the User CAL model. Device CALs are licensed per end-user
> device so if you have multiple users sharing a workstation for example then
> device CALs may be more cost effective than user CALs.
> That's my understanding, but don't take my word for it. Ask a Microsoft
> representative if you want a definitive answer.
> Lots of info on licensing here:
> http://www.microsoft.com/sql/howtobuy/default.asp
> You may find the FAQ helpful.
> --
> David Portas
> SQL Server MVP
> --
>
|||SQL Server isn't licensed per CONCURRENT user. The fact that Saperion is
licensed that way wouldn't affect SQL Server licensing.
A user licence grants A USER a licence to use the software so one licence is
required PER USER not per connection or connected user.
David Portas
SQL Server MVP
|||Hi David,
Thank you very much for your explanation. In my point of view the SQL
licensing NOT per CONCURRENT user is very strange. Logical for me would be
only the CONCURRENT approach. However MS can do what they want!?!?!?
I have following additional question. Do we need for each SQL server
installation CAL's for all possible user (40 in our case)?
Example 1:
2 SQL Server Standard with user CAL's, 40 user can work with applications,
which use these servers.
Do we need 2 server licenses and 40 CAL's or 80 CAL's?
Example 2:
1 SQL Server Standard with processor license, 1 SQL Server Standard with
user CAL's.
According to MS homepage for the SQL Server with processor license I do not
need any CAL's. Is that correct? If yes, I assume that we need 1 server
license and 40 CAL's for the second SQL installation?
Thank you very much in advance.
Regards,
KE
"David Portas" wrote:

> SQL Server isn't licensed per CONCURRENT user. The fact that Saperion is
> licensed that way wouldn't affect SQL Server licensing.
> A user licence grants A USER a licence to use the software so one licence is
> required PER USER not per connection or connected user.
> --
> David Portas
> SQL Server MVP
> --
>
|||Inline below:

> I have following additional question. Do we need for each SQL server
> installation CAL's for all possible user (40 in our case)?
> Example 1:
> 2 SQL Server Standard with user CAL's, 40 user can work with applications,
> which use these servers.
> Do we need 2 server licenses and 40 CAL's or 80 CAL's?
2 server licenses. 40 CAL's. You can look at it like each user has a piece of paper that gives
him/her the right to connect to SQL Servers.

> Example 2:
> 1 SQL Server Standard with processor license, 1 SQL Server Standard with
> user CAL's.
> According to MS homepage for the SQL Server with processor license I do not
> need any CAL's. Is that correct? If yes, I assume that we need 1 server
> license and 40 CAL's for the second SQL installation?
Correct.
FYI: To speak to someone regarding licensing:
You can call 1-800-426-9400 (select option 4), Monday through Friday, 6:00
A.M. to 6:00 P.M. (PST) to speak directly to a Microsoft licensing
specialist for licensing problem. Worldwide customers can use the Guide to
Worldwide Microsoft Licensing Sites
http://www.microsoft.com/licensing/index/worldwide.asp to find contact
information in their locations.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"KE" <KE@.discussions.microsoft.com> wrote in message
news:7D9A468D-FB00-4D72-AD37-2324CF8C84AF@.microsoft.com...[vbcol=seagreen]
> Hi David,
> Thank you very much for your explanation. In my point of view the SQL
> licensing NOT per CONCURRENT user is very strange. Logical for me would be
> only the CONCURRENT approach. However MS can do what they want!?!?!?
> I have following additional question. Do we need for each SQL server
> installation CAL's for all possible user (40 in our case)?
> Example 1:
> 2 SQL Server Standard with user CAL's, 40 user can work with applications,
> which use these servers.
> Do we need 2 server licenses and 40 CAL's or 80 CAL's?
> Example 2:
> 1 SQL Server Standard with processor license, 1 SQL Server Standard with
> user CAL's.
> According to MS homepage for the SQL Server with processor license I do not
> need any CAL's. Is that correct? If yes, I assume that we need 1 server
> license and 40 CAL's for the second SQL installation?
> Thank you very much in advance.
> Regards,
> KE
>
>
>
> "David Portas" wrote:

Another installation question

I am trying to reinstall Reporting Services. I installed SQL Server and uninstalled/reinstalled IIS. When I get to the Reporting Services install page I get the message:

The prerequisite check failed for a default report server installation:

The Report Server virtual directory (ReportServer) can't be used for installation. It is already in use by another application. Setup is defaulted to "Files Only" install.

Since I've removed any program from my computer that could possible be using I don't know what could be using ReportServer. The reason I reinstalled was because my virtual directory was misplaced by the system.

How can I do a clean install of RS?

It sounds like the Virtual Directory you used before is still in use. Try installing SQL 2005 with a instance name instead of just the default. The Virtual Directory will then be ReportServer$<instance_name> and Reports$<instance_name>

Hope this helps.

Eduard
|||I tried that and got a new error message (see new thread above).|||delete those virtual directory and then create them freshly|||Been there, done that....I deleted every reference on my computer, uninstalled SQL Server, IIS, & VS, searched Registry keys, took everything off I could find.....still get error messages|||only thing left is that , the virtual directory might be of an earlier instance. so need to look out to delete those things

Anonymous Subscription not showing as an option

I am attempting to create an anonymous subscription on a new install of SQL
Server 2000 (new server). I have successfully done this other
instances/servers. Why does the publication, which allows anonymous
subscritions, not show in my options?
I can ping the server just fine. I am sure I am just overlooking something.
Thanks-Deb
Is the account your SQL Server agent is running under on the subscriber in
the PAL on the Publisher?
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Deb" <Deb@.discussions.microsoft.com> wrote in message
news:EC90B821-98B5-47F8-83B7-39C412EDC86D@.microsoft.com...
>I am attempting to create an anonymous subscription on a new install of SQL
> Server 2000 (new server). I have successfully done this other
> instances/servers. Why does the publication, which allows anonymous
> subscritions, not show in my options?
> I can ping the server just fine. I am sure I am just overlooking
> something.
> --
> Thanks-Deb
|||Yes... it is. I also listed this new server as a subscriber under Publisher
and Distributor properties.
Deb
"Deb" wrote:

> I am attempting to create an anonymous subscription on a new install of SQL
> Server 2000 (new server). I have successfully done this other
> instances/servers. Why does the publication, which allows anonymous
> subscritions, not show in my options?
> I can ping the server just fine. I am sure I am just overlooking something.
> --
> Thanks-Deb
|||Yes...it is. I also listed the server under Subscribers in the Publisher and
Distributor properties tab.
Deb
"Hilary Cotter" wrote:

> Is the account your SQL Server agent is running under on the subscriber in
> the PAL on the Publisher?
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Deb" <Deb@.discussions.microsoft.com> wrote in message
> news:EC90B821-98B5-47F8-83B7-39C412EDC86D@.microsoft.com...
>
>
|||Is your subscriber by chance an MSDE subscriber?
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Deb" <Deb@.discussions.microsoft.com> wrote in message
news:9D6E7DDD-6911-4E6A-BF9B-93001BEDADDC@.microsoft.com...[vbcol=seagreen]
> Yes...it is. I also listed the server under Subscribers in the Publisher
> and
> Distributor properties tab.
> --
> Deb
>
> "Hilary Cotter" wrote:
|||It should be able to see it then. Could you also try this - add the account
to the dbo group in the distribution database.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Deb" <Deb@.discussions.microsoft.com> wrote in message
news:2EB34604-83BE-4106-ABB9-3A88C2D2D941@.microsoft.com...[vbcol=seagreen]
> Yes... it is. I also listed this new server as a subscriber under
> Publisher
> and Distributor properties.
> --
> Deb
>
> "Deb" wrote:
|||I thought of that one as well. I added it just trying to cover my bases. No
go.
What I find interesting is I can see other Anonymous Snapshots available on
other servers and this user is not a part PAL or Sys Amin role on these
servers whatsoever.
Deb
"Hilary Cotter" wrote:

> It should be able to see it then. Could you also try this - add the account
> to the dbo group in the distribution database.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Deb" <Deb@.discussions.microsoft.com> wrote in message
> news:2EB34604-83BE-4106-ABB9-3A88C2D2D941@.microsoft.com...
>
>

Analysis services?

Hi!
I am confused ...downloaded Microsoft SQL server 2005 (for reporting services) to my Windows 2002 (32-bit systems), but it asks me to install the service packs as well...

So Windows XP Service Pack 2 is already installed.
And I need to download Windows server 2000 or 2003 R2, but where could I find a free trial version?

Do I also need Asp.net and IIS?
I would be very grateful for some help... to clarify which components needed.

Since you're wanting RS, you'll need to install SQL Server Express with Advanced Services. Here's the link:

http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx

This product is supported on XP SP2, so you won't need to do any OS upgrades.

Thanks,
Sam Lester (MSFT)

|||Thank you so much!
I get the following answer though "Your OS does nor support the Service Pack required for this SQL server release."

So my OS is 2002...
How do I check which SP required?
I did not find any .net Framework 2.0 SP.|||I managed to download SQL Server 2005 Express Edition with Advanced

Services SP1, and noticed Reporting services are available but how about "Analysis services" ?
|||

Analysis Services does not ship with any of the Express SKUs. It is part of the other SKUs (Enterprise, Standard, etc). If you want to play around with it, you can download the evaluation version found here:

http://www.microsoft.com/sql/downloads/trial-software.mspx

Thanks,
Sam Lester (MSFT)

Analysis Services Plugin Debug

Hi!

I am working on an AS Algorithm Plugin . I want to debug it in the AS Server, but I cant figure out how it works. Now I every time install and deploy the plugin, but if I catch an exception, it just shows me the message, not the stack trace. Anyone, something friendlier method?

Sorry for my poor English!

Bye,
Laci

To debug, just attach the debugger to the msmdsrv.exe process.

Do you use managed or native code to implement your plug-in? Also, are you using one of the samples or developing from scratch? If you provide more details, there could be some easier ways to catch errors

|||Thank You. It fully solved my problem!

Analysis Services Plugin Debug

Hi!

I am working on an AS Algorithm Plugin . I want to debug it in the AS Server, but I cant figure out how it works. Now I every time install and deploy the plugin, but if I catch an exception, it just shows me the message, not the stack trace. Anyone, something friendlier method?

Sorry for my poor English!

Bye,
Laci

To debug, just attach the debugger to the msmdsrv.exe process.

Do you use managed or native code to implement your plug-in? Also, are you using one of the samples or developing from scratch? If you provide more details, there could be some easier ways to catch errors

|||Thank You. It fully solved my problem!

Analysis services part of SQLServer ?

Is Analysis services part of SQLServer ?
Should I install something ?
I need to create OLAP cubes in my SQLServer db.
ThanksThere's a profiler installed by default which helps you analyse how sql performs, what are it's bottlenecks and who/what/which gives it a hardtime. SQLServer keeps all sorts of statistics concerning a.o. table access.

I'm not sure how this translates to olap cubes though.|||According to the Features by Edition (http://www.microsoft.com/sql/evaluation/features/choosing.asp) table, Analysis Services is part of the Enterprise Edition of SQL Server 2000.

-PatP|||I need to create OLAP cubes in my SQLServer db.


Tell me if you are able to do that .. I always used to create stuff like Tables, Stored Procs triggers and functions in my SQL Server DB ...:cool:

and yes ... MS Analysis Server comes with SQL Server 2000 by default ... you just need to install it separately.

Analysis Services Install - Add. componets not found.

I'm trying to install Analysis Services, and we have a full enterprise msdn
set,
but when I go to add additional components I can't fine Analysis Services on
the April 2004 cd available. It doesn't appear to be listed.
Anyone have an idea of what's up with that?
KenMHi Ken,
Can you check "Analysis Services" item in the same screen as "add
Additional Components" of the same sqlserver installation cd?
Thanks,
Dutta
"KenM" wrote:

> I'm trying to install Analysis Services, and we have a full enterprise msd
n
> set,
> but when I go to add additional components I can't fine Analysis Services
on
> the April 2004 cd available. It doesn't appear to be listed.
> Anyone have an idea of what's up with that?
> KenM|||Hi, thanks for the reply., and
Nope. That's the problem. I come to the screen that has two boxes in it
showing components and sub-components and no matter where I click I can not
find "Analysis Services" anywhere.
I have an academic version of the msdn enterprise and am installing it to
get MS Project Services on a Win2003 server.
Just can't seem to find it.
Any help will be appreciated.
Ken
"Chandan DUtta" wrote:
[vbcol=seagreen]
> Hi Ken,
> Can you check "Analysis Services" item in the same screen as "add
> Additional Components" of the same sqlserver installation cd?
> Thanks,
> Dutta
>
> "KenM" wrote:
>|||Its actually on the very first screen with SQL Install
starts. The same one that says "Install SQL"
It is not in the "Add additional components" screen with
some other Checkboxed items.

>--Original Message--
>Hi, thanks for the reply., and
>Nope. That's the problem. I come to the screen that has
two boxes in it
>showing components and sub-components and no matter where
I click I can not
>find "Analysis Services" anywhere.
>I have an academic version of the msdn enterprise and am
installing it to
>get MS Project Services on a Win2003 server.
>Just can't seem to find it.
>Any help will be appreciated.
>Ken
>"Chandan DUtta" wrote:
>
screen as "add[vbcol=seagreen]
installation cd?[vbcol=seagreen]
a full enterprise msdn[vbcol=seagreen]
fine Analysis Services on[vbcol=seagreen]
listed.[vbcol=seagreen]
>.
>

Analysis Services Install - Add. componets not found.

I'm trying to install Analysis Services, and we have a full enterprise msdn
set,
but when I go to add additional components I can't fine Analysis Services on
the April 2004 cd available. It doesn't appear to be listed.
Anyone have an idea of what's up with that?
KenM
Hi Ken,
Can you check "Analysis Services" item in the same screen as "add
Additional Components" of the same sqlserver installation cd?
Thanks,
Dutta
"KenM" wrote:

> I'm trying to install Analysis Services, and we have a full enterprise msdn
> set,
> but when I go to add additional components I can't fine Analysis Services on
> the April 2004 cd available. It doesn't appear to be listed.
> Anyone have an idea of what's up with that?
> KenM
|||Hi, thanks for the reply., and
Nope. That's the problem. I come to the screen that has two boxes in it
showing components and sub-components and no matter where I click I can not
find "Analysis Services" anywhere.
I have an academic version of the msdn enterprise and am installing it to
get MS Project Services on a Win2003 server.
Just can't seem to find it.
Any help will be appreciated.
Ken
"Chandan DUtta" wrote:
[vbcol=seagreen]
> Hi Ken,
> Can you check "Analysis Services" item in the same screen as "add
> Additional Components" of the same sqlserver installation cd?
> Thanks,
> Dutta
>
> "KenM" wrote:
|||Its actually on the very first screen with SQL Install
starts. The same one that says "Install SQL"
It is not in the "Add additional components" screen with
some other Checkboxed items.

>--Original Message--
>Hi, thanks for the reply., and
>Nope. That's the problem. I come to the screen that has
two boxes in it
>showing components and sub-components and no matter where
I click I can not
>find "Analysis Services" anywhere.
>I have an academic version of the msdn enterprise and am
installing it to[vbcol=seagreen]
>get MS Project Services on a Win2003 server.
>Just can't seem to find it.
>Any help will be appreciated.
>Ken
>"Chandan DUtta" wrote:
screen as "add[vbcol=seagreen]
installation cd?[vbcol=seagreen]
a full enterprise msdn[vbcol=seagreen]
fine Analysis Services on[vbcol=seagreen]
listed.
>.
>

Analysis Services Install - Add. componets not found.

I'm trying to install Analysis Services, and we have a full enterprise msdn
set,
but when I go to add additional components I can't fine Analysis Services on
the April 2004 cd available. It doesn't appear to be listed.
Anyone have an idea of what's up with that?
KenMHi Ken,
Can you check "Analysis Services" item in the same screen as "add
Additional Components" of the same sqlserver installation cd?
Thanks,
Dutta
"KenM" wrote:
> I'm trying to install Analysis Services, and we have a full enterprise msdn
> set,
> but when I go to add additional components I can't fine Analysis Services on
> the April 2004 cd available. It doesn't appear to be listed.
> Anyone have an idea of what's up with that?
> KenM|||Hi, thanks for the reply., and
Nope. That's the problem. I come to the screen that has two boxes in it
showing components and sub-components and no matter where I click I can not
find "Analysis Services" anywhere.
I have an academic version of the msdn enterprise and am installing it to
get MS Project Services on a Win2003 server.
Just can't seem to find it.
Any help will be appreciated.
Ken
"Chandan DUtta" wrote:
> Hi Ken,
> Can you check "Analysis Services" item in the same screen as "add
> Additional Components" of the same sqlserver installation cd?
> Thanks,
> Dutta
>
> "KenM" wrote:
> > I'm trying to install Analysis Services, and we have a full enterprise msdn
> > set,
> > but when I go to add additional components I can't fine Analysis Services on
> > the April 2004 cd available. It doesn't appear to be listed.
> >
> > Anyone have an idea of what's up with that?
> >
> > KenM|||Its actually on the very first screen with SQL Install
starts. The same one that says "Install SQL"
It is not in the "Add additional components" screen with
some other Checkboxed items.
>--Original Message--
>Hi, thanks for the reply., and
>Nope. That's the problem. I come to the screen that has
two boxes in it
>showing components and sub-components and no matter where
I click I can not
>find "Analysis Services" anywhere.
>I have an academic version of the msdn enterprise and am
installing it to
>get MS Project Services on a Win2003 server.
>Just can't seem to find it.
>Any help will be appreciated.
>Ken
>"Chandan DUtta" wrote:
>> Hi Ken,
>> Can you check "Analysis Services" item in the same
screen as "add
>> Additional Components" of the same sqlserver
installation cd?
>> Thanks,
>> Dutta
>>
>> "KenM" wrote:
>> > I'm trying to install Analysis Services, and we have
a full enterprise msdn
>> > set,
>> > but when I go to add additional components I can't
fine Analysis Services on
>> > the April 2004 cd available. It doesn't appear to be
listed.
>> >
>> > Anyone have an idea of what's up with that?
>> >
>> > KenM
>.
>