After I install SP1 of SP2 for reporting services, I get the following
error:
The version of the report server database is either in a format that is
not
valid, or it cannot be read. The found version is 'C.0.6.54'. The
expected
version is 'C.0.6.43'. To continue, update the version of the report
server
database and verify access rights. (rsInvalidReportServerDatabase)
I am currently running RS enteprise edition with SQL server 2000
Standard edition.
When I used to have RS std. edition with SQL server 2000 std.edition,
I've applied both service packs and didn't get the error.
Can you help me with this problem?
Thanks,If you already installed SP2, you can not install SP1 afterwards and
you do not need to.
Service Packs are cumulative - they contain everything from prior
service packs.
bevarg wrote:
> After I install SP1 of SP2 for reporting services, I get the following
> error:
> The version of the report server database is either in a format that is
> not
> valid, or it cannot be read. The found version is 'C.0.6.54'. The
> expected
> version is 'C.0.6.43'. To continue, update the version of the report
> server
> database and verify access rights. (rsInvalidReportServerDatabase)
> I am currently running RS enteprise edition with SQL server 2000
> Standard edition.
> When I used to have RS std. edition with SQL server 2000 std.edition,
> I've applied both service packs and didn't get the error.
> Can you help me with this problem?
> Thanks,
Showing posts with label following. Show all posts
Showing posts with label following. Show all posts
Friday, March 30, 2012
Help!!! launching report builder from url is adding .rdl to name when saving.
Hi,
When I launch a report using the following url, and then make changes to the report and save it, Reportbuilder is creating another report with the same name but also including the .rdl within the name itself.. therfore I now have two reports now displayed within the report manager
http://localhost/reportserver/reportbuilder/reportbuilder.application?/Report1
Can someone please help...
Hi,
this issue was resolved by applying SP2
thanks.
|||or:
the same rdl has been uploaded directly using Report Manager and Published in Visual Studio at the same time...
Help!!! launching report builder from url is adding .rdl to name when saving.
Hi,
When I launch a report using the following url, and then make changes to the report and save it, Reportbuilder is creating another report with the same name but also including the .rdl within the name itself.. therfore I now have two reports now displayed within the report manager
http://localhost/reportserver/reportbuilder/reportbuilder.application?/Report1
Can someone please help...
Hi,
this issue was resolved by applying SP2
thanks.
|||or:
the same rdl has been uploaded directly using Report Manager and Published in Visual Studio at the same time...
HELP!!!
please help me create the table for the data in the following data lines
after this
i am out of my wits to thing for what data type to use. because for
everything i tried i got the error below the column name will be for the
table i appreciate a lot if someone can help me .
column 1 column 2 column 3
OMIM_Name No.of av Description
100650 .0001 ALCOHOL INTOLERANCE, ACUTE ACETALDEHYDE DEHYDROGENASE 2, ALLELE
2, INCLUDED; ALDH2*2, INCLUDED ALDH2, GLU487LYS The ALDH2*2-encoded protein
has a change from glutamic acid (glutamate) to lysine at residue 487 (Yoshid
a
et al., 1984). Hempel et al. (1985) and Hsu et al. (1985) also showed that
the catalytic deficiency in mitochondrial ALDH in Orientals can be traced to
a structural point mutation at amino acid position 487 of the polypeptide. A
substitution of lysine for glutamic acid results from a transition of G-C to
A-T. To study the mechanism by which the ALDH2*2 allele exerts its dominant
effect in decreasing ALDH2 activity in liver extracts and producing cutaneou
s
flushing when the subject drinks alcohol, Xiao et al. (1995) cloned ALDH2*1
cDNA and generated the ALDH2*2 allele by site-directed mutagenesis. These
cDNAs were transduced using retroviral vectors into HeLa and CV1 cells, whic
h
do not express ALDH2. The normal allele directed synthesis of immunoreactive
ALDH2 protein with the expected isoelectric point and increased aldehyde
dehydrogenase activity. The ALDH2*2 allele directed synthesis of mRNA and
immunoreactive protein, but the protein lacked enzymatic activity. When
ALDH2*1-expressing cells were transduced with ALDH2*2 vectors, both mRNAs
were expressed and immunoreactive proteins with isoelectric points ranging
between those of the 2 gene products were present, indicating that the
subunits formed heteromers. ALDH2 activity in these cells was reduced below
that of the parental ALDH2*1-expressing cells. Thus, the authors concluded
that ALDH2*2 allele is sufficient to cause ALDH2 deficiency in vitro. Xiao e
t
al. (1996) referred to the ALDH2 enzyme encoded by the ALDH2*1 allele (the
wildtype form) as ALDH2E and the enzyme subunit encoded by ALDH2*2 as ALDH2K
.
They found that the ALDH2E enzyme was very stable, with a half-life of at
least 22 hours. ALDH2K, on the other hand, had an enzyme half-life of only 1
4
hours. In cells expressing both subunits, most of the subunits assemble as
heterotetramers, and these enzymes had a half-life of 13 hours. Thus, the
effect of ALDH2K on enzyme turnover is dominant. Their studies indicated tha
t
ALDH2*2 exerts its dominant effect both by interfering with the catalytic
activity of the enzyme and by increasing its turnover. Because genetic
epidemiologic studies have suggested a mechanism by which homozygosity for
the ALDH2*2 allele inhibits the development of alcoholism in Asians, Peng et
al. (1999) recruited 18 adult Han Chinese men, matched by age, body-mass
index, nutritional state, and homozygosity at the ALDH2 gene loci from a
population of 273 men. Six individuals were chosen for each of the 3 ALDH2
allotypes, i.e., 2 homozygotes and 1 heterozygote. Following a low dose of
ethanol, homozygous ALDH2*2 individuals were found to be strikingly
responsive with pronounced cardiovascular hemodynamic effects as well as
subjective perception of general discomfort for as long as 2 hours following
ingestion. Among 71 Japanese nondrinkers and 268 drinkers of alcohol, Liu et
al. (2005) found that drinkers had a significantly higher frequency of the
487glu allele. Individuals with the 487lys allele had an increased risk of
alcohol-induced flushing (odds ratio of 33.0)
100690 .0001 MYASTHENIC SYNDROME, CONGENITAL, SLOW-CHANNEL CHRNA1, ASN217LYS
In a 30-year-old woman with slow-channel congenital myasthenic syndrome
(601462), Engel et al. (1996) identified a heterozygous 651C-G transversion
in exon 6 of the CHRNA1 gene, resulting in an asn217-to-lys (N217K)
substitution at a conserved residue in the M1 transmembrane domain. The
mutation cosegregated with the disease through 3 generations. Functional
expression studies showed that the N217K mutation slowed the rate of AChR
channel closure, increased the apparent affinity for ACh, and enhanced
desensitization. Cationic overload of the postsynaptic region caused an
endplate myopathy
100690 .0002 MYASTHENIC SYNDROME, CONGENITAL, SLOW-CHANNEL CHRNA1, VAL156MET
In a patient with SCCMS (601462), Croxen et al. (1997) identified a
heterozygous 466G-A transition in the CHRNA1 gene, resulting in a
val156-to-met (V156M) substitution in a putative ACh-binding region of the
protein. Functional studies suggested that the V156M mutation stabilizes the
open state of the AChR channel
100690 .0003 MYASTHENIC SYNDROME, CONGENITAL, SLOW-CHANNEL CHRNA1, THR254ILE
In a 60-year-old woman whose myasthenic syndrome (SCCMS; 601462) had first
become symptomatic at the age of 16, Croxen et al. (1997) identified a
heterozygous 761C-T transition in the CHRNA1 gene, resulting in a
thr254-to-ile (T254I) substitution in the M2 transmembrane domain which line
s
the AChR channel pore. The patient was previously reported by Chauplannaz an
d
Bady (1994). Functional expression studies suggested that the T254I mutation
stabilized the open state of the AChR channel
C:\Disease_Database_TongBoon_Dec2005_Mar
ch2006\Results>bcp OMIM.dbo.av in
AVoutp
ut_less_then_100.txt -c -T
Starting copy...
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
BCP copy in failedGood god! Please post a description of the source data, rather than posting
a
big blob. Also see http://www.aspfaq.com/etiquette.asp?id=5006 for some
pointers.
How are you importing this? Where are you importing it to? Where is it from?
What is the structure of the source, and what of the destination?
ML
http://milambda.blogspot.com/|||What vesrion are you using?
"urgent" <urgent@.discussions.microsoft.com> wrote in message
news:89CCAC1D-8F47-4D01-A35D-25254C26BD9B@.microsoft.com...
> please help me create the table for the data in the following data lines
> after this
> i am out of my wits to thing for what data type to use. because for
> everything i tried i got the error below the column name will be for the
> table i appreciate a lot if someone can help me .
>
> column 1 column 2 column 3
> OMIM_Name No.of av Description
> 100650 .0001 ALCOHOL INTOLERANCE, ACUTE ACETALDEHYDE DEHYDROGENASE 2,
> ALLELE
> 2, INCLUDED; ALDH2*2, INCLUDED ALDH2, GLU487LYS The ALDH2*2-encoded
> protein
> has a change from glutamic acid (glutamate) to lysine at residue 487
> (Yoshida
> et al., 1984). Hempel et al. (1985) and Hsu et al. (1985) also showed that
> the catalytic deficiency in mitochondrial ALDH in Orientals can be traced
> to
> a structural point mutation at amino acid position 487 of the polypeptide.
> A
> substitution of lysine for glutamic acid results from a transition of G-C
> to
> A-T. To study the mechanism by which the ALDH2*2 allele exerts its
> dominant
> effect in decreasing ALDH2 activity in liver extracts and producing
> cutaneous
> flushing when the subject drinks alcohol, Xiao et al. (1995) cloned
> ALDH2*1
> cDNA and generated the ALDH2*2 allele by site-directed mutagenesis. These
> cDNAs were transduced using retroviral vectors into HeLa and CV1 cells,
> which
> do not express ALDH2. The normal allele directed synthesis of
> immunoreactive
> ALDH2 protein with the expected isoelectric point and increased aldehyde
> dehydrogenase activity. The ALDH2*2 allele directed synthesis of mRNA and
> immunoreactive protein, but the protein lacked enzymatic activity. When
> ALDH2*1-expressing cells were transduced with ALDH2*2 vectors, both mRNAs
> were expressed and immunoreactive proteins with isoelectric points ranging
> between those of the 2 gene products were present, indicating that the
> subunits formed heteromers. ALDH2 activity in these cells was reduced
> below
> that of the parental ALDH2*1-expressing cells. Thus, the authors concluded
> that ALDH2*2 allele is sufficient to cause ALDH2 deficiency in vitro. Xiao
> et
> al. (1996) referred to the ALDH2 enzyme encoded by the ALDH2*1 allele (the
> wildtype form) as ALDH2E and the enzyme subunit encoded by ALDH2*2 as
> ALDH2K.
> They found that the ALDH2E enzyme was very stable, with a half-life of at
> least 22 hours. ALDH2K, on the other hand, had an enzyme half-life of only
> 14
> hours. In cells expressing both subunits, most of the subunits assemble as
> heterotetramers, and these enzymes had a half-life of 13 hours. Thus, the
> effect of ALDH2K on enzyme turnover is dominant. Their studies indicated
> that
> ALDH2*2 exerts its dominant effect both by interfering with the catalytic
> activity of the enzyme and by increasing its turnover. Because genetic
> epidemiologic studies have suggested a mechanism by which homozygosity for
> the ALDH2*2 allele inhibits the development of alcoholism in Asians, Peng
> et
> al. (1999) recruited 18 adult Han Chinese men, matched by age, body-mass
> index, nutritional state, and homozygosity at the ALDH2 gene loci from a
> population of 273 men. Six individuals were chosen for each of the 3 ALDH2
> allotypes, i.e., 2 homozygotes and 1 heterozygote. Following a low dose of
> ethanol, homozygous ALDH2*2 individuals were found to be strikingly
> responsive with pronounced cardiovascular hemodynamic effects as well as
> subjective perception of general discomfort for as long as 2 hours
> following
> ingestion. Among 71 Japanese nondrinkers and 268 drinkers of alcohol, Liu
> et
> al. (2005) found that drinkers had a significantly higher frequency of the
> 487glu allele. Individuals with the 487lys allele had an increased risk of
> alcohol-induced flushing (odds ratio of 33.0)
> 100690 .0001 MYASTHENIC SYNDROME, CONGENITAL, SLOW-CHANNEL CHRNA1,
> ASN217LYS
> In a 30-year-old woman with slow-channel congenital myasthenic syndrome
> (601462), Engel et al. (1996) identified a heterozygous 651C-G
> transversion
> in exon 6 of the CHRNA1 gene, resulting in an asn217-to-lys (N217K)
> substitution at a conserved residue in the M1 transmembrane domain. The
> mutation cosegregated with the disease through 3 generations. Functional
> expression studies showed that the N217K mutation slowed the rate of AChR
> channel closure, increased the apparent affinity for ACh, and enhanced
> desensitization. Cationic overload of the postsynaptic region caused an
> endplate myopathy
> 100690 .0002 MYASTHENIC SYNDROME, CONGENITAL, SLOW-CHANNEL CHRNA1,
> VAL156MET
> In a patient with SCCMS (601462), Croxen et al. (1997) identified a
> heterozygous 466G-A transition in the CHRNA1 gene, resulting in a
> val156-to-met (V156M) substitution in a putative ACh-binding region of the
> protein. Functional studies suggested that the V156M mutation stabilizes
> the
> open state of the AChR channel
> 100690 .0003 MYASTHENIC SYNDROME, CONGENITAL, SLOW-CHANNEL CHRNA1,
> THR254ILE
> In a 60-year-old woman whose myasthenic syndrome (SCCMS; 601462) had first
> become symptomatic at the age of 16, Croxen et al. (1997) identified a
> heterozygous 761C-T transition in the CHRNA1 gene, resulting in a
> thr254-to-ile (T254I) substitution in the M2 transmembrane domain which
> lines
> the AChR channel pore. The patient was previously reported by Chauplannaz
> and
> Bady (1994). Functional expression studies suggested that the T254I
> mutation
> stabilized the open state of the AChR channel
>
> C:\Disease_Database_TongBoon_Dec2005_Mar
ch2006\Results>bcp OMIM.dbo.av in
> AVoutp
> ut_less_then_100.txt -c -T
> Starting copy...
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> BCP copy in failed
>|||
this is my new nick i am urgen log in with another email thi post is being
transfer to another title call trouble with bcp ....2005
after this
i am out of my wits to thing for what data type to use. because for
everything i tried i got the error below the column name will be for the
table i appreciate a lot if someone can help me .
column 1 column 2 column 3
OMIM_Name No.of av Description
100650 .0001 ALCOHOL INTOLERANCE, ACUTE ACETALDEHYDE DEHYDROGENASE 2, ALLELE
2, INCLUDED; ALDH2*2, INCLUDED ALDH2, GLU487LYS The ALDH2*2-encoded protein
has a change from glutamic acid (glutamate) to lysine at residue 487 (Yoshid
a
et al., 1984). Hempel et al. (1985) and Hsu et al. (1985) also showed that
the catalytic deficiency in mitochondrial ALDH in Orientals can be traced to
a structural point mutation at amino acid position 487 of the polypeptide. A
substitution of lysine for glutamic acid results from a transition of G-C to
A-T. To study the mechanism by which the ALDH2*2 allele exerts its dominant
effect in decreasing ALDH2 activity in liver extracts and producing cutaneou
s
flushing when the subject drinks alcohol, Xiao et al. (1995) cloned ALDH2*1
cDNA and generated the ALDH2*2 allele by site-directed mutagenesis. These
cDNAs were transduced using retroviral vectors into HeLa and CV1 cells, whic
h
do not express ALDH2. The normal allele directed synthesis of immunoreactive
ALDH2 protein with the expected isoelectric point and increased aldehyde
dehydrogenase activity. The ALDH2*2 allele directed synthesis of mRNA and
immunoreactive protein, but the protein lacked enzymatic activity. When
ALDH2*1-expressing cells were transduced with ALDH2*2 vectors, both mRNAs
were expressed and immunoreactive proteins with isoelectric points ranging
between those of the 2 gene products were present, indicating that the
subunits formed heteromers. ALDH2 activity in these cells was reduced below
that of the parental ALDH2*1-expressing cells. Thus, the authors concluded
that ALDH2*2 allele is sufficient to cause ALDH2 deficiency in vitro. Xiao e
t
al. (1996) referred to the ALDH2 enzyme encoded by the ALDH2*1 allele (the
wildtype form) as ALDH2E and the enzyme subunit encoded by ALDH2*2 as ALDH2K
.
They found that the ALDH2E enzyme was very stable, with a half-life of at
least 22 hours. ALDH2K, on the other hand, had an enzyme half-life of only 1
4
hours. In cells expressing both subunits, most of the subunits assemble as
heterotetramers, and these enzymes had a half-life of 13 hours. Thus, the
effect of ALDH2K on enzyme turnover is dominant. Their studies indicated tha
t
ALDH2*2 exerts its dominant effect both by interfering with the catalytic
activity of the enzyme and by increasing its turnover. Because genetic
epidemiologic studies have suggested a mechanism by which homozygosity for
the ALDH2*2 allele inhibits the development of alcoholism in Asians, Peng et
al. (1999) recruited 18 adult Han Chinese men, matched by age, body-mass
index, nutritional state, and homozygosity at the ALDH2 gene loci from a
population of 273 men. Six individuals were chosen for each of the 3 ALDH2
allotypes, i.e., 2 homozygotes and 1 heterozygote. Following a low dose of
ethanol, homozygous ALDH2*2 individuals were found to be strikingly
responsive with pronounced cardiovascular hemodynamic effects as well as
subjective perception of general discomfort for as long as 2 hours following
ingestion. Among 71 Japanese nondrinkers and 268 drinkers of alcohol, Liu et
al. (2005) found that drinkers had a significantly higher frequency of the
487glu allele. Individuals with the 487lys allele had an increased risk of
alcohol-induced flushing (odds ratio of 33.0)
100690 .0001 MYASTHENIC SYNDROME, CONGENITAL, SLOW-CHANNEL CHRNA1, ASN217LYS
In a 30-year-old woman with slow-channel congenital myasthenic syndrome
(601462), Engel et al. (1996) identified a heterozygous 651C-G transversion
in exon 6 of the CHRNA1 gene, resulting in an asn217-to-lys (N217K)
substitution at a conserved residue in the M1 transmembrane domain. The
mutation cosegregated with the disease through 3 generations. Functional
expression studies showed that the N217K mutation slowed the rate of AChR
channel closure, increased the apparent affinity for ACh, and enhanced
desensitization. Cationic overload of the postsynaptic region caused an
endplate myopathy
100690 .0002 MYASTHENIC SYNDROME, CONGENITAL, SLOW-CHANNEL CHRNA1, VAL156MET
In a patient with SCCMS (601462), Croxen et al. (1997) identified a
heterozygous 466G-A transition in the CHRNA1 gene, resulting in a
val156-to-met (V156M) substitution in a putative ACh-binding region of the
protein. Functional studies suggested that the V156M mutation stabilizes the
open state of the AChR channel
100690 .0003 MYASTHENIC SYNDROME, CONGENITAL, SLOW-CHANNEL CHRNA1, THR254ILE
In a 60-year-old woman whose myasthenic syndrome (SCCMS; 601462) had first
become symptomatic at the age of 16, Croxen et al. (1997) identified a
heterozygous 761C-T transition in the CHRNA1 gene, resulting in a
thr254-to-ile (T254I) substitution in the M2 transmembrane domain which line
s
the AChR channel pore. The patient was previously reported by Chauplannaz an
d
Bady (1994). Functional expression studies suggested that the T254I mutation
stabilized the open state of the AChR channel
C:\Disease_Database_TongBoon_Dec2005_Mar
ch2006\Results>bcp OMIM.dbo.av in
AVoutp
ut_less_then_100.txt -c -T
Starting copy...
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
BCP copy in failedGood god! Please post a description of the source data, rather than posting
a
big blob. Also see http://www.aspfaq.com/etiquette.asp?id=5006 for some
pointers.
How are you importing this? Where are you importing it to? Where is it from?
What is the structure of the source, and what of the destination?
ML
http://milambda.blogspot.com/|||What vesrion are you using?
"urgent" <urgent@.discussions.microsoft.com> wrote in message
news:89CCAC1D-8F47-4D01-A35D-25254C26BD9B@.microsoft.com...
> please help me create the table for the data in the following data lines
> after this
> i am out of my wits to thing for what data type to use. because for
> everything i tried i got the error below the column name will be for the
> table i appreciate a lot if someone can help me .
>
> column 1 column 2 column 3
> OMIM_Name No.of av Description
> 100650 .0001 ALCOHOL INTOLERANCE, ACUTE ACETALDEHYDE DEHYDROGENASE 2,
> ALLELE
> 2, INCLUDED; ALDH2*2, INCLUDED ALDH2, GLU487LYS The ALDH2*2-encoded
> protein
> has a change from glutamic acid (glutamate) to lysine at residue 487
> (Yoshida
> et al., 1984). Hempel et al. (1985) and Hsu et al. (1985) also showed that
> the catalytic deficiency in mitochondrial ALDH in Orientals can be traced
> to
> a structural point mutation at amino acid position 487 of the polypeptide.
> A
> substitution of lysine for glutamic acid results from a transition of G-C
> to
> A-T. To study the mechanism by which the ALDH2*2 allele exerts its
> dominant
> effect in decreasing ALDH2 activity in liver extracts and producing
> cutaneous
> flushing when the subject drinks alcohol, Xiao et al. (1995) cloned
> ALDH2*1
> cDNA and generated the ALDH2*2 allele by site-directed mutagenesis. These
> cDNAs were transduced using retroviral vectors into HeLa and CV1 cells,
> which
> do not express ALDH2. The normal allele directed synthesis of
> immunoreactive
> ALDH2 protein with the expected isoelectric point and increased aldehyde
> dehydrogenase activity. The ALDH2*2 allele directed synthesis of mRNA and
> immunoreactive protein, but the protein lacked enzymatic activity. When
> ALDH2*1-expressing cells were transduced with ALDH2*2 vectors, both mRNAs
> were expressed and immunoreactive proteins with isoelectric points ranging
> between those of the 2 gene products were present, indicating that the
> subunits formed heteromers. ALDH2 activity in these cells was reduced
> below
> that of the parental ALDH2*1-expressing cells. Thus, the authors concluded
> that ALDH2*2 allele is sufficient to cause ALDH2 deficiency in vitro. Xiao
> et
> al. (1996) referred to the ALDH2 enzyme encoded by the ALDH2*1 allele (the
> wildtype form) as ALDH2E and the enzyme subunit encoded by ALDH2*2 as
> ALDH2K.
> They found that the ALDH2E enzyme was very stable, with a half-life of at
> least 22 hours. ALDH2K, on the other hand, had an enzyme half-life of only
> 14
> hours. In cells expressing both subunits, most of the subunits assemble as
> heterotetramers, and these enzymes had a half-life of 13 hours. Thus, the
> effect of ALDH2K on enzyme turnover is dominant. Their studies indicated
> that
> ALDH2*2 exerts its dominant effect both by interfering with the catalytic
> activity of the enzyme and by increasing its turnover. Because genetic
> epidemiologic studies have suggested a mechanism by which homozygosity for
> the ALDH2*2 allele inhibits the development of alcoholism in Asians, Peng
> et
> al. (1999) recruited 18 adult Han Chinese men, matched by age, body-mass
> index, nutritional state, and homozygosity at the ALDH2 gene loci from a
> population of 273 men. Six individuals were chosen for each of the 3 ALDH2
> allotypes, i.e., 2 homozygotes and 1 heterozygote. Following a low dose of
> ethanol, homozygous ALDH2*2 individuals were found to be strikingly
> responsive with pronounced cardiovascular hemodynamic effects as well as
> subjective perception of general discomfort for as long as 2 hours
> following
> ingestion. Among 71 Japanese nondrinkers and 268 drinkers of alcohol, Liu
> et
> al. (2005) found that drinkers had a significantly higher frequency of the
> 487glu allele. Individuals with the 487lys allele had an increased risk of
> alcohol-induced flushing (odds ratio of 33.0)
> 100690 .0001 MYASTHENIC SYNDROME, CONGENITAL, SLOW-CHANNEL CHRNA1,
> ASN217LYS
> In a 30-year-old woman with slow-channel congenital myasthenic syndrome
> (601462), Engel et al. (1996) identified a heterozygous 651C-G
> transversion
> in exon 6 of the CHRNA1 gene, resulting in an asn217-to-lys (N217K)
> substitution at a conserved residue in the M1 transmembrane domain. The
> mutation cosegregated with the disease through 3 generations. Functional
> expression studies showed that the N217K mutation slowed the rate of AChR
> channel closure, increased the apparent affinity for ACh, and enhanced
> desensitization. Cationic overload of the postsynaptic region caused an
> endplate myopathy
> 100690 .0002 MYASTHENIC SYNDROME, CONGENITAL, SLOW-CHANNEL CHRNA1,
> VAL156MET
> In a patient with SCCMS (601462), Croxen et al. (1997) identified a
> heterozygous 466G-A transition in the CHRNA1 gene, resulting in a
> val156-to-met (V156M) substitution in a putative ACh-binding region of the
> protein. Functional studies suggested that the V156M mutation stabilizes
> the
> open state of the AChR channel
> 100690 .0003 MYASTHENIC SYNDROME, CONGENITAL, SLOW-CHANNEL CHRNA1,
> THR254ILE
> In a 60-year-old woman whose myasthenic syndrome (SCCMS; 601462) had first
> become symptomatic at the age of 16, Croxen et al. (1997) identified a
> heterozygous 761C-T transition in the CHRNA1 gene, resulting in a
> thr254-to-ile (T254I) substitution in the M2 transmembrane domain which
> lines
> the AChR channel pore. The patient was previously reported by Chauplannaz
> and
> Bady (1994). Functional expression studies suggested that the T254I
> mutation
> stabilized the open state of the AChR channel
>
> C:\Disease_Database_TongBoon_Dec2005_Mar
ch2006\Results>bcp OMIM.dbo.av in
> AVoutp
> ut_less_then_100.txt -c -T
> Starting copy...
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][SQL Native Client]String data, right truncation
> BCP copy in failed
>|||
this is my new nick i am urgen log in with another email thi post is being
transfer to another title call trouble with bcp ....2005
Help!! "The report server has encountered a configuration error........"
Hi There,
when i checked in msdn..there it says
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsServerConfigurationError.asp
I have installed Sql Server 2005 on my machine. I've managed to created report, but when i try to deploy e same, I'm getting e following error...am i missing something here?
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.
when i checked in msdn..there it says
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsServerConfigurationError.asp
Other info:
I have followed the Tutorial Project in SQL Books online. And for TargetURL, i have given --> http://localhost/reportserver
Report server is located in my local only
rsreportserver.config : I dint touch this file and mine is fresh installation.
Help please :)
Can you access Report Manager via Internet Explorer (http://server/reports) at all? Or does it throw the same/similar error?
It sounds to me like the account that SSRS is running under doesn't have the proper NTFS perms on the 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\' folder. Verify that that it does, or use the filemon tool from sysinternals.com to capture a log of what process (and which account) is getting denied...this will give you most of the info you'd need to fix the issue.
Good luck!
|||I experienced the problem described above and the filemon tool identified that the ASPNET user did not have read privileges to the .config file.
It seems strange that the server installation did not configure this correctly.. Setting privileges manually solved the problem..
Add ASPNET user to SQLServer2005Reporting ServicesWebServiceUsers$<MACHINE NAME> group, reboot your machine and it should start working properly.
|||You should be able to fix this as well by using the Report Server Configuration tool to set the web service identity.
-Lukasz
|||Web Service Identity is hard coded on the "Configure Report Server" page.|||Hi,
I am having similar issue trying to launch report services by http://localhost/reports. I got the following error
when try to launch it.
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
I used the Reporting Services Configuration tool to set all my virtual directory and etc... and verified that the report server is initiated and running. I have read other thread for similar issue, but none was able to provide a clear solution on how to resolve the problem. Any help would be appriciated.
|||Look in your log files and see if there is a detailed error message there. That's your best place to start.
-Lukasz
|||Hi,
I've look at the log file and it didn't help me much. Maybe you can point me to the right direction.
By the way, I am running Vista and using the Server 2005 eval edition. I don't know if this make any differences. I still couldn't get it took work for me. Any help would be greatly appriciate. The error i get is as follow when try to launch the report service using http://localhost/reports:
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3054.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__05_08_2007_10_17_13.log</Path>
<SystemName>ATS-PC</SystemName>
<OSName>Microsoft Windows NT 6.0.6000.0</OSName>
<OSVersion>6.0.6000.0</OSVersion>
</Header>
w3wp!webserver!1!5/8/2007-10:17:30:: i INFO: Reporting Web Server started
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Reporting Services starting SKU: Evaluation
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Evaluation copy: 175 days left
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!05/08/2007-10:17:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Catalog SQL Server Edition = Evaluation
w3wp!library!1!05/08/2007-10:17:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:38:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!5!05/08/2007-10:27:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!7!5/8/2007-10:27:31:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!5!05/08/2007-10:27:35:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:27:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
If you're running on Vista, you must install SQL Server SP2. Here are some KB articles that should help you out.
http://support.microsoft.com/kb/934164 (install)
http://support.microsoft.com/kb/934163 (upgrade)
-Lukasz
|||I had a similar problem. It turned out that since I had a named instance of SQL Server 2005 I had to reference that in the url. Specifically, it was http://localhost/ReportServer$NAMEOFSQLSERVERINSTANCE - CindyPsych
Help!! "The report server has encountered a configuration error........"
Hi There,
when i checked in msdn..there it says
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsServerConfigurationError.asp
I have installed Sql Server 2005 on my machine. I've managed to created report, but when i try to deploy e same, I'm getting e following error...am i missing something here?
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.
when i checked in msdn..there it says
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsServerConfigurationError.asp
Other info:
I have followed the Tutorial Project in SQL Books online. And for TargetURL, i have given --> http://localhost/reportserver
Report server is located in my local only
rsreportserver.config : I dint touch this file and mine is fresh installation.
Help please :)
Can you access Report Manager via Internet Explorer (http://server/reports) at all? Or does it throw the same/similar error?
It sounds to me like the account that SSRS is running under doesn't have the proper NTFS perms on the 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\' folder. Verify that that it does, or use the filemon tool from sysinternals.com to capture a log of what process (and which account) is getting denied...this will give you most of the info you'd need to fix the issue.
Good luck!
|||I experienced the problem described above and the filemon tool identified that the ASPNET user did not have read privileges to the .config file.
It seems strange that the server installation did not configure this correctly.. Setting privileges manually solved the problem..
Add ASPNET user to SQLServer2005Reporting ServicesWebServiceUsers$<MACHINE NAME> group, reboot your machine and it should start working properly.
|||You should be able to fix this as well by using the Report Server Configuration tool to set the web service identity.
-Lukasz
|||Web Service Identity is hard coded on the "Configure Report Server" page.|||Hi,
I am having similar issue trying to launch report services by http://localhost/reports. I got the following error
when try to launch it.
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
I used the Reporting Services Configuration tool to set all my virtual directory and etc... and verified that the report server is initiated and running. I have read other thread for similar issue, but none was able to provide a clear solution on how to resolve the problem. Any help would be appriciated.
|||Look in your log files and see if there is a detailed error message there. That's your best place to start.
-Lukasz
|||Hi,
I've look at the log file and it didn't help me much. Maybe you can point me to the right direction.
By the way, I am running Vista and using the Server 2005 eval edition. I don't know if this make any differences. I still couldn't get it took work for me. Any help would be greatly appriciate. The error i get is as follow when try to launch the report service using http://localhost/reports:
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3054.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__05_08_2007_10_17_13.log</Path>
<SystemName>ATS-PC</SystemName>
<OSName>Microsoft Windows NT 6.0.6000.0</OSName>
<OSVersion>6.0.6000.0</OSVersion>
</Header>
w3wp!webserver!1!5/8/2007-10:17:30:: i INFO: Reporting Web Server started
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Reporting Services starting SKU: Evaluation
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Evaluation copy: 175 days left
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!05/08/2007-10:17:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Catalog SQL Server Edition = Evaluation
w3wp!library!1!05/08/2007-10:17:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:38:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!5!05/08/2007-10:27:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!7!5/8/2007-10:27:31:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!5!05/08/2007-10:27:35:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:27:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
If you're running on Vista, you must install SQL Server SP2. Here are some KB articles that should help you out.
http://support.microsoft.com/kb/934164 (install)
http://support.microsoft.com/kb/934163 (upgrade)
-Lukasz
|||I had a similar problem. It turned out that since I had a named instance of SQL Server 2005 I had to reference that in the url. Specifically, it was http://localhost/ReportServer$NAMEOFSQLSERVERINSTANCE- CindyPsych
Help!! "The report server has encountered a configuration error........"
Hi There,
when i checked in msdn..there it says
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsServerConfigurationError.asp
I have installed Sql Server 2005 on my machine. I've managed to created report, but when i try to deploy e same, I'm getting e following error...am i missing something here?
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.
when i checked in msdn..there it says
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsServerConfigurationError.asp
Other info:
I have followed the Tutorial Project in SQL Books online. And for TargetURL, i have given --> http://localhost/reportserver
Report server is located in my local only
rsreportserver.config : I dint touch this file and mine is fresh installation.
Help please :)
Can you access Report Manager via Internet Explorer (http://server/reports) at all? Or does it throw the same/similar error?
It sounds to me like the account that SSRS is running under doesn't have the proper NTFS perms on the 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\' folder. Verify that that it does, or use the filemon tool from sysinternals.com to capture a log of what process (and which account) is getting denied...this will give you most of the info you'd need to fix the issue.
Good luck!
|||I experienced the problem described above and the filemon tool identified that the ASPNET user did not have read privileges to the .config file.
It seems strange that the server installation did not configure this correctly.. Setting privileges manually solved the problem..
Add ASPNET user to SQLServer2005Reporting ServicesWebServiceUsers$<MACHINE NAME> group, reboot your machine and it should start working properly.
|||You should be able to fix this as well by using the Report Server Configuration tool to set the web service identity.
-Lukasz
|||Web Service Identity is hard coded on the "Configure Report Server" page.|||Hi,
I am having similar issue trying to launch report services by http://localhost/reports. I got the following error
when try to launch it.
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
I used the Reporting Services Configuration tool to set all my virtual directory and etc... and verified that the report server is initiated and running. I have read other thread for similar issue, but none was able to provide a clear solution on how to resolve the problem. Any help would be appriciated.
|||Look in your log files and see if there is a detailed error message there. That's your best place to start.
-Lukasz
|||Hi,
I've look at the log file and it didn't help me much. Maybe you can point me to the right direction.
By the way, I am running Vista and using the Server 2005 eval edition. I don't know if this make any differences. I still couldn't get it took work for me. Any help would be greatly appriciate. The error i get is as follow when try to launch the report service using http://localhost/reports:
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3054.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__05_08_2007_10_17_13.log</Path>
<SystemName>ATS-PC</SystemName>
<OSName>Microsoft Windows NT 6.0.6000.0</OSName>
<OSVersion>6.0.6000.0</OSVersion>
</Header>
w3wp!webserver!1!5/8/2007-10:17:30:: i INFO: Reporting Web Server started
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Reporting Services starting SKU: Evaluation
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Evaluation copy: 175 days left
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!05/08/2007-10:17:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Catalog SQL Server Edition = Evaluation
w3wp!library!1!05/08/2007-10:17:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:38:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!5!05/08/2007-10:27:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!7!5/8/2007-10:27:31:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!5!05/08/2007-10:27:35:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:27:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
If you're running on Vista, you must install SQL Server SP2. Here are some KB articles that should help you out.
http://support.microsoft.com/kb/934164 (install)
http://support.microsoft.com/kb/934163 (upgrade)
-Lukasz
|||I had a similar problem. It turned out that since I had a named instance of SQL Server 2005 I had to reference that in the url. Specifically, it was http://localhost/ReportServer$NAMEOFSQLSERVERINSTANCE - CindyPsych
Help!! "The report server has encountered a configuration error........"
Hi There,
when i checked in msdn..there it says
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsServerConfigurationError.asp
I have installed Sql Server 2005 on my machine. I've managed to created report, but when i try to deploy e same, I'm getting e following error...am i missing something here?
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.
when i checked in msdn..there it says
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsServerConfigurationError.asp
Other info:
I have followed the Tutorial Project in SQL Books online. And for TargetURL, i have given --> http://localhost/reportserver
Report server is located in my local only
rsreportserver.config : I dint touch this file and mine is fresh installation.
Help please :)
Can you access Report Manager via Internet Explorer (http://server/reports) at all? Or does it throw the same/similar error?
It sounds to me like the account that SSRS is running under doesn't have the proper NTFS perms on the 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\' folder. Verify that that it does, or use the filemon tool from sysinternals.com to capture a log of what process (and which account) is getting denied...this will give you most of the info you'd need to fix the issue.
Good luck!
|||I experienced the problem described above and the filemon tool identified that the ASPNET user did not have read privileges to the .config file.
It seems strange that the server installation did not configure this correctly.. Setting privileges manually solved the problem..
Add ASPNET user to SQLServer2005Reporting ServicesWebServiceUsers$<MACHINE NAME> group, reboot your machine and it should start working properly.
|||You should be able to fix this as well by using the Report Server Configuration tool to set the web service identity.
-Lukasz
|||Web Service Identity is hard coded on the "Configure Report Server" page.|||Hi,
I am having similar issue trying to launch report services by http://localhost/reports. I got the following error
when try to launch it.
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
I used the Reporting Services Configuration tool to set all my virtual directory and etc... and verified that the report server is initiated and running. I have read other thread for similar issue, but none was able to provide a clear solution on how to resolve the problem. Any help would be appriciated.
|||Look in your log files and see if there is a detailed error message there. That's your best place to start.
-Lukasz
|||Hi,
I've look at the log file and it didn't help me much. Maybe you can point me to the right direction.
By the way, I am running Vista and using the Server 2005 eval edition. I don't know if this make any differences. I still couldn't get it took work for me. Any help would be greatly appriciate. The error i get is as follow when try to launch the report service using http://localhost/reports:
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3054.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__05_08_2007_10_17_13.log</Path>
<SystemName>ATS-PC</SystemName>
<OSName>Microsoft Windows NT 6.0.6000.0</OSName>
<OSVersion>6.0.6000.0</OSVersion>
</Header>
w3wp!webserver!1!5/8/2007-10:17:30:: i INFO: Reporting Web Server started
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Reporting Services starting SKU: Evaluation
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Evaluation copy: 175 days left
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!05/08/2007-10:17:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Catalog SQL Server Edition = Evaluation
w3wp!library!1!05/08/2007-10:17:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:38:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!5!05/08/2007-10:27:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!7!5/8/2007-10:27:31:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!5!05/08/2007-10:27:35:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:27:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
If you're running on Vista, you must install SQL Server SP2. Here are some KB articles that should help you out.
http://support.microsoft.com/kb/934164 (install)
http://support.microsoft.com/kb/934163 (upgrade)
-Lukasz
|||I had a similar problem. It turned out that since I had a named instance of SQL Server 2005 I had to reference that in the url. Specifically, it was http://localhost/ReportServer$NAMEOFSQLSERVERINSTANCE- CindyPsych
Help!! "The report server has encountered a configuration error........"
Hi There,
when i checked in msdn..there it says
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsServerConfigurationError.asp
I have installed Sql Server 2005 on my machine. I've managed to created report, but when i try to deploy e same, I'm getting e following error...am i missing something here?
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.
when i checked in msdn..there it says
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsServerConfigurationError.asp
Other info:
I have followed the Tutorial Project in SQL Books online. And for TargetURL, i have given --> http://localhost/reportserver
Report server is located in my local only
rsreportserver.config : I dint touch this file and mine is fresh installation.
Help please :)
Can you access Report Manager via Internet Explorer (http://server/reports) at all? Or does it throw the same/similar error?
It sounds to me like the account that SSRS is running under doesn't have the proper NTFS perms on the 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\' folder. Verify that that it does, or use the filemon tool from sysinternals.com to capture a log of what process (and which account) is getting denied...this will give you most of the info you'd need to fix the issue.
Good luck!
|||I experienced the problem described above and the filemon tool identified that the ASPNET user did not have read privileges to the .config file.
It seems strange that the server installation did not configure this correctly.. Setting privileges manually solved the problem..
Add ASPNET user to SQLServer2005Reporting ServicesWebServiceUsers$<MACHINE NAME> group, reboot your machine and it should start working properly.
|||You should be able to fix this as well by using the Report Server Configuration tool to set the web service identity.
-Lukasz
|||Web Service Identity is hard coded on the "Configure Report Server" page.|||Hi,
I am having similar issue trying to launch report services by http://localhost/reports. I got the following error
when try to launch it.
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
I used the Reporting Services Configuration tool to set all my virtual directory and etc... and verified that the report server is initiated and running. I have read other thread for similar issue, but none was able to provide a clear solution on how to resolve the problem. Any help would be appriciated.
|||Look in your log files and see if there is a detailed error message there. That's your best place to start.
-Lukasz
|||Hi,
I've look at the log file and it didn't help me much. Maybe you can point me to the right direction.
By the way, I am running Vista and using the Server 2005 eval edition. I don't know if this make any differences. I still couldn't get it took work for me. Any help would be greatly appriciate. The error i get is as follow when try to launch the report service using http://localhost/reports:
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3054.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__05_08_2007_10_17_13.log</Path>
<SystemName>ATS-PC</SystemName>
<OSName>Microsoft Windows NT 6.0.6000.0</OSName>
<OSVersion>6.0.6000.0</OSVersion>
</Header>
w3wp!webserver!1!5/8/2007-10:17:30:: i INFO: Reporting Web Server started
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Reporting Services starting SKU: Evaluation
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Evaluation copy: 175 days left
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!05/08/2007-10:17:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Catalog SQL Server Edition = Evaluation
w3wp!library!1!05/08/2007-10:17:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:38:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!5!05/08/2007-10:27:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!7!5/8/2007-10:27:31:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!5!05/08/2007-10:27:35:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:27:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
If you're running on Vista, you must install SQL Server SP2. Here are some KB articles that should help you out.
http://support.microsoft.com/kb/934164 (install)
http://support.microsoft.com/kb/934163 (upgrade)
-Lukasz
|||I had a similar problem. It turned out that since I had a named instance of SQL Server 2005 I had to reference that in the url. Specifically, it was http://localhost/ReportServer$NAMEOFSQLSERVERINSTANCE - CindyPsych
Help!! "The report server has encountered a configuration error........"
Hi There,
when i checked in msdn..there it says
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsServerConfigurationError.asp
I have installed Sql Server 2005 on my machine. I've managed to created report, but when i try to deploy e same, I'm getting e following error...am i missing something here?
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.
when i checked in msdn..there it says
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsServerConfigurationError.asp
Other info:
I have followed the Tutorial Project in SQL Books online. And for TargetURL, i have given --> http://localhost/reportserver
Report server is located in my local only
rsreportserver.config : I dint touch this file and mine is fresh installation.
Help please :)
Can you access Report Manager via Internet Explorer (http://server/reports) at all? Or does it throw the same/similar error?
It sounds to me like the account that SSRS is running under doesn't have the proper NTFS perms on the 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\' folder. Verify that that it does, or use the filemon tool from sysinternals.com to capture a log of what process (and which account) is getting denied...this will give you most of the info you'd need to fix the issue.
Good luck!
|||I experienced the problem described above and the filemon tool identified that the ASPNET user did not have read privileges to the .config file.
It seems strange that the server installation did not configure this correctly.. Setting privileges manually solved the problem..
Add ASPNET user to SQLServer2005Reporting ServicesWebServiceUsers$<MACHINE NAME> group, reboot your machine and it should start working properly.
|||You should be able to fix this as well by using the Report Server Configuration tool to set the web service identity.
-Lukasz
|||Web Service Identity is hard coded on the "Configure Report Server" page.|||Hi,
I am having similar issue trying to launch report services by http://localhost/reports. I got the following error
when try to launch it.
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
I used the Reporting Services Configuration tool to set all my virtual directory and etc... and verified that the report server is initiated and running. I have read other thread for similar issue, but none was able to provide a clear solution on how to resolve the problem. Any help would be appriciated.
|||Look in your log files and see if there is a detailed error message there. That's your best place to start.
-Lukasz
|||Hi,
I've look at the log file and it didn't help me much. Maybe you can point me to the right direction.
By the way, I am running Vista and using the Server 2005 eval edition. I don't know if this make any differences. I still couldn't get it took work for me. Any help would be greatly appriciate. The error i get is as follow when try to launch the report service using http://localhost/reports:
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3054.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__05_08_2007_10_17_13.log</Path>
<SystemName>ATS-PC</SystemName>
<OSName>Microsoft Windows NT 6.0.6000.0</OSName>
<OSVersion>6.0.6000.0</OSVersion>
</Header>
w3wp!webserver!1!5/8/2007-10:17:30:: i INFO: Reporting Web Server started
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Reporting Services starting SKU: Evaluation
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Evaluation copy: 175 days left
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!05/08/2007-10:17:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Catalog SQL Server Edition = Evaluation
w3wp!library!1!05/08/2007-10:17:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:38:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!5!05/08/2007-10:27:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!7!5/8/2007-10:27:31:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!5!05/08/2007-10:27:35:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:27:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
If you're running on Vista, you must install SQL Server SP2. Here are some KB articles that should help you out.
http://support.microsoft.com/kb/934164 (install)
http://support.microsoft.com/kb/934163 (upgrade)
-Lukasz
|||I had a similar problem. It turned out that since I had a named instance of SQL Server 2005 I had to reference that in the url. Specifically, it was http://localhost/ReportServer$NAMEOFSQLSERVERINSTANCE - CindyPsych
Subscribe to:
Posts (Atom)