KDC Problem: install

Showing posts with label install. Show all posts

Friday, March 30, 2012

Knowledge Base-article - 829386 - Hotfix where to find it ?

Hi there !
I need to find the Hotfix as stated in this artickel Knowledge Base-article - 829386
(You Cannot Install MSDE 2000 if the Server Service Is Not Running)
http://support.microsoft.com/default...b;en-us;829386
anyone know where to find it ?
You need to call Microsoft to get this hotfix, they do not generally post these fixes on web as they say these are not tested a lot. So when you call em they will email you the file along with the instructions. The kb article has the link to Microsoft'
s phone numbers.
good luck
dev
|||Yes, did you read the article? Since the hotfix is not fully regression
tested, you need to open a specific case with Microsoft in order to receive
the fix.
<snip>
To resolve this problem immediately, contact Microsoft Product Support
Services to obtain the hotfix. For a complete list of Microsoft Product
Support Services phone numbers and information about support costs, visit
the following Microsoft Web site:
http://support.microsoft.com/default.aspx?scid=fh;[LN];CNTACTMS
</snip>
Usually you will not be charged for the call, since the issue has been
confirmed by Microsoft to be a bug. However I would make sure that you
can't work around the problem in other ways (e.g. maybe starting the Server
service?).
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Troels Majlandt" <tm@.dfif.dk> wrote in message
news:36A784EB-2F40-4329-A719-0EFF53FF3929@.microsoft.com...
> Hi there !
> I need to find the Hotfix as stated in this artickel Knowledge
> Base-article - 829386
> (You Cannot Install MSDE 2000 if the Server Service Is Not Running)
> http://support.microsoft.com/default...b;en-us;829386
> anyone know where to find it ?

Monday, March 26, 2012

Killing bug in ASP.Net 2, Report server is dead, 100% guaranteed

Hi,

I posted a message to the install forum a few days ago and no answers were made so far. This bug is 100% reproducible and kills Report Server.

I am cross-posting here with the hope that someone in Microsoft will take note and eventually give a solution.

If you go to the IIS6 ReportServer VD and click on the ASP.net 2 config button, You Kill Report Server.

Complete details are in this post

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=250225&SiteID=1

Thanks,

Philippe

Hi,

We have found the solution to this issue.

Just remove this

xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"

From the WEB.config file in both ReportServer and ReportManager folders

Philippe

Killer problem with Scheduled Reports

I'm running on SQL 2000 with SRS. Standard install (I think, it was all set up by IT)

I have reports that run fine in the Report Manager but when they are run through a schedule (email) some of them (albeit most) "rsProcessingAborted" because of a report error.

Looking at the logs it seems generally based around comparison failure because of datatypes, eg (from the logs):

Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The processing of sort expression for the list 'List1' cannot be performed. The comparison failed. Please check the data type returned by sort expression. Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The processing of group expression for the table 'tblGroupTable' cannot be performed. The comparison failed. Please check the data type returned by group expression.

Now, when I remove sorting/grouping the reports run through the schedule OK; but that is obviously NOT what I want the report to look like. But it proves that the sorting/grouping has something to do with the problem.

I'm pretty sure that they are NOT the problem though, as the reports render in Report Manager fine with all the original sorting/grouping in place (ie no problems during development, just when we wanted them served to the employees. Isn't that always the way it goes?). We've even had some reports which scheduled OK previously, but throw errors now.

I'm at a loss!!

Could it be a time-out issue somewhere? If so: where? Looking at the Execution Logs, the reports that fail have unusually long Process Times, with a Data Retrieval Time of 0. I guess that the process time is longer because of processing the error, but does the Data Retrieval time of 0 mean that no data was delivered to the report? How can that be? IT tell me it can't be memory issues as it's sitting on a 2GB machine, but could there be something else with SQL set-up? I googled the error and found a few pages where people said that puting SRS in its own application pool fixed their problem. When I passed this on to IT they said that would only help memory... Any ideas?

Any suggestions greatfully appreciated

Do the report subscriptions ALWAYS fail, or intermittently?

Do those same reports ALWAYS succeed when executed live?

How much RAM is on the Dev machine, and what OS?

What OS is on the productio machine?

What changed between the time that some scheduled reports worked fine, and when they started erroring?

Removing the grouping/sorting may have alleviated the load on the processing engine enough so that the report succeeded.

|||Also, what are the types and #'s of CPU's on the Dev and Production machines?|||

Mike Schetterer -- MSFT wrote:
Do the report subscriptions ALWAYS fail, or intermittently?

The reports seem to fail always when they contain some data. Maybe the oposite is better: The reports don't fail when they do not contain data. Of the report I can remember off the top of my head: the schedule didn't fail on 4 occasions, three of those didn't have any data, one had one record.

For example, for one of our reports that is meant to run this morning:

Time Start

Time End

Data Retrieval

Process

Render

Status

User Name

pmtStartDate=01/01/2000 00:00:00
pmtEndDate=02/06/2006 00:00:00
Team=3

6/02/2006 7:00:08 AM

6/02/2006 7:00:09 AM

112

rsProcessingAborted

NT AUTHORITY\NETWORK SERVICE

pmtStartDate=01/01/2000 00:00:00
pmtEndDate=02/06/2006 00:00:00
Team=8

6/02/2006 7:00:08 AM

6/02/2006 7:00:12 AM

2979

359

255

rsSuccess

NT AUTHORITY\NETWORK SERVICE

pmtStartDate=01/01/2000 00:00:00
pmtEndDate=02/06/2006 00:00:00
Team=6

6/02/2006 7:00:57 AM

6/02/2006 7:00:58 AM

rsProcessingAborted

NT AUTHORITY\NETWORK SERVICE

pmtStartDate=01/01/2000 00:00:00
pmtEndDate=02/06/2006 00:00:00
Team=11

6/02/2006 7:00:57 AM

6/02/2006 7:00:58 AM

rsProcessingAborted

NT AUTHORITY\NETWORK SERVICE

pmtStartDate=01/01/2000 00:00:00
pmtEndDate=02/06/2006 00:00:00
Team=13

6/02/2006 7:00:58 AM

rsProcessingAborted

NT AUTHORITY\NETWORK SERVICE

pmtStartDate=01/01/2000 00:00:00
pmtEndDate=02/06/2006 00:00:00
Team=1

6/02/2006 7:00:58 AM

rsProcessingAborted

NT AUTHORITY\NETWORK SERVICE

pmtStartDate=01/01/2000 00:00:00
pmtEndDate=02/06/2006 00:00:00
Team=9

6/02/2006 7:00:59 AM

rsProcessingAborted

NT AUTHORITY\NETWORK SERVICE

pmtStartDate=01/01/2000 00:00:00
pmtEndDate=02/06/2006 00:00:00
Team=10

6/02/2006 7:00:59 AM

rsProcessingAborted

NT AUTHORITY\NETWORK SERVICE

Mike Schetterer -- MSFT wrote:
Do those same reports ALWAYS succeed when executed live?

YES!

Mike Schetterer -- MSFT wrote:
How much RAM is on the Dev machine, and what OS?

Intel Xeon 2.4Gb x 2, 2Gb Ram

The Dev machine and the production machine are the same. I use a Remote Desktop into the production machine from my desktop, I guess the documents are stored on my workstation and deployed to the production machine.

Mike Schetterer -- MSFT wrote:
What OS is on the productio machine?

Windows Server 2003, SP1

Mike Schetterer -- MSFT wrote:
What changed between the time that some scheduled reports worked fine, and when they started erroring?

Nothing that I am aware of... but I'll ask the IT people...

Mike Schetterer -- MSFT wrote:
Removing the grouping/sorting may have alleviated the load on the processing engine enough so that the report succeeded.

The schedules fail regardless of the time of day they run (I wondered if the server got overloaded whilst trying to do other things): but there is no difference.

Another interesting fact: whilst investigating I discovered that one of the reports that ran through a schedule after all grouping and sorting was removed displayed "#error" in a cell that contained the result from a Library I'd written. Though this report runs and displays fine through the Report Manager! (this field was not used in the grouping or sorting either).

Yes, I've read somewhere else that how you've configured the Application Pool can make a difference (our IT said it wouldn't here). But I've definitely read in a different forum that that fixed their problem.

At the moment the Report Server Interface and the Report Server are in the DefaultAppPool.

Thanks for your interest!

Perry

|||

Do your reports have parameters?

When you create your subscription - are the parameters set staticly or are the based on a query. If they're query based - can you try running the query and selecting some of the value combinations you receive in return through the UI to see if they work?

Your comment above about report executions failing when there is data, but succeeding when there is no data - is it true to say that whenever there is data the subscription fails, or just some of the time?

Thanks,

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Lukasz Pawlowski -- MS wrote:
Do your reports have parameters?

Some do, others don't, but it doesn't seem to be a problem.

Lukasz Pawlowski -- MS wrote:
When you create your subscription - are the parameters set staticly or are the based on a query. If they're query based - can you try running the query and selecting some of the value combinations you receive in return through the UI to see if they work?

Both, or sometimes all three (included type in)

Yes, ALL the reports run fine through the Report Manager.

Lukasz Pawlowski -- MS wrote:
Your comment above about report executions failing when there is data, but succeeding when there is no data - is it true to say that whenever there is data the subscription fails, or just some of the time?

No: they fail most of the time. In the section of the ExecutionLog in a previous post you can see that for that report it ran once (with data) and failed the rest (they would have had data too.

Thanks,

Perry

|||

What are the group and sort expressions from the report that you find is failing?

-Lukasz

|||

Lukasz Pawlowski -- MS wrote:
What are the group and sort expressions from the report that you find is failing?

In every case it's "=Fields!FieldName.value"

Perry

Friday, February 24, 2012

Keep getting update

I keep getting a critical update for SQL Server 2000 Desktop Engine(Windows)
in Window Server 2003(KB829358), I install the update and it keeps
redownloading the update. Can anyone help me with this issueHi Lloyd
Check the version you are currently on and see if it is higher than
8.00.0884, if it is then you may not need the update and might be able to
remove it by using the custom install and checking the don't show this update
option.
If you want to install it manual it can be download from
http://www.microsoft.com/downloads/details.aspx?familyid=814c230b-5c53-453f-810a-b9505acf1392&displaylang=en.
Also make sure that your account has enough permissions to install the
update and update the registry.
John
"Lloyd Pratt" wrote:
> I keep getting a critical update for SQL Server 2000 Desktop Engine(Windows)
> in Window Server 2003(KB829358), I install the update and it keeps
> redownloading the update. Can anyone help me with this issue
>

Keep getting update

I keep getting a critical update for SQL Server 2000 Desktop Engine(Windows)
in Window Server 2003(KB829358), I install the update and it keeps
redownloading the update. Can anyone help me with this issue
Hi Lloyd
Check the version you are currently on and see if it is higher than
8.00.0884, if it is then you may not need the update and might be able to
remove it by using the custom install and checking the don't show this update
option.
If you want to install it manual it can be download from
http://www.microsoft.com/downloads/d...isplaylang=en.
Also make sure that your account has enough permissions to install the
update and update the registry.
John
"Lloyd Pratt" wrote:

> I keep getting a critical update for SQL Server 2000 Desktop Engine(Windows)
> in Window Server 2003(KB829358), I install the update and it keeps
> redownloading the update. Can anyone help me with this issue
>

Keep getting update

I keep getting a critical update for SQL Server 2000 Desktop Engine(Windows)
in Window Server 2003(KB829358), I install the update and it keeps
redownloading the update. Can anyone help me with this issueHi Lloyd
Check the version you are currently on and see if it is higher than
8.00.0884, if it is then you may not need the update and might be able to
remove it by using the custom install and checking the don't show this updat
e
option.
If you want to install it manual it can be download from
http://www.microsoft.com/downloads/...displaylang=en.
Also make sure that your account has enough permissions to install the
update and update the registry.
John
"Lloyd Pratt" wrote:

> I keep getting a critical update for SQL Server 2000 Desktop Engine(Window
s)
> in Window Server 2003(KB829358), I install the update and it keeps
> redownloading the update. Can anyone help me with this issue
>

Monday, February 20, 2012

keep 2000 with 2005 install?

hi,
I had sql server 2000 on my machine and recently installed 2005, it
removed the 2000 tools that I had, I know 2005 is suppose to be an
improvement of 2000, but I wanted to keep using my 2000 tools until I
get use to everything in 2005, is there anyway for me to get the 2000
tools back?
Thank you.You must have done an upgrade?!
You could try to reinstall sql2k but only select "Client Tools" option.
-oj
"phil2phil" <philtwophil@.yahoo.com> wrote in message
news:1149628854.682532.227770@.u72g2000cwu.googlegroups.com...
> hi,
> I had sql server 2000 on my machine and recently installed 2005, it
> removed the 2000 tools that I had, I know 2005 is suppose to be an
> improvement of 2000, but I wanted to keep using my 2000 tools until I
> get use to everything in 2005, is there anyway for me to get the 2000
> tools back?
> Thank you.
>

keep 2000 with 2005 install?

hi,
I had sql server 2000 on my machine and recently installed 2005, it
removed the 2000 tools that I had, I know 2005 is suppose to be an
improvement of 2000, but I wanted to keep using my 2000 tools until I
get use to everything in 2005, is there anyway for me to get the 2000
tools back?
Thank you.You must have done an upgrade?!
You could try to reinstall sql2k but only select "Client Tools" option.
--
-oj
"phil2phil" <philtwophil@.yahoo.com> wrote in message
news:1149628854.682532.227770@.u72g2000cwu.googlegroups.com...
> hi,
> I had sql server 2000 on my machine and recently installed 2005, it
> removed the 2000 tools that I had, I know 2005 is suppose to be an
> improvement of 2000, but I wanted to keep using my 2000 tools until I
> get use to everything in 2005, is there anyway for me to get the 2000
> tools back?
> Thank you.
>

KB921896 updates did not install error code 0x3b0c

Hi,

I tried to instal KB921896 and get: updates did not install error code 0x3b0c.

In one of the summaries, I have

Product Installation Status
Product : Express Database Services Adv (WSUS)
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR_ADV.EXE
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
Error Number : 15116
Error Description : Unable to install Windows Installer MSI file

How do I fix this?

thanks

Can you search the log file it supplied and see if you can find the text string "value 3"? The log appears to be located at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR_ADV.EXE

Thanks,
Sam Lester (MSFT)

|||

Additionally, can you post the entire summary.txt?

Thanks,

Peter

|||

I am getting the same error and here is the summary text:

Time: 04/19/2007 11:59:54.299
KB Number: KB921896
Machine: A001352
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
/quiet
/allinstances
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Express Database Services (SQLEXPRESS) ENU RTM 2005.090.1399.00 x86 EXPRESS

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR.EXE
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
Error Number : 5118
Error Description : Unable to install Windows Installer MSI file
-

**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 5118

KB921896 updates did not install error code 0x3b0c

Hi,

I tried to instal KB921896 and get: updates did not install error code 0x3b0c.

In one of the summaries, I have

How do I fix this?

thanks

Thanks,
Sam Lester (MSFT)

|||

Additionally, can you post the entire summary.txt?

Thanks,

Peter

|||

I am getting the same error and here is the summary text:

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 5118

KB921896 updates did not install error code 0x3b0c

Hi,

I tried to instal KB921896 and get: updates did not install error code 0x3b0c.

In one of the summaries, I have

How do I fix this?

thanks

Thanks,
Sam Lester (MSFT)

|||

Additionally, can you post the entire summary.txt?

Thanks,

Peter

|||

I am getting the same error and here is the summary text:

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 5118

Friday, March 30, 2012

Knowledge Base-article - 829386 - Hotfix where to find it ?

Monday, March 26, 2012

Killing bug in ASP.Net 2, Report server is dead, 100% guaranteed

Killer problem with Scheduled Reports

Friday, February 24, 2012

Keep getting update

Keep getting update

Keep getting update

Monday, February 20, 2012

keep 2000 with 2005 install?

keep 2000 with 2005 install?

KB921896 updates did not install error code 0x3b0c

KB921896 updates did not install error code 0x3b0c

KB921896 updates did not install error code 0x3b0c

KDC Problem

Blog Archive

About Me