Count on a date column

All,
I need to count dates in a column but how can i cut of the time hour minutes and seconds?
I need to rport how many records hav been added on one date...
con someone help me getting on the richt track?
regards
select count(*)
from tbl
where convert(varchar(8),dte,112) = '20040515'
select count(*)
from tbl
where dte >= '20040515' and dte < '20040515'
select dte = convert(varchar(8),dte,112), num = count(*)
from tbl
group by convert(varchar(8),dte,112)
order by convert(varchar(8),dte,112)
one of those should help.
Nigel Rivett
www.nigelrivett.net
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Count of employees

Hi,

We got of count of employees from measures against a date dimension.

we need to get average count for a time period (ie..week,quarter,year ).

and the formula for avg employee count: (empl-count on firstday of period+empl-count on last dayof period)/2

Date EMPCount

for ex : 1-Nov-2005 2361

2-Nov-2005 2521

3-Nov-2005 2762

4-Nov-2005 2500

avg count for week in novemeber: 2361+2500/2.

Kindly let me know how we can do this in SSAS cube.

Thanks in advance

Raj

I can think of a couple of ways of doing this, I don't have a descent sample set to perfomance test against, I suspect the second method may be faster, specially at higher level as it will not have to evaluate a large set of days.

Method "a" gets the descendants of the current time member and grabs the first and last member of that set to average them.

create member measures.a as ((Head({descendants([Time].[Financial].CurrentMember,[Time].[Financial].[Financial Date]) as mths},1).item(0),Measures.Amount) + (TAIL(mths,1).item(0),Measures.Amount))/2

Method "b" uses 2 recursive functions to walk down the time hierarchy to grab the first and last member underneath the currentmember. The third calculation then simple adds the first 2 and divides by 2.

create member measures.bhead as iif([Time].Financial.CurrentMember.Level is [Time].[Financial].[Financial Date],Measures.Amount,([Time].Financial.CurrentMember.FirstChild,Measures.Measures.bHead))

create member measures.btail as iif([Time].Financial.CurrentMember.Level is [Time].[Financial].[Financial Date],Measures.Amount,([Time].Financial.CurrentMember.LastChild,Measures.Measures.bTail))

create member measures.b as (measures.bhead + measures.btail)/2

|||

Hi,

I tried with method "b" it's showing "#Value!"

We have server created time Dimension is it because of that ?

or we are getting active employees count thro named query?

server created time dimension is "atrntime" and dimension attributes are Date,year,week,day of week,day of year.

please help

thanks

|||

No, neither of those things should stop the query from working. I did not have access to Adventure Works when I posted the last sample, so I had to remove some client specific stuff from the sample I sent. Below is an actual working query that will run against the Adventure Works sample database.

WITH

member measures.DateHead as iif([Date].Fiscal.CurrentMember.Level is [Date].[Fiscal].[Date]
,[Measures].[Internet Order Count]
,([Date].Fiscal.CurrentMember.FirstChild,measures.DateHead)
)

member measures.DateTail as iif([Date].Fiscal.CurrentMember.Level is [Date].[Fiscal].[Date]
,[Measures].[Internet Order Count]
,([Date].Fiscal.CurrentMember.LastChild,measures.DateTail)
)

member measures.AvgOrderCnt as (measures.DateHead + measures.DateTail)/2

SELECT
{Measures.DateHead
,Measures.DateTail
,Measures.AvgOrderCnt
,Measures.[Internet Order Count]} ON COLUMNS

,[Date].Fiscal.Month.Members ON ROWS

FROM [Adventure Works]

If you are still having issues, you may find that displaying the results of the two underlying measures may help to diagnose any issues. If you are still unable to resolve the #value problem, try posting your calcuations and I (or someone else) may be able to spot the issue.

|||

Hi,

Thanks for the answer.

I tried with this calculated measure

CREATE MEMBER CURRENTCUBE.[MEASURES].DateHead
AS iif([AtrnTime].[drill].CurrentMember.Level is [AtrnTime].[drill].[Week]
,[Measures].[ActiveEmpl]
,([AtrnTime].[drill].CurrentMember.FirstChild,measures.DateHead)
);
and the output from cube browser was

Active Empl

DateHead

Calendar 2006

Week 25, 2006

Monday, June 19 2006

2368

Tuesday, June 20 2006

2369

Thursday, June 22 2006

2367

Friday, June 23 2006

2365

Saturday, June 24 2006

2364

Total

2375

2375

Week 26, 2006

Monday, June 26 2006

2374

Tuesday, June 27 2006

2373

Wednesday, June 28 2006

2372

Total

2375

2376

Total

2387

but the expected answer for datehead measure was
2368 for week 25 and 2374 for week 26

and one more thing, i was not able to figure it out is total :2375 for wk25 and 2375 for week 26 (it's not the average also....)

We have sever created time dimension "AtrnTime" and "drill" is the herarchy defined as year-week-date

thanks

Raj

|||

I think what you are getting is the distinct count for the week and I think what you are after for the DateHead measure is the count for the first day. By putting the Week Level/Attribute in the test for the IIF clause, you have effectively stopped the recursion there. Changing the level in the test for the iif clause should give you the result you are after.

CREATE MEMBER CURRENTCUBE.[MEASURES].DateHead
AS iif([AtrnTime].[drill].CurrentMember.Level is [AtrnTime].[drill].[Date]
,[Measures].[ActiveEmpl]
,([AtrnTime].[drill].CurrentMember.FirstChild,measures.DateHead)
);

I could possibly have coded my example better to show what I was intending, by using the IsLeaf() function, maybe the following is a better way of coding this measure.

CREATE MEMBER CURRENTCUBE.[MEASURES].DateHead
AS iif( IsLeaf([AtrnTime].[drill].CurrentMember)
,[Measures].[ActiveEmpl]
,([AtrnTime].[drill].CurrentMember.FirstChild,measures.DateHead)
);

This will make the measure recurse down until it hits the leaf level of the hierarchy.

|||

Hi,

Yeah you were right, i was getting Distinct Count for ActiveEmpl measure and i am after getting count for the first day.

i tried executing bothe the MDX scripts. It works at the day level but when i aggregate to the week level i should get the count of first day in that week .. but i am getting blank in that place.

CREATE MEMBER CURRENTCUBE.[MEASURES].DateHead1

AS iif( IsLeaf([AtrnTime].[drill].CurrentMember)

,[Measures].[ActiveEmpl]

,([AtrnTime].[drill].CurrentMember.FirstChild,measures.DateHead1)

);

CREATE MEMBER CURRENTCUBE.[MEASURES].DateHead2

AS iif([AtrnTime].[drill].CurrentMember.Level is [AtrnTime].[drill].[date]

,[Measures].[ActiveEmpl]

,([AtrnTime].[drill].CurrentMember.FirstChild,measures.DateHead2)

);

and the output of that was

Active Employees

DateHead1

DateHead2

Calendar 2006

Week 25, 2006

Monday, June 19 2006

2368

2368

2368

Tuesday, June 20 2006

2369

2369

2369

Thursday, June 22 2006

2367

2367

2367

Friday, June 23 2006

2365

2365

2365

Saturday, June 24 2006

2364

2364

2364

Total

2375

Week 26, 2006

Monday, June 26 2006

2374

2374

2374

Tuesday, June 27 2006

2373

2373

2373

Wednesday, June 28 2006

2372

2372

2372

Total

2375

Total

2387

but when i aggregate to the week level datehead1 and datehead2 was blank as below.

Active Employees

DateHead1

DateHead2

Calendar 2006

Week 25, 2006

2375

Week 26, 2006

2375

Total

2387

datehead1/datehead2 should be 2368 for wk25 and 2374 for wk26

thanks in advance..

|||

Would I be right if I were to guess that your week starts on Sunday, which normally does not have any data? I'm guessing that members without data are probably what is causing the blanks here. There are probably a number of ways of dealing with this, we could nest another IIF clause to effectively "walk" along the siblings at the day level, looking for a non-empty one, but I don't think that would be terribly efficient.

We could grab all the siblings at the date level and return the first non-empty.

eg.

CREATE MEMBER CURRENTCUBE.[MEASURES].DateHead1
AS iif( IsLeaf([AtrnTime].[drill].CurrentMember)
,HEAD(NONEMPTY([AtrnTime].[drill].CurrentMember.Siblings, {[Measures].[ActiveEmpl]}),1)
,([AtrnTime].[drill].CurrentMember.FirstChild,measures.DateHead1)
);

But if we have to deal with sets of members and finding non-empty children it might be better not to use recursion and to grab all the non-empty descendants of the time dimension.

CREATE MEMBER CURRENTCUBE.[MEASURES].DateHead1
AS HEAD(NONEMPTY(Descendants([AtrnTime].[drill].CurrentMember
,[AtrnTime].[drill].[Date]), {[Measures].[ActiveEmpl]}),1)
;

And if we are going down that path I would suggest looking into coding the whole thing into one measure so that you do not have to do the nonempty twice (once for the first day and once for the last day). You can do this by naming the non empty set and re-using it.

eg

CREATE MEMBER CURRENTCUBE.[MEASURES].Avg
AS (HEAD(
NONEMPTY(Descendants([AtrnTime].[drill].CurrentMember
,[AtrnTime].[drill].[Date]) * {[Measures].[ActiveEmpl]}) AS NonEmptySet
,1).Item(0)
+
TAIL( NonEmptySet
,1).Item(0))
/ 2;

;

|||

yeah your guess was right ,,sunday was the starting day of the week, and the blank row was because of no data for that day..,, finally the avg query worked which takes head/tail of nonempty set.

Thanks a lot Darren.

Count Occurances Of Given Value

Hello All,

I have a question that has been vexing me for some time now. It keeps coming up when I'm trying to write queries for SSRS reports. Lets say I have a table that has 3 columns to keep track of people's gender in a annonomys survay (very basic example):

Month (varchar) | Year (smallint) | Gender (bool)

I want to return a dataset that is grouped by Month and Year and that contains a count of each Gender which would look something like this:

Month | Year | [Male Count] | [Female Count]

January | 2006 | 100 | 120
February | 2006 | 130 | 110
March | 2006 | 120 | 145
April | 2006 | 105 | 125

How would I acheive a dataset like this? Is it possible? Do I need to join the table to itself? If so do I use an Inner Join, an Outer Join, or a Left/Right Join? Any help would be extremely appreciated.

Thanks!

Tennyson

There are several possibilities. One option:

SELECT [Month], [Year],
COUNT(CASE WHEN Gender = 0 THEN 1 END) AS MaleCount,
COUNT(CASE WHEN Gender = 1 THEN 1 END) AS FemaleCount
FROM YourSurveyTable

GROUP BY [Month], [Year]

-Sue

|||

Thank you Sue! Your help was much appreciated.

Thanks,

Tennyson

Count Occurances Of Given Value

Hello All,

I have a question that has been vexing me for some time now. It keeps coming up when I'm trying to write queries for SSRS reports. Lets say I have a table that has 3 columns to keep track of people's gender in a annonomys survay (very basic example):

Month (varchar) | Year (smallint) | Gender (bool)

I want to return a dataset that is grouped by Month and Year and that contains a count of each Gender which would look something like this:

Month | Year | [Male Count] | [Female Count]

January | 2006 | 100 | 120
February | 2006 | 130 | 110
March | 2006 | 120 | 145
April | 2006 | 105 | 125

How would I acheive a dataset like this? Is it possible? Do I need to join the table to itself? If so do I use an Inner Join, an Outer Join, or a Left/Right Join? Any help would be extremely appreciated.

Thanks!

Tennyson

There are several possibilities. One option:

SELECT [Month], [Year],
COUNT(CASE WHEN Gender = 0 THEN 1 END) AS MaleCount,
COUNT(CASE WHEN Gender = 1 THEN 1 END) AS FemaleCount
FROM YourSurveyTable

GROUP BY [Month], [Year]

-Sue

|||

Thank you Sue! Your help was much appreciated.

Thanks,

Tennyson

Count consecutive numbers

I'm trying extract a count of consecutive numbers, or "unbroken" years in
this case, at any particular given time.

For example (simplified):

CREATE TABLE #Customers
(
CustNo INT,
YearNo INT,
IsCust CHAR(1)
)

INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2006, 'Y')
INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2005, 'Y')
INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2004, 'Y')
INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2003, 'N')
INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2002, 'N')
INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2001, 'Y')
INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2000, 'Y')

SELECT * FROM #Customers

CustNo YearNo IsCust
---- ---- --
999 2006 Y
999 2005 Y
999 2004 Y
999 2003 N
999 2002 N
999 2001 Y
999 2000 Y

In 2006 CustNo 999 would have been active for 3 years, 2004 for 1, 2001 for
2, etc. Ideally I'd feed it a single year to lookup

I'm resisting the urge to create cursor here -- anyone have any hints?

...Chris.ChrisD wrote:

> In 2006 CustNo 999 would have been active for 3 years, 2004 for 1, 2001
> for 2, etc. Ideally I'd feed it a single year to lookup

This works in Postgres, you'll have to change the "limit 1" to mssql TOP 1
syntax. Also note the hardcoded year on line 4, replace that with a
parameter.

Ironically, this only works if you specify the year. Without the year you
get spurious rows.

select a.yearno,b.yearno,(a.yearno - b.yearno) + 1 as "years"
from customers a join customers b on a.custno = b.custno
where a.yearno > b.yearno
AND a.yearno = 2006
AND a.isCust = 'Y' and b.isCust = 'Y'
and not exists
(
select yearno
FROM customers x
WHERE x.custno = a.custno
AND x.yearno between b.yearno AND a.yearno
AND x.isCust = 'N'
)
order by b.yearno
limit 1

--
Kenneth Downs
Secure Data Software, Inc.
(Ken)nneth@.(Sec)ure(Dat)a(.com)|||"ChrisD" <spambucket@.hotmail.com> wrote in message news:<Yfn2e.840846$Xk.593396@.pd7tw3no>...
> I'm trying extract a count of consecutive numbers, or "unbroken" years in
> this case, at any particular given time.
> For example (simplified):
> CREATE TABLE #Customers
> (
> CustNo INT,
> YearNo INT,
> IsCust CHAR(1)
> )
> INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2006, 'Y')
> INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2005, 'Y')
> INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2004, 'Y')
> INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2003, 'N')
> INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2002, 'N')
> INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2001, 'Y')
> INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2000, 'Y')
> SELECT * FROM #Customers
8<-- Obvious result omitted
> In 2006 CustNo 999 would have been active for 3 years, 2004 for 1, 2001 for
> 2, etc. Ideally I'd feed it a single year to lookup
> I'm resisting the urge to create cursor here -- anyone have any hints?
> ...Chris.

The computation you want to perform is a subtraction.
There are some caveats concernig your data.

Just two hints ...|||how about this:

select top 1 max(a.yearno)+1 as from_ ,b.yearno as to_ , b.yearno -(
max(a.yearno)+1) as consecutive_time from #customers a join #Customers
b on a.custno = b.custno and
a.iscust='N' and b.iscust='Y' and a.yearno < b.yearno
group by b.yearno
order by consecutive_time desc

i.e. get the max diff between an 'N' and the 'Y' after it|||create view cust as
select custno, yearno, isCust from Customers
union
select custno, min(yearno) - 1, 'N'
from Customers group by custno
go

select custno,yearno, iscust,
case iscust
when 'N' THEN 0
ELSE 1+(select count(*)
from cust a where a.custno = b.custno and
a.yearno < b.yearno and
(a.yearno >
(select max(yearno) from cust c where iscust = 'N' and yearno <
b.yearno and custno = b.custno))
) end as active_for
from cust b
where yearno >= (select min(yearno) from customers x where x.custno =
b.custno )
order by custno, yearno|||"ChrisD" <spambucket@.hotmail.com> wrote in message news:Yfn2e.840846$Xk.593396@.pd7tw3no...
> I'm trying extract a count of consecutive numbers, or "unbroken" years in
> this case, at any particular given time.
> For example (simplified):
> CREATE TABLE #Customers
> (
> CustNo INT,
> YearNo INT,
> IsCust CHAR(1)
> )
> INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2006, 'Y')
> INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2005, 'Y')
> INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2004, 'Y')
> INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2003, 'N')
> INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2002, 'N')
> INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2001, 'Y')
> INSERT INTO #Customers (custno, yearno, isCust) VALUES (999, 2000, 'Y')
> SELECT * FROM #Customers
> CustNo YearNo IsCust
> ---- ---- --
> 999 2006 Y
> 999 2005 Y
> 999 2004 Y
> 999 2003 N
> 999 2002 N
> 999 2001 Y
> 999 2000 Y
> In 2006 CustNo 999 would have been active for 3 years, 2004 for 1, 2001 for
> 2, etc. Ideally I'd feed it a single year to lookup
> I'm resisting the urge to create cursor here -- anyone have any hints?
> ...Chris.

SELECT C.CustNo AS CustNo,
C.YearNo AS YearNo,
C.YearNo - MAX(FY.YearNo) + 1 AS YearTally
FROM #Customers AS C
INNER JOIN
(SELECT C1.CustNo, C1.YearNo
FROM #Customers AS C1
LEFT OUTER JOIN
#Customers AS C2
ON C1.CustNo = C2.CustNo AND
C2.YearNo = C1.YearNo - 1 AND
C2.IsCust = 'Y'
WHERE C1.IsCust = 'Y' AND C2.CustNo IS NULL) AS FY -- 1st year
ON FY.CustNo = C.CustNo AND
C.IsCust = 'Y' AND
FY.YearNo <= C.YearNo
GROUP BY C.CustNo, C.YearNo
ORDER BY CustNo, YearNo

--
JAG|||"ChrisD" <spambucket@.hotmail.com> wrote in message news:<Yfn2e.840846$Xk.593396@.pd7tw3no>...
> I'm trying extract a count of consecutive numbers, or "unbroken" years in
> this case, at any particular given time.
> For example (simplified):
> CREATE TABLE #Customers
> (
> CustNo INT,
> YearNo INT,
> IsCust CHAR(1)
> )
8<----Big snip
> In 2006 CustNo 999 would have been active for 3 years, 2004 for 1, 2001 for
> 2, etc. Ideally I'd feed it a single year to lookup
> I'm resisting the urge to create cursor here -- anyone have any hints?
> ...Chris.

As I said in my previous posting:
The computation you want to perform is a subtraction.
There are some caveats concernig your data.

Chris wanted hints, not complete solutions.
The solutions offered are likely to fail (I didn't test this)
if there is an 'active' year without any 'inactive' predecessor.|||"Theo Peterbroers" <peterbroers@.floron.leidenuniv.nl> wrote in message
news:39bb2c10.0503300659.231f1c7c@.posting.google.c om...
> "ChrisD" <spambucket@.hotmail.com> wrote in message news:<Yfn2e.840846$Xk.593396@.pd7tw3no>...
> > I'm trying extract a count of consecutive numbers, or "unbroken" years in
> > this case, at any particular given time.
> > For example (simplified):
> > CREATE TABLE #Customers
> > (
> > CustNo INT,
> > YearNo INT,
> > IsCust CHAR(1)
> > )
> 8<----Big snip
> > In 2006 CustNo 999 would have been active for 3 years, 2004 for 1, 2001 for
> > 2, etc. Ideally I'd feed it a single year to lookup
> > I'm resisting the urge to create cursor here -- anyone have any hints?
> > ...Chris.
> As I said in my previous posting:
> The computation you want to perform is a subtraction.
> There are some caveats concernig your data.
> Chris wanted hints, not complete solutions.

I didn't take that as his literal intention. If it was, a quick glance
will reveal a solution, but probably not lead to comprehension,
and he can choose to ignore it.

> The solutions offered are likely to fail (I didn't test this)
> if there is an 'active' year without any 'inactive' predecessor.

His sample data includes an active year without an inactive
predecessor. As Chris was helpful enough to include DDL
and sample data, I assume all respondents who offered
complete solutions availed themselves of it. As far as I
can tell, my solution solves the problem.

--
JAG|||Yet another version, with a little-used predicate!

SELECT X.cust_nbr, MIN(X.start_date) AS start_date, X.end_date
FROM (SELECT C1.cust_nbr, C1.cust_year, MAX(C2.cust_year)
FROM Customers AS C1, Customers AS C2
WHERE C1.cust_nbr = C2.cust_nbr
AND C1.cust_year <= C2.cust_year
AND 'Y' = ALL (SELECT cust_flag
FROM Customers AS C3
WHERE C3.cust_nbr = C2.cust_nbr
AND C3.cust_year BETWEEN C1.cust_year AND
C2.cust_year)
GROUP BY C1.cust_nbr, C1.cust_year)
AS X(cust_nbr, start_year, end_year)
GROUP BY X.cust_nbr, X.end_date;|||Opps! fix my typos:

SELECT X.cust_nbr, MIN(X.start_year) AS start_date, X.end_year
FROM (SELECT C1.cust_nbr, C1.cust_year, MAX(C2.cust_year)
FROM Customers AS C1, Customers AS C2
WHERE C1.cust_nbr = C2.cust_nbr
AND C1.cust_year <= C2.cust_year
AND 'Y' = ALL (SELECT cust_flag
FROM Customers AS C3
WHERE C3.cust_nbr = C2.cust_nbr
AND C3.cust_year BETWEEN C1.cust_year AND
C2.cust_year)
GROUP BY C1.cust_nbr, C1.cust_year)
AS X(cust_nbr, start_year, end_year)
GROUP BY X.cust_nbr, X.end_year;|||ChrisD wrote:

> In 2006 CustNo 999 would have been active for 3 years, 2004 for 1,
> 2001 for 2, etc. Ideally I'd feed it a single year to lookup

Thanks all for the nudges!

I was able to make this work using a combination of John's and Kenneth's
samples. Joe's works too.

In practice I will always have a previous year -- but I suppose it's a
always a good idea to check.

...Chris.

Count Children

Hi

I have a time dimension, that has an hierarchy with three levels, Year, Half Year and Month.

Is it possible to count how many days there are in each level?

Regards

You should be able to do this using the "Existing" function to count the number of days using the attribute hierarchy for days. Here is an example using AdventureWorks:

WITH

MEMBER MEASURES.[Count of Days]

AS

{Existing [Date].[Date].[Date].Members}.Count

SELECT

{MEASURES.[Count of Days]} ONCOLUMNS,

Hierarchize(

{{[Date].[Calendar].[Calendar Year].Members},

{[Date].[Calendar].[Calendar Quarter].Members},

{[Date].[Calendar].[Month].Members}}) ONROWS

FROM

[Adventure Works]

HTH,

Steve

|||

Hi Guys

Working with the same hierarchy,

Is it possible to know the FirstChild and LastChild members in each level?

I'm trying to do this but I get an error #Error

WITH

MEMBER [Measures].[First Day]

AS

{[Tiempo].[Fecha].FirstChild}

select

[Measures].[First Day] ON COLUMNS

from [MyCube]

Regards

|||

If you return a "day" member, then you will have to create the member on your time hierarchy. Try the following:

MEMBER [Tiempo].[Fecha].[First Day]

AS

Head({Existing [Tiempo].[Fecha].DefaultMember.Children},1)(0)

MEMBER [Tiempo].[Fecha].[Last Day]

AS

Tail({Existing [Tiempo].[Fecha].DefaultMember.Children},1)(0)

HTH,

Steve

|||

Hi Steve, thanks for answer

Let me undenstand, Do I need to add the day level in my hierarchy?

Those new members aren't measures, they are Time dimension members. Aren't they?

Do you have an example about how to use it?

Regards

Could we discuss Web Data Administrator one last time?

I installed MSDE (SQL2KDeskSP3) from the command prompt with the following command line:

Setup.exe /qb+ INSTANCENAME=newsdb_engine DISABLENETWORKPROTOCOLS=1 SAPWD=dotNet

I then installed WebDataAdmin using all of the defaults.

I opened WebDataAdmin and at the login entered these credentials:

Username: sa
Password: dotNet
Server: newsdb_engine

Each time the error is returned that the username or password is invalid and/or the server does not exist.

So I tried a different server name, adding the computer name:
Server: AZT12YXM/newsdb_engine

Same error message occurred.

Then I read that SQL Authentication mode has to have the correct registry setting.
I went to HKLM/Microsoft/MSSqlServer/MSSqlServer/ and changed the login from "1" to "0"
and rebooted.

Same error message occurred.

I do have a developer edition of SqlServer 2000, but I want to be able to install msde and configure it without enterprise tools so that msde is the sole database engine (for deployment reasons).

Could someone suggest a list of steps from start to finish for installing msde on a machine where the instance you create is the sole database on the target machine and how to configure it to be Web Data Administrator "friendly"?

Maybe this could be the "one-stop" Web Data Admin keyword search thread.

Thank you.The servername should be: MachineName\InstanceName

Cheers
Ken

Could not set working set size to 1168512 KB

hello,
We're running W2000 sp4 fr/ SQL 2000 SP3 fr and get error 17122 in the
application event log every time SQL is brought up. The error text
reads
"initdata: Warning: Could not set working set size to 1168512 KB".
What does
this really mean, is it harmful and how can I correct it? Thanks for
any info.
Thanks
A.S
Hi,
Not a real problem, this is only a warning due to incompatibility with
PAE/AWE !
Just disable the "reserve physical memory for SQLServer" by :
sp_configure 'set working set size',0
go
reconfigure with override
go
See http://support.microsoft.com/kb/822164/en-us
Guillaume.
"Zizou-Real" wrote:

> hello,
> We're running W2000 sp4 fr/ SQL 2000 SP3 fr and get error 17122 in the
> application event log every time SQL is brought up. The error text
> reads
> "initdata: Warning: Could not set working set size to 1168512 KB".
> What does
> this really mean, is it harmful and how can I correct it? Thanks for
> any info.
>
> Thank’s
> A.S
>
>
sql

Could not find stored procedure 'dbo.sp_MS_replication_installed'.

Dear all,
I want to add a new server as a publisher to an existing distributor,
but each time I try, I get this error:
Could not find stored procedure 'dbo.sp_MS_replication_installed'.
I also tried making this machine it's own distributor, but the same
error comes up.
Thanks in advance.
Aramid
Aramid,
Does the proc exist?
Try:
USE MASTER
GO
IF OBJECT_ID('SP_MS_REPLICATION_INSTALLED') IS NULL
PRINT 'PROC NOT INSTALLED'
ELSE
PRINT 'PROC INSTALLED'
Also, you may want to post this to:
http://www.microsoft.com/technet/com...replica tion
HTH
Jerry
"Aramid" <aramid@.hotmail.com> wrote in message
news:6t8sl19hf5c6mbgphm3nubjhim3b6ncg7b@.4ax.com...
> Dear all,
> I want to add a new server as a publisher to an existing distributor,
> but each time I try, I get this error:
> Could not find stored procedure 'dbo.sp_MS_replication_installed'.
> I also tried making this machine it's own distributor, but the same
> error comes up.
> Thanks in advance.
>
> Aramid

Could not find stored procedure 'dbo.sp_MS_replication_installed'.

Dear all,
I want to add a new server as a publisher to an existing distributor,
but each time I try, I get this error:
Could not find stored procedure 'dbo.sp_MS_replication_installed'.
I also tried making this machine it's own distributor, but the same
error comes up.
Thanks in advance.
Aramid
Reapply the latest sp. There seems to be a problem with the sp setup program
where it drops all the replication related procs, but somehow occasionally
forgets to reinstall them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Aramid" <aramid@.hotmail.com> wrote in message
news:cs5sl1lm2mh8bso89aujduaii1gjpovpn4@.4ax.com...
> Dear all,
> I want to add a new server as a publisher to an existing distributor,
> but each time I try, I get this error:
> Could not find stored procedure 'dbo.sp_MS_replication_installed'.
> I also tried making this machine it's own distributor, but the same
> error comes up.
> Thanks in advance.
>
> Aramid
|||Thanks so much Hillary, I will try this one.
Aramid
On Tue, 25 Oct 2005 11:05:45 -0400, "Hilary Cotter"
<hilary.cotter@.gmail.com> wrote:

>Reapply the latest sp. There seems to be a problem with the sp setup program
>where it drops all the replication related procs, but somehow occasionally
>forgets to reinstall them.

Could not find stored procedure 'dbo.sp_MS_replication_installed'.

Dear all,
I want to add a new server as a publisher to an existing distributor,
but each time I try, I get this error:
Could not find stored procedure 'dbo.sp_MS_replication_installed'.
I also tried making this machine it's own distributor, but the same
error comes up.
Thanks in advance.
AramidAramid,
Does the proc exist?
Try:
USE MASTER
GO
IF OBJECT_ID('SP_MS_REPLICATION_INSTALLED')
IS NULL
PRINT 'PROC NOT INSTALLED'
ELSE
PRINT 'PROC INSTALLED'
Also, you may want to post this to:
http://www.microsoft.com/technet/co...ver.replication
HTH
Jerry
"Aramid" <aramid@.hotmail.com> wrote in message
news:6t8sl19hf5c6mbgphm3nubjhim3b6ncg7b@.
4ax.com...
> Dear all,
> I want to add a new server as a publisher to an existing distributor,
> but each time I try, I get this error:
> Could not find stored procedure 'dbo.sp_MS_replication_installed'.
> I also tried making this machine it's own distributor, but the same
> error comes up.
> Thanks in advance.
>
> Aramid

Could not find stored procedure 'dbo.sp_MS_replication_installed'.

Dear all,
I want to add a new server as a publisher to an existing distributor,
but each time I try, I get this error:
Could not find stored procedure 'dbo.sp_MS_replication_installed'.
I also tried making this machine it's own distributor, but the same
error comes up. :(
Thanks in advance.
AramidAramid,
Does the proc exist?
Try:
USE MASTER
GO
IF OBJECT_ID('SP_MS_REPLICATION_INSTALLED') IS NULL
PRINT 'PROC NOT INSTALLED'
ELSE
PRINT 'PROC INSTALLED'
Also, you may want to post this to:
http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.replication
HTH
Jerry
"Aramid" <aramid@.hotmail.com> wrote in message
news:6t8sl19hf5c6mbgphm3nubjhim3b6ncg7b@.4ax.com...
> Dear all,
> I want to add a new server as a publisher to an existing distributor,
> but each time I try, I get this error:
> Could not find stored procedure 'dbo.sp_MS_replication_installed'.
> I also tried making this machine it's own distributor, but the same
> error comes up. :(
> Thanks in advance.
>
> Aramid

Could not find database ID 65. Database may not be activated yet or may be in tr

When you run an sp for the first time it generates a query plan.
Sounds like it is getting the database ID at this time and so failing when the database is dropped. It will be accessing the old database after it is renamed.
You can probably cure this by specifying 'with recompile' so that it resolves the objects on each execution.

If you are runing the query from query analyser then it must be caching the query plan somewhere.I do have included recompile option and as you said, it is caching in procedure cache and even after clearing cache also it is resulting same error. I have observed one thing is that, it is not happening with all tables which are included in my select statements in stored procedures. Another thing is after executing Job for 3 to 4 times only this problem is raising and for your information, both servers are having SQL7 SP2 and MDAC 2.5 SP1 (This configuration is forced to keep since most our major clients are running under same environment). Please let me know if you have any answer. Thanks for your kind help

Could not find database ID 102. Database may not be activated yet or may be in transition.

Hi (and sorry for sending this again, as a new post this time)
I get this error ocasionally in different parts of our application, but I
had never been able to reproduce it (as it seems to intermitent) until now
when I had a situation where this error always happens.
I've reduced the test script as much as I could to send to the list. I seems
that SQL Server doesn't like when you try to create a VIEW which has a JOIN
using a UDF and a subquery (even if not correlated) in the SELECT clause.
Please see full sample script bellow that reproduces the problem. This is
the error I get when I run it:
Server: Msg 913, Level 16, State 8, Line 4
Could not find database ID 102. Database may not be activated yet or may
be in transition.
Thanks,
Dallara
USE master
go
IF EXISTS (SELECT name FROM master..sysdatabases WHERE name =
'Organisation')
DROP DATABASE Organisation
go
CREATE DATABASE Organisation
go
USE Organisation
go
CREATE TABLE Company
(
CompanyId int IDENTITY (1, 1) NOT NULL,
CompanyName varchar(50) NOT NULL,
IsActive char(1) NOT NULL DEFAULT 'Y',
CONSTRAINT PK_Company PRIMARY KEY (CompanyId)
)
CREATE TABLE Contact
(
ContactId int IDENTITY (1, 1) NOT NULL,
CompanyRef int NOT NULL,
FullName varchar(25) NOT NULL,
Phone varchar(25) NULL,
CONSTRAINT PK_Contact PRIMARY KEY (ContactId),
CONSTRAINT FK_Contact_Company FOREIGN KEY (CompanyRef) REFERENCES Company
(CompanyId)
)
go
CREATE FUNCTION DummyFunction()
RETURNS int
AS
BEGIN
RETURN 1
END
go
CREATE VIEW DummyView
AS
SELECT
Company.CompanyName,
Contact.FullName,
(SELECT count(*) FROM Company WHERE IsActive = 'Y') As
NumberOfActiveCompanies
FROM
Company
JOIN Contact ON ContactId = dbo.DummyFunction()
go
This looks a lot like the bug reported in MSKB 819264
<http://support.microsoft.com/default...b;en-us;819264>
In this case, you could move the condition to the WHERE clause and use a
CROSS JOIN:
ALTER VIEW DummyView
AS
SELECT
Company.CompanyName,
Contact.FullName,
(SELECT count(*) FROM Company WHERE IsActive = 'Y') As
NumberOfActiveCompanies
FROM
Company
CROSS JOIN Contact
WHERE ContactId = dbo.DummyFunction()
GO
Hope this helps.
Dan Guzman
SQL Server MVP
"Dallara" <someone@.microsoft.com> wrote in message
news:udhF3lgwEHA.824@.TK2MSFTNGP11.phx.gbl...
> Hi (and sorry for sending this again, as a new post this time)
> I get this error ocasionally in different parts of our application, but I
> had never been able to reproduce it (as it seems to intermitent) until now
> when I had a situation where this error always happens.
> I've reduced the test script as much as I could to send to the list. I
> seems
> that SQL Server doesn't like when you try to create a VIEW which has a
> JOIN
> using a UDF and a subquery (even if not correlated) in the SELECT clause.
> Please see full sample script bellow that reproduces the problem. This is
> the error I get when I run it:
> Server: Msg 913, Level 16, State 8, Line 4
> Could not find database ID 102. Database may not be activated yet or may
> be in transition.
>
> Thanks,
> Dallara
>
> ----
> USE master
> go
> IF EXISTS (SELECT name FROM master..sysdatabases WHERE name =
> 'Organisation')
> DROP DATABASE Organisation
> go
> CREATE DATABASE Organisation
> go
> USE Organisation
> go
> CREATE TABLE Company
> (
> CompanyId int IDENTITY (1, 1) NOT NULL,
> CompanyName varchar(50) NOT NULL,
> IsActive char(1) NOT NULL DEFAULT 'Y',
> CONSTRAINT PK_Company PRIMARY KEY (CompanyId)
> )
> CREATE TABLE Contact
> (
> ContactId int IDENTITY (1, 1) NOT NULL,
> CompanyRef int NOT NULL,
> FullName varchar(25) NOT NULL,
> Phone varchar(25) NULL,
> CONSTRAINT PK_Contact PRIMARY KEY (ContactId),
> CONSTRAINT FK_Contact_Company FOREIGN KEY (CompanyRef) REFERENCES Company
> (CompanyId)
> )
> go
> CREATE FUNCTION DummyFunction()
> RETURNS int
> AS
> BEGIN
> RETURN 1
> END
> go
> CREATE VIEW DummyView
> AS
> SELECT
> Company.CompanyName,
> Contact.FullName,
> (SELECT count(*) FROM Company WHERE IsActive = 'Y') As
> NumberOfActiveCompanies
> FROM
> Company
> JOIN Contact ON ContactId = dbo.DummyFunction()
> go
> ----
>
>

Could not find database ID 102. Database may not be activated yet or may be in transition.

Hi (and sorry for sending this again, as a new post this time)
I get this error ocasionally in different parts of our application, but I
had never been able to reproduce it (as it seems to intermitent) until now
when I had a situation where this error always happens.
I've reduced the test script as much as I could to send to the list. I seems
that SQL Server doesn't like when you try to create a VIEW which has a JOIN
using a UDF and a subquery (even if not correlated) in the SELECT clause.
Please see full sample script bellow that reproduces the problem. This is
the error I get when I run it:
Server: Msg 913, Level 16, State 8, Line 4
Could not find database ID 102. Database may not be activated yet or may
be in transition.
Thanks,
Dallara
----
USE master
go
IF EXISTS (SELECT name FROM master..sysdatabases WHERE name = 'Organisation')
DROP DATABASE Organisation
go
CREATE DATABASE Organisation
go
USE Organisation
go
CREATE TABLE Company
(
CompanyId int IDENTITY (1, 1) NOT NULL,
CompanyName varchar(50) NOT NULL,
IsActive char(1) NOT NULL DEFAULT 'Y',
CONSTRAINT PK_Company PRIMARY KEY (CompanyId)
)
CREATE TABLE Contact
(
ContactId int IDENTITY (1, 1) NOT NULL,
CompanyRef int NOT NULL,
FullName varchar(25) NOT NULL,
Phone varchar(25) NULL,
CONSTRAINT PK_Contact PRIMARY KEY (ContactId),
CONSTRAINT FK_Contact_Company FOREIGN KEY (CompanyRef) REFERENCES Company
(CompanyId)
)
go
CREATE FUNCTION DummyFunction()
RETURNS int
AS
BEGIN
RETURN 1
END
go
CREATE VIEW DummyView
AS
SELECT
Company.CompanyName,
Contact.FullName,
(SELECT count(*) FROM Company WHERE IsActive = 'Y') As
NumberOfActiveCompanies
FROM
Company
JOIN Contact ON ContactId = dbo.DummyFunction()
go
----This looks a lot like the bug reported in MSKB 819264
<http://support.microsoft.com/default.aspx?scid=kb;en-us;819264>
In this case, you could move the condition to the WHERE clause and use a
CROSS JOIN:
ALTER VIEW DummyView
AS
SELECT
Company.CompanyName,
Contact.FullName,
(SELECT count(*) FROM Company WHERE IsActive = 'Y') As
NumberOfActiveCompanies
FROM
Company
CROSS JOIN Contact
WHERE ContactId = dbo.DummyFunction()
GO
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Dallara" <someone@.microsoft.com> wrote in message
news:udhF3lgwEHA.824@.TK2MSFTNGP11.phx.gbl...
> Hi (and sorry for sending this again, as a new post this time)
> I get this error ocasionally in different parts of our application, but I
> had never been able to reproduce it (as it seems to intermitent) until now
> when I had a situation where this error always happens.
> I've reduced the test script as much as I could to send to the list. I
> seems
> that SQL Server doesn't like when you try to create a VIEW which has a
> JOIN
> using a UDF and a subquery (even if not correlated) in the SELECT clause.
> Please see full sample script bellow that reproduces the problem. This is
> the error I get when I run it:
> Server: Msg 913, Level 16, State 8, Line 4
> Could not find database ID 102. Database may not be activated yet or may
> be in transition.
>
> Thanks,
> Dallara
>
> ----
> USE master
> go
> IF EXISTS (SELECT name FROM master..sysdatabases WHERE name => 'Organisation')
> DROP DATABASE Organisation
> go
> CREATE DATABASE Organisation
> go
> USE Organisation
> go
> CREATE TABLE Company
> (
> CompanyId int IDENTITY (1, 1) NOT NULL,
> CompanyName varchar(50) NOT NULL,
> IsActive char(1) NOT NULL DEFAULT 'Y',
> CONSTRAINT PK_Company PRIMARY KEY (CompanyId)
> )
> CREATE TABLE Contact
> (
> ContactId int IDENTITY (1, 1) NOT NULL,
> CompanyRef int NOT NULL,
> FullName varchar(25) NOT NULL,
> Phone varchar(25) NULL,
> CONSTRAINT PK_Contact PRIMARY KEY (ContactId),
> CONSTRAINT FK_Contact_Company FOREIGN KEY (CompanyRef) REFERENCES Company
> (CompanyId)
> )
> go
> CREATE FUNCTION DummyFunction()
> RETURNS int
> AS
> BEGIN
> RETURN 1
> END
> go
> CREATE VIEW DummyView
> AS
> SELECT
> Company.CompanyName,
> Contact.FullName,
> (SELECT count(*) FROM Company WHERE IsActive = 'Y') As
> NumberOfActiveCompanies
> FROM
> Company
> JOIN Contact ON ContactId = dbo.DummyFunction()
> go
> ----
>
>

Could not find database ID 102. Database may not be activated yet or may be in transit

Hi (and sorry for sending this again, as a new post this time)
I get this error ocasionally in different parts of our application, but I
had never been able to reproduce it (as it seems to intermitent) until now
when I had a situation where this error always happens.
I've reduced the test script as much as I could to send to the list. I seems
that SQL Server doesn't like when you try to create a VIEW which has a JOIN
using a UDF and a subquery (even if not correlated) in the SELECT clause.
Please see full sample script bellow that reproduces the problem. This is
the error I get when I run it:
Server: Msg 913, Level 16, State 8, Line 4
Could not find database ID 102. Database may not be activated yet or may
be in transition.
Thanks,
Dallara
----
USE master
go
IF EXISTS (SELECT name FROM master..sysdatabases WHERE name =
'Organisation')
DROP DATABASE Organisation
go
CREATE DATABASE Organisation
go
USE Organisation
go
CREATE TABLE Company
(
CompanyId int IDENTITY (1, 1) NOT NULL,
CompanyName varchar(50) NOT NULL,
IsActive char(1) NOT NULL DEFAULT 'Y',
CONSTRAINT PK_Company PRIMARY KEY (CompanyId)
)
CREATE TABLE Contact
(
ContactId int IDENTITY (1, 1) NOT NULL,
CompanyRef int NOT NULL,
FullName varchar(25) NOT NULL,
Phone varchar(25) NULL,
CONSTRAINT PK_Contact PRIMARY KEY (ContactId),
CONSTRAINT FK_Contact_Company FOREIGN KEY (CompanyRef) REFERENCES Company
(CompanyId)
)
go
CREATE FUNCTION DummyFunction()
RETURNS int
AS
BEGIN
RETURN 1
END
go
CREATE VIEW DummyView
AS
SELECT
Company.CompanyName,
Contact.FullName,
(SELECT count(*) FROM Company WHERE IsActive = 'Y') As
NumberOfActiveCompanies
FROM
Company
JOIN Contact ON ContactId = dbo.DummyFunction()
go
----This looks a lot like the bug reported in MSKB 819264
<http://support.microsoft.com/defaul...kb;en-us;819264>
In this case, you could move the condition to the WHERE clause and use a
CROSS JOIN:
ALTER VIEW DummyView
AS
SELECT
Company.CompanyName,
Contact.FullName,
(SELECT count(*) FROM Company WHERE IsActive = 'Y') As
NumberOfActiveCompanies
FROM
Company
CROSS JOIN Contact
WHERE ContactId = dbo.DummyFunction()
GO
Hope this helps.
Dan Guzman
SQL Server MVP
"Dallara" <someone@.microsoft.com> wrote in message
news:udhF3lgwEHA.824@.TK2MSFTNGP11.phx.gbl...
> Hi (and sorry for sending this again, as a new post this time)
> I get this error ocasionally in different parts of our application, but I
> had never been able to reproduce it (as it seems to intermitent) until now
> when I had a situation where this error always happens.
> I've reduced the test script as much as I could to send to the list. I
> seems
> that SQL Server doesn't like when you try to create a VIEW which has a
> JOIN
> using a UDF and a subquery (even if not correlated) in the SELECT clause.
> Please see full sample script bellow that reproduces the problem. This is
> the error I get when I run it:
> Server: Msg 913, Level 16, State 8, Line 4
> Could not find database ID 102. Database may not be activated yet or may
> be in transition.
>
> Thanks,
> Dallara
>
> ----
> USE master
> go
> IF EXISTS (SELECT name FROM master..sysdatabases WHERE name =
> 'Organisation')
> DROP DATABASE Organisation
> go
> CREATE DATABASE Organisation
> go
> USE Organisation
> go
> CREATE TABLE Company
> (
> CompanyId int IDENTITY (1, 1) NOT NULL,
> CompanyName varchar(50) NOT NULL,
> IsActive char(1) NOT NULL DEFAULT 'Y',
> CONSTRAINT PK_Company PRIMARY KEY (CompanyId)
> )
> CREATE TABLE Contact
> (
> ContactId int IDENTITY (1, 1) NOT NULL,
> CompanyRef int NOT NULL,
> FullName varchar(25) NOT NULL,
> Phone varchar(25) NULL,
> CONSTRAINT PK_Contact PRIMARY KEY (ContactId),
> CONSTRAINT FK_Contact_Company FOREIGN KEY (CompanyRef) REFERENCES Company
> (CompanyId)
> )
> go
> CREATE FUNCTION DummyFunction()
> RETURNS int
> AS
> BEGIN
> RETURN 1
> END
> go
> CREATE VIEW DummyView
> AS
> SELECT
> Company.CompanyName,
> Contact.FullName,
> (SELECT count(*) FROM Company WHERE IsActive = 'Y') As
> NumberOfActiveCompanies
> FROM
> Company
> JOIN Contact ON ContactId = dbo.DummyFunction()
> go
> ----
>
>

Could not establish trust relationship with remote server - Part.2

Hi,
Iâ'm posting now for the second time with this issueâ?¦hopefully can somebody
helpâ?¦
We have to new installed Server with the same configuration (except hardware):
- Windows 2003 Enterprise (fully updated)
- SQL Server 2000 Enterprise SP3a
- Reporting Services SP1
- Patch SQL2000-KB810185-8.00.0859 (asked by the installation cause using a
domain account for the Report Service and for the SQL Server connections.
- SSL (checked during installation)
The https://myserver.com/reportserver works fine. If I browse to
https://myserver.com/reports (Report manager) Iâ'm getting the message â'The
underlying connection was closed: Could not establish trust relationship with
remote serverâ'. Itâ's killing me. Iâ'm fighting since a long time with this
problemâ?¦.Iâ've everywhere within the config files the corresponding
https://myservber.com entries. SecureConnectionLevel set to 3 (tried with 2
also). Iâ'm able to browse to any https site on the server using the same
certificate without any messages or warnings. And Iâ've this problem on both
serversâ?¦.:-((
Following you will see theReportServerWebApp_xxxxxxx Log file. Why do I have
the entry â'Initializing SecureConnectionLevel to default value of '1' â' ?
Iâ've configured this Value to 3 within RSReportServer.config. Do I need to
change an other file as well? Or any other ideas ?
Many thanks for your help !!
Dominic
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>W. Europe Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerWebApp__11_10_2004_08_05_23.log</Path>
<SystemName>CLAPTON</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing MaxScheduleWait
to default value of '1' second(s) because it was not specified in
Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
DatabaseQueryTimeout to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing InstanceName to
default value of 'MSSQLSERVER.1' because it was not specified in
Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
ProcessRecycleOptions to default value of '0' because it was not specified
in Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
RunningRequestsScavengerCycle to default value of '30' second(s) because it
was not specified in Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
RunningRequestsDbCycle to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
RunningRequestsAge to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
CleanupCycleMinutes to default value of '10' minute(s) because it was not
specified in Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
SecureConnectionLevel to default value of '1' because it was not specified
in Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
w3wp!ui!ea0!11/10/2004-08:05:41:: e ERROR: The underlying connection was
closed: Could not establish trust relationship with remote server.
w3wp!ui!ea0!11/10/2004-08:05:41:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: The underlying connection was closed: Could not
establish trust relationship with remote server. at
System.Net.HttpWebRequest.CheckFinalStatus() at
System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult) at
System.Net.HttpWebRequest.GetRequestStream() at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) at
Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname) at Microsoft.ReportingServices.UI.Global.SecureAllAPI() at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level) at
Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args) at System.EventHandler.Invoke(Object sender,
EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at
System.Web.UI.Control.InitRecursive(Control namingContainer) at
System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!ea0!11/10/2004-08:05:46:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)Did you come up with an answer? if so, please post it... I am having the same
problem.
"Dominic" wrote:
> Hi,
> Iâ'm posting now for the second time with this issueâ?¦hopefully can somebody
> helpâ?¦
> We have to new installed Server with the same configuration (except hardware):
> - Windows 2003 Enterprise (fully updated)
> - SQL Server 2000 Enterprise SP3a
> - Reporting Services SP1
> - Patch SQL2000-KB810185-8.00.0859 (asked by the installation cause using a
> domain account for the Report Service and for the SQL Server connections.
> - SSL (checked during installation)
> The https://myserver.com/reportserver works fine. If I browse to
> https://myserver.com/reports (Report manager) Iâ'm getting the message â'The
> underlying connection was closed: Could not establish trust relationship with
> remote serverâ'. Itâ's killing me. Iâ'm fighting since a long time with this
> problemâ?¦.Iâ've everywhere within the config files the corresponding
> https://myservber.com entries. SecureConnectionLevel set to 3 (tried with 2
> also). Iâ'm able to browse to any https site on the server using the same
> certificate without any messages or warnings. And Iâ've this problem on both
> serversâ?¦.:-((
> Following you will see theReportServerWebApp_xxxxxxx Log file. Why do I have
> the entry â'Initializing SecureConnectionLevel to default value of '1' â' ?
> Iâ've configured this Value to 3 within RSReportServer.config. Do I need to
> change an other file as well? Or any other ideas ?
> Many thanks for your help !!
> Dominic
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.878.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>W. Europe Standard Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerWebApp__11_10_2004_08_05_23.log</Path>
> <SystemName>CLAPTON</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing MaxScheduleWait
> to default value of '1' second(s) because it was not specified in
> Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> DatabaseQueryTimeout to default value of '30' second(s) because it was not
> specified in Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing InstanceName to
> default value of 'MSSQLSERVER.1' because it was not specified in
> Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> ProcessRecycleOptions to default value of '0' because it was not specified
> in Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> RunningRequestsScavengerCycle to default value of '30' second(s) because it
> was not specified in Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> RunningRequestsDbCycle to default value of '30' second(s) because it was not
> specified in Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> RunningRequestsAge to default value of '30' second(s) because it was not
> specified in Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> CleanupCycleMinutes to default value of '10' minute(s) because it was not
> specified in Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> SecureConnectionLevel to default value of '1' because it was not specified
> in Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing DisplayErrorLink
> to 'True' as specified in Configuration file.
> w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> WebServiceUseFileShareStorage to default value of 'False' because it was not
> specified in Configuration file.
> w3wp!ui!ea0!11/10/2004-08:05:41:: e ERROR: The underlying connection was
> closed: Could not establish trust relationship with remote server.
> w3wp!ui!ea0!11/10/2004-08:05:41:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The underlying connection was closed: Could not
> establish trust relationship with remote server. at
> System.Net.HttpWebRequest.CheckFinalStatus() at
> System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult) at
> System.Net.HttpWebRequest.GetRequestStream() at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) at
> Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
> at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> at Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> methodname) at Microsoft.ReportingServices.UI.Global.SecureAllAPI() at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> level) at
> Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args) at System.EventHandler.Invoke(Object sender,
> EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at
> System.Web.UI.Control.InitRecursive(Control namingContainer) at
> System.Web.UI.Page.ProcessRequestMain()
> w3wp!ui!ea0!11/10/2004-08:05:46:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)|||Hi Ron
No, I gave up. I'm running it now in mixed mode.....the users are running
the reports using SSL and the management part is actually running without
SSLâ?¦.itâ's bad but we had to go productionâ?¦anyway - the configuration-part is
not very well with RS (the logging is not always a real help)â?¦.RS is nice but
Microsoft has still a lot to do !
Regards,
Dominic
"Ron Sellers" wrote:
> Did you come up with an answer? if so, please post it... I am having the same
> problem.
> "Dominic" wrote:
> > Hi,
> >
> > Iâ'm posting now for the second time with this issueâ?¦hopefully can somebody
> > helpâ?¦
> >
> > We have to new installed Server with the same configuration (except hardware):
> > - Windows 2003 Enterprise (fully updated)
> > - SQL Server 2000 Enterprise SP3a
> > - Reporting Services SP1
> > - Patch SQL2000-KB810185-8.00.0859 (asked by the installation cause using a
> > domain account for the Report Service and for the SQL Server connections.
> > - SSL (checked during installation)
> >
> > The https://myserver.com/reportserver works fine. If I browse to
> > https://myserver.com/reports (Report manager) Iâ'm getting the message â'The
> > underlying connection was closed: Could not establish trust relationship with
> > remote serverâ'. Itâ's killing me. Iâ'm fighting since a long time with this
> > problemâ?¦.Iâ've everywhere within the config files the corresponding
> > https://myservber.com entries. SecureConnectionLevel set to 3 (tried with 2
> > also). Iâ'm able to browse to any https site on the server using the same
> > certificate without any messages or warnings. And Iâ've this problem on both
> > serversâ?¦.:-((
> >
> > Following you will see theReportServerWebApp_xxxxxxx Log file. Why do I have
> > the entry â'Initializing SecureConnectionLevel to default value of '1' â' ?
> > Iâ've configured this Value to 3 within RSReportServer.config. Do I need to
> > change an other file as well? Or any other ideas ?
> >
> > Many thanks for your help !!
> > Dominic
> >
> > <Header>
> > <Product>Microsoft SQL Server Reporting Services Version
> > 8.00.878.00</Product>
> > <Locale>en-US</Locale>
> > <TimeZone>W. Europe Standard Time</TimeZone>
> > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\LogFiles\ReportServerWebApp__11_10_2004_08_05_23.log</Path>
> > <SystemName>CLAPTON</SystemName>
> > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> > <OSVersion>5.2.3790.0</OSVersion>
> > </Header>
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing MaxScheduleWait
> > to default value of '1' second(s) because it was not specified in
> > Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > DatabaseQueryTimeout to default value of '30' second(s) because it was not
> > specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing InstanceName to
> > default value of 'MSSQLSERVER.1' because it was not specified in
> > Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > ProcessRecycleOptions to default value of '0' because it was not specified
> > in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > RunningRequestsScavengerCycle to default value of '30' second(s) because it
> > was not specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > RunningRequestsDbCycle to default value of '30' second(s) because it was not
> > specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > RunningRequestsAge to default value of '30' second(s) because it was not
> > specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > CleanupCycleMinutes to default value of '10' minute(s) because it was not
> > specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > SecureConnectionLevel to default value of '1' because it was not specified
> > in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing DisplayErrorLink
> > to 'True' as specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > WebServiceUseFileShareStorage to default value of 'False' because it was not
> > specified in Configuration file.
> > w3wp!ui!ea0!11/10/2004-08:05:41:: e ERROR: The underlying connection was
> > closed: Could not establish trust relationship with remote server.
> > w3wp!ui!ea0!11/10/2004-08:05:41:: e ERROR: HTTP status code --> 500
> > --Details--
> > System.Net.WebException: The underlying connection was closed: Could not
> > establish trust relationship with remote server. at
> > System.Net.HttpWebRequest.CheckFinalStatus() at
> > System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult) at
> > System.Net.HttpWebRequest.GetRequestStream() at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) at
> > Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
> > at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> > at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> > at Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> > methodname) at Microsoft.ReportingServices.UI.Global.SecureAllAPI() at
> > Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> > level) at
> > Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> > sender, EventArgs args) at System.EventHandler.Invoke(Object sender,
> > EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at
> > System.Web.UI.Control.InitRecursive(Control namingContainer) at
> > System.Web.UI.Page.ProcessRequestMain()
> > w3wp!ui!ea0!11/10/2004-08:05:46:: e ERROR: Exception in ShowErrorPage:
> > System.Threading.ThreadAbortException: Thread was being aborted.
> > at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg) at at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg)|||I was having the same problems until a few minutes ago. I went back through
the following article and found the problem (in my situation at least):
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sslsetup.asp
Down at the section:
Installing Reporting Services -> Reporting Services Configuration Files ->
RSWebApplication.config
I hadn't changed the <ReportServerUrl> value to the https://reports.xxx.xxx
(must by an exact match to the value in the SSL certificate) or added the
<Add Key="SecureConnectionLevel" Value="3"/> element. Actually, I hadn't even
looked in this file because my eyes fooling me into thinking it was the
RSReportServer.config file. oops!
Anyway making the RSWebApplication.config look like this worked when all
other paths had failed.
++++++++++++++++++++++++++++++
<Configuration>
<UI>
<ReportServerUrl>https://reports.xxx.xxx/ReportServer</ReportServerUrl>
</UI>
<Extensions>
<DeliveryUI>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">
<DefaultDeliveryExtension>True</DefaultDeliveryExtension>
<Configuration>
<RSEmailDPConfiguration>
<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider">
<Configuration>
<FileShare>
<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
</FileShare>
</Configuration>
</Extension>
</DeliveryUI>
</Extensions>
<Add Key="SecureConnectionLevel" Value="3"/>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DisplayErrorLink" Value="true"/>
</Configuration>
++++++++++++++++++++++++++++++
Hope this is what you were looking for.
Mike Shaw
"Ron Sellers" wrote:
> Did you come up with an answer? if so, please post it... I am having the same
> problem.
> "Dominic" wrote:
> > Hi,
> >
> > Iâ'm posting now for the second time with this issueâ?¦hopefully can somebody
> > helpâ?¦
> >
> > We have to new installed Server with the same configuration (except hardware):
> > - Windows 2003 Enterprise (fully updated)
> > - SQL Server 2000 Enterprise SP3a
> > - Reporting Services SP1
> > - Patch SQL2000-KB810185-8.00.0859 (asked by the installation cause using a
> > domain account for the Report Service and for the SQL Server connections.
> > - SSL (checked during installation)
> >
> > The https://myserver.com/reportserver works fine. If I browse to
> > https://myserver.com/reports (Report manager) Iâ'm getting the message â'The
> > underlying connection was closed: Could not establish trust relationship with
> > remote serverâ'. Itâ's killing me. Iâ'm fighting since a long time with this
> > problemâ?¦.Iâ've everywhere within the config files the corresponding
> > https://myservber.com entries. SecureConnectionLevel set to 3 (tried with 2
> > also). Iâ'm able to browse to any https site on the server using the same
> > certificate without any messages or warnings. And Iâ've this problem on both
> > serversâ?¦.:-((
> >
> > Following you will see theReportServerWebApp_xxxxxxx Log file. Why do I have
> > the entry â'Initializing SecureConnectionLevel to default value of '1' â' ?
> > Iâ've configured this Value to 3 within RSReportServer.config. Do I need to
> > change an other file as well? Or any other ideas ?
> >
> > Many thanks for your help !!
> > Dominic
> >
> > <Header>
> > <Product>Microsoft SQL Server Reporting Services Version
> > 8.00.878.00</Product>
> > <Locale>en-US</Locale>
> > <TimeZone>W. Europe Standard Time</TimeZone>
> > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\LogFiles\ReportServerWebApp__11_10_2004_08_05_23.log</Path>
> > <SystemName>CLAPTON</SystemName>
> > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> > <OSVersion>5.2.3790.0</OSVersion>
> > </Header>
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing MaxScheduleWait
> > to default value of '1' second(s) because it was not specified in
> > Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > DatabaseQueryTimeout to default value of '30' second(s) because it was not
> > specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing InstanceName to
> > default value of 'MSSQLSERVER.1' because it was not specified in
> > Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > ProcessRecycleOptions to default value of '0' because it was not specified
> > in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > RunningRequestsScavengerCycle to default value of '30' second(s) because it
> > was not specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > RunningRequestsDbCycle to default value of '30' second(s) because it was not
> > specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > RunningRequestsAge to default value of '30' second(s) because it was not
> > specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > CleanupCycleMinutes to default value of '10' minute(s) because it was not
> > specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > SecureConnectionLevel to default value of '1' because it was not specified
> > in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing DisplayErrorLink
> > to 'True' as specified in Configuration file.
> > w3wp!library!e94!11/10/2004-08:05:23:: i INFO: Initializing
> > WebServiceUseFileShareStorage to default value of 'False' because it was not
> > specified in Configuration file.
> > w3wp!ui!ea0!11/10/2004-08:05:41:: e ERROR: The underlying connection was
> > closed: Could not establish trust relationship with remote server.
> > w3wp!ui!ea0!11/10/2004-08:05:41:: e ERROR: HTTP status code --> 500
> > --Details--
> > System.Net.WebException: The underlying connection was closed: Could not
> > establish trust relationship with remote server. at
> > System.Net.HttpWebRequest.CheckFinalStatus() at
> > System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult) at
> > System.Net.HttpWebRequest.GetRequestStream() at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) at
> > Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
> > at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> > at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> > at Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> > methodname) at Microsoft.ReportingServices.UI.Global.SecureAllAPI() at
> > Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> > level) at
> > Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> > sender, EventArgs args) at System.EventHandler.Invoke(Object sender,
> > EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at
> > System.Web.UI.Control.InitRecursive(Control namingContainer) at
> > System.Web.UI.Page.ProcessRequestMain()
> > w3wp!ui!ea0!11/10/2004-08:05:46:: e ERROR: Exception in ShowErrorPage:
> > System.Threading.ThreadAbortException: Thread was being aborted.
> > at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg) at at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg)|||That did it! Thanks Mike!