Runtime error while installing SQL 2005 Standard Edition

Dear All,
I have an instance of SQL 2000 and while Installing another instance of SQL
Server2005 Standard Edition on Windows 2003 with SP1 on Dell Server, I am
getting error
Microsoft Visual C++ Runtime Library
Runtime Error!
Program: C:\WINDOWS\system32\MsiExec.exe
The application has requested the Runtime to terminate it in an
unusual way.
Please contact the application's support team for more information.
All the hardware and software requirements are already there.
Any suggestions!
TIA
KayHi Kay
A couple of this to check
Make sure that you are up-to-date with windows update. Your hardware drivers
are the latest (especially video!). Also check out the SQL Server
installation log files http://msdn2.microsoft.com/en-us/library/ms143702.aspx
John
"Kay" wrote:
> Dear All,
> I have an instance of SQL 2000 and while Installing another instance of SQL
> Server2005 Standard Edition on Windows 2003 with SP1 on Dell Server, I am
> getting error
> Microsoft Visual C++ Runtime Library
> Runtime Error!
> Program: C:\WINDOWS\system32\MsiExec.exe
> The application has requested the Runtime to terminate it in an
> unusual way.
> Please contact the application's support team for more information.
>
> All the hardware and software requirements are already there.
> Any suggestions!
> TIA
> Kay
>
>

Runningvalue in graph

g:\surround\reportingservice\c5\c5 standard rapporter\Finans rapport.rdl
The
expression for the chart 'chart1' has a scope parameter that is not valid
for RunningValue, RowNumber or Previous. The scope parameter must be set
to
a string constant that is equal to the name of a containing group within
the
matrix 'chart1'.
I get that error when trying to make a running value in a chart.
I need to have the months summed together month for month to show the
progress between different fiscal years and budget, now it shows each
months
values.
this is the expression
=RunningValue(Fields!belxbdkk.Value, Sum, 'chart1')
Chart1 is the name of the chart, I also tried with the
chart1_CategoryGroup1
in the region value but same result !
Jack
--
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at få 45077 spam-mails.
Betalende brugere får ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dkIs this RS 2000? RunningValues in charts are not supported in RS 2000, only
in RS 2005.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jack Nielsen" <no_spam jack.nielsen@.get2net.dk> wrote in message
news:ehm$ZVvvFHA.252@.TK2MSFTNGP09.phx.gbl...
> g:\surround\reportingservice\c5\c5 standard rapporter\Finans rapport.rdl
> The
> expression for the chart 'chart1' has a scope parameter that is not valid
> for RunningValue, RowNumber or Previous. The scope parameter must be set
> to
> a string constant that is equal to the name of a containing group within
> the
> matrix 'chart1'.
> I get that error when trying to make a running value in a chart.
> I need to have the months summed together month for month to show the
> progress between different fiscal years and budget, now it shows each
> months
> values.
> this is the expression
> =RunningValue(Fields!belxbdkk.Value, Sum, 'chart1')
> Chart1 is the name of the chart, I also tried with the
> chart1_CategoryGroup1
> in the region value but same result !
> Jack
>
>
> --
> Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
> Den har indtil videre sparet mig for at få 45077 spam-mails.
> Betalende brugere får ikke denne besked i deres e-mails.
> Hent gratis SPAMfighter her: www.spamfighter.dk
>|||Yes it is RS 2000, how is it possible to do make a chart where the months
are added to eachother each month, a temporary table ?
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> skrev i en meddelelse
news:%23LFJprwvFHA.596@.TK2MSFTNGP12.phx.gbl...
> Is this RS 2000? RunningValues in charts are not supported in RS 2000,
only
> in RS 2005.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Jack Nielsen" <no_spam jack.nielsen@.get2net.dk> wrote in message
> news:ehm$ZVvvFHA.252@.TK2MSFTNGP09.phx.gbl...
> > g:\surround\reportingservice\c5\c5 standard rapporter\Finans rapport.rdl
> > The
> > expression for the chart 'chart1' has a scope parameter that is not
valid
> > for RunningValue, RowNumber or Previous. The scope parameter must be
set
> > to
> > a string constant that is equal to the name of a containing group within
> > the
> > matrix 'chart1'.
> >
> > I get that error when trying to make a running value in a chart.
> >
> > I need to have the months summed together month for month to show the
> > progress between different fiscal years and budget, now it shows each
> > months
> > values.
> >
> > this is the expression
> >
> > =RunningValue(Fields!belxbdkk.Value, Sum, 'chart1')
> > Chart1 is the name of the chart, I also tried with the
> > chart1_CategoryGroup1
> > in the region value but same result !
> >
> > Jack
> >
> >
> >
> >
> > --
> > Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
> > Den har indtil videre sparet mig for at få 45077 spam-mails.
> > Betalende brugere får ikke denne besked i deres e-mails.
> > Hent gratis SPAMfighter her: www.spamfighter.dk
> >
> >
>|||Yes, for RS 2000 you should perform the calculation inside the query or in a
stored procedure.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jack Nielsen" <nospamjackd@.jackd.dk (Fjern nospam)> wrote in message
news:%23DFrJf2vFHA.3236@.TK2MSFTNGP14.phx.gbl...
> Yes it is RS 2000, how is it possible to do make a chart where the months
> are added to eachother each month, a temporary table ?
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> skrev i en
> meddelelse
> news:%23LFJprwvFHA.596@.TK2MSFTNGP12.phx.gbl...
>> Is this RS 2000? RunningValues in charts are not supported in RS 2000,
> only
>> in RS 2005.
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Jack Nielsen" <no_spam jack.nielsen@.get2net.dk> wrote in message
>> news:ehm$ZVvvFHA.252@.TK2MSFTNGP09.phx.gbl...
>> > g:\surround\reportingservice\c5\c5 standard rapporter\Finans
>> > rapport.rdl
>> > The
>> > expression for the chart 'chart1' has a scope parameter that is not
> valid
>> > for RunningValue, RowNumber or Previous. The scope parameter must be
> set
>> > to
>> > a string constant that is equal to the name of a containing group
>> > within
>> > the
>> > matrix 'chart1'.
>> >
>> > I get that error when trying to make a running value in a chart.
>> >
>> > I need to have the months summed together month for month to show the
>> > progress between different fiscal years and budget, now it shows each
>> > months
>> > values.
>> >
>> > this is the expression
>> >
>> > =RunningValue(Fields!belxbdkk.Value, Sum, 'chart1')
>> > Chart1 is the name of the chart, I also tried with the
>> > chart1_CategoryGroup1
>> > in the region value but same result !
>> >
>> > Jack
>> >
>> >
>> >
>> >
>> > --
>> > Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
>> > Den har indtil videre sparet mig for at få 45077 spam-mails.
>> > Betalende brugere får ikke denne besked i deres e-mails.
>> > Hent gratis SPAMfighter her: www.spamfighter.dk
>> >
>> >
>>
>|||I am using RS 2005 but still can't get the running value function to work.
The expression doesn't cause any errors - the totals simply don't "run".
They are plotted as single values. Any thoughts?
"Robert Bruckner [MSFT]" wrote:
> Yes, for RS 2000 you should perform the calculation inside the query or in a
> stored procedure.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Jack Nielsen" <nospamjackd@.jackd.dk (Fjern nospam)> wrote in message
> news:%23DFrJf2vFHA.3236@.TK2MSFTNGP14.phx.gbl...
> > Yes it is RS 2000, how is it possible to do make a chart where the months
> > are added to eachother each month, a temporary table ?
> >
> >
> > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> skrev i en
> > meddelelse
> > news:%23LFJprwvFHA.596@.TK2MSFTNGP12.phx.gbl...
> >> Is this RS 2000? RunningValues in charts are not supported in RS 2000,
> > only
> >> in RS 2005.
> >>
> >> -- Robert
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >>
> >> "Jack Nielsen" <no_spam jack.nielsen@.get2net.dk> wrote in message
> >> news:ehm$ZVvvFHA.252@.TK2MSFTNGP09.phx.gbl...
> >> > g:\surround\reportingservice\c5\c5 standard rapporter\Finans
> >> > rapport.rdl
> >> > The
> >> > expression for the chart 'chart1' has a scope parameter that is not
> > valid
> >> > for RunningValue, RowNumber or Previous. The scope parameter must be
> > set
> >> > to
> >> > a string constant that is equal to the name of a containing group
> >> > within
> >> > the
> >> > matrix 'chart1'.
> >> >
> >> > I get that error when trying to make a running value in a chart.
> >> >
> >> > I need to have the months summed together month for month to show the
> >> > progress between different fiscal years and budget, now it shows each
> >> > months
> >> > values.
> >> >
> >> > this is the expression
> >> >
> >> > =RunningValue(Fields!belxbdkk.Value, Sum, 'chart1')
> >> > Chart1 is the name of the chart, I also tried with the
> >> > chart1_CategoryGroup1
> >> > in the region value but same result !
> >> >
> >> > Jack
> >> >
> >> >
> >> >
> >> >
> >> > --
> >> > Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
> >> > Den har indtil videre sparet mig for at fÃ?Â¥ 45077 spam-mails.
> >> > Betalende brugere fÃ?Â¥r ikke denne besked i deres e-mails.
> >> > Hent gratis SPAMfighter her: www.spamfighter.dk
> >> >
> >> >
> >>
> >>
> >
> >
>
>|||I found a new thread where Robert Bruckner answers this question. The thread
is titled RunningValue in a chart - scope issues. My issue was using a
category group rather than a series group. Works great now.
"john" wrote:
> I am using RS 2005 but still can't get the running value function to work.
> The expression doesn't cause any errors - the totals simply don't "run".
> They are plotted as single values. Any thoughts?
> "Robert Bruckner [MSFT]" wrote:
> > Yes, for RS 2000 you should perform the calculation inside the query or in a
> > stored procedure.
> >
> > -- Robert
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "Jack Nielsen" <nospamjackd@.jackd.dk (Fjern nospam)> wrote in message
> > news:%23DFrJf2vFHA.3236@.TK2MSFTNGP14.phx.gbl...
> > > Yes it is RS 2000, how is it possible to do make a chart where the months
> > > are added to eachother each month, a temporary table ?
> > >
> > >
> > > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> skrev i en
> > > meddelelse
> > > news:%23LFJprwvFHA.596@.TK2MSFTNGP12.phx.gbl...
> > >> Is this RS 2000? RunningValues in charts are not supported in RS 2000,
> > > only
> > >> in RS 2005.
> > >>
> > >> -- Robert
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > >>
> > >>
> > >> "Jack Nielsen" <no_spam jack.nielsen@.get2net.dk> wrote in message
> > >> news:ehm$ZVvvFHA.252@.TK2MSFTNGP09.phx.gbl...
> > >> > g:\surround\reportingservice\c5\c5 standard rapporter\Finans
> > >> > rapport.rdl
> > >> > The
> > >> > expression for the chart 'chart1' has a scope parameter that is not
> > > valid
> > >> > for RunningValue, RowNumber or Previous. The scope parameter must be
> > > set
> > >> > to
> > >> > a string constant that is equal to the name of a containing group
> > >> > within
> > >> > the
> > >> > matrix 'chart1'.
> > >> >
> > >> > I get that error when trying to make a running value in a chart.
> > >> >
> > >> > I need to have the months summed together month for month to show the
> > >> > progress between different fiscal years and budget, now it shows each
> > >> > months
> > >> > values.
> > >> >
> > >> > this is the expression
> > >> >
> > >> > =RunningValue(Fields!belxbdkk.Value, Sum, 'chart1')
> > >> > Chart1 is the name of the chart, I also tried with the
> > >> > chart1_CategoryGroup1
> > >> > in the region value but same result !
> > >> >
> > >> > Jack
> > >> >
> > >> >
> > >> >
> > >> >
> > >> > --
> > >> > Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
> > >> > Den har indtil videre sparet mig for at fÃ?Â¥ 45077 spam-mails.
> > >> > Betalende brugere fÃ?Â¥r ikke denne besked i deres e-mails.
> > >> > Hent gratis SPAMfighter her: www.spamfighter.dk
> > >> >
> > >> >
> > >>
> > >>
> > >
> > >
> >
> >
> >

RunningValue crashes VS

I have a standard report with a bunch of fields and groups within a
table.
I've added a field for a running total:
Field is amount_rt
Definition is: =RunningValue(Fields!amount.Value,Sum,Nothing)
The second I try to preview the report or deploy it, VS crashes.
I figured it might be something with my data, so I changed
Fields!amount.Value to Fields!test.Value where test = 1
Same thing.
The error message gives me no detail whatsoever.
Has anyone seen this before?
ThanksDid you create this field by going to your dataset and adding a newfield, or
just by code in a textbox or table?
<bigbrorpi@.gmail.com> wrote in message
news:1156263917.161190.3160@.b28g2000cwb.googlegroups.com...
>I have a standard report with a bunch of fields and groups within a
> table.
> I've added a field for a running total:
> Field is amount_rt
> Definition is: =RunningValue(Fields!amount.Value,Sum,Nothing)
> The second I try to preview the report or deploy it, VS crashes.
> I figured it might be something with my data, so I changed
> Fields!amount.Value to Fields!test.Value where test = 1
> Same thing.
> The error message gives me no detail whatsoever.
> Has anyone seen this before?
> Thanks
>

Running SSIS Packages in Management Studio

We are using SQL Server 2005 Standard edition.We have the development studio installed on a developer’s workstation.The SSIS package is accessing network folders using UNC and the tasks in packages are accessing SQL Server with a SQL Server id.

The SSIS package runs fine on the workstation. We deploy the SSIS package as a SSIS store on SQL Server.I receive Error 18456 Severity 14 State 8 error when I run the SSIS package as a SQL Agent job.

When I run the SSIS package from the Integration Services Management Studio, I get The AcquireConnection method call to the connection manager "dboSQLabm" failed with error code 0xC0202009.

I’m sure this is a permission based problem since it runs fine on my workstation.I tried logon onto the SQL Server with my id (I’m an admin to the server).I tried running the agent with my windows id.It looks like I’m getting problem connecting to the SQL Server tables since the logs are properly written to the network drive.

In SQL DTS 2000, all we needed to do was give the SQL agent id permission to the network folder. I tried to search the forums, but none of the solutions seem to work for my situation.

Do you use config files and do not save sensitive? This should take care of this issue.

There are quite a few posts about it in this forum

Philippe

|||The problem I was getting occurred whether I used a config file or not. I had the package set to EncryptSensitiveWithUserKey. I created another thread to get production deployment suggestions. We don't want our DBAs using BIDS to edit SQL connection manager settings when they migrate SSIS packages to production.|||

Then don't let them. Use configurations and the deployment wizard.

-Jamie