Interger Concatenation

Hey,
Does anyone know how to do integer concatenation using sql?
Say for instance I have 2004 and 12, I need 200412 and not 2016.
Can this be done?
ThanksDECLARE @.x int, @.y int
SELECT @.x = 2004, @.y = 12
SELECT CONVERT(int,(CONVERT(varchar(15),@.x) + CONVERT(varchar(15),@.y)))|||Thanks for the reply,

But what about if what I am doing is using the datepart function.

ex.

datepart("yy", '12/12/2004') + datepart("mm", '12/12/2004')

I need 200412.

Still work the same way?

Thanks|||I could have said yes and yes and have answered the questions you aske dwith that. However, turn them into character strings and then concatenate the results.

i.e.
declare @.year int, @.month int, @.result varchar(50)
select @.year = 2004, @.month = 12
select @.result = convert(varchar(20),@.year) + convert(varchar(20),@.month
select @.result|||Ya know...it's alot easier to get you the right answer when you ask the right question.

Please don't tell me you're going to store this data in a table though

SELECT CONVERT(varchar(4),DATEPART(yy, '12/12/2004')) + CONVERT(varchar(2),DATEPART(mm, '12/12/2004'))|||Ya, I guess the right question makes for the right answer.

And nope, its not going in a table, just needs it to make some comparisons.

Thanks for the help.|||Ya, I guess the right question makes for the right answer.

And nope, its not going in a table, just needs it to make some comparisons.

Thanks for the help.

Compare it to what? To data that looks like that in some other table?

That'll scan for sure...|||Actually, I am in the process of upgrading a reporting system the uses two date inputs to bring back the correct timeframe of data, say from 11/01/2004 to 11/30/2004, but what happens now is that if you went from one year to the next say from 11/01/2004 to 02/30/2005 is crashes. So I was given the task to fix this.

As it works now, it only uses the month part of the date to make comparsions. It only scans for data between the months of the initial date input.

Eventually I will have to comapre full years, but for now I just needs to get it working from year to year.

Any suggestions?|||...forest for the trees, gentlemen:

convert(char(6), cast('12/12/04' as datetime), 112)

...or if it already a datetime value, then just:

convert(char(6), [YourValue], 112)

...but I suspect from your last post that you should not be converting this at all, and that you are better off using SQL Server's rich set of date functions than converting this to a six character string. Give us an example of the BETWEEN statement that you are using...|||This is the table (should be a temp table) where the months between the dates are stored for comparsion

create table monthspan(currentmonth int)

declare @.monthCount int
set @.monthCount = datepart(mm, @.FromDate)
while (@.monthCount <= datepart(mm, @.ToDate))
BEGIN
insert monthspan select @.monthCount
set @.monthCount = @.monthCount + 1
END|||I'm assuming the actual data is in date form...

You should be using DATEDIFF|||How would using DATEDIFF work if I needed to compare values to it?|||USE Northwind
GO

SET NOCOUNT ON
CREATE TABLE myTable99(Col1 int IDENTITY(1,1), Col2 datetime)
GO

INSERT INTO myTable99(Col2)
SELECT '1/1/2003' UNION ALL SELECT '2/1/2003' UNION ALL SELECT '3/1/2003' UNION ALL
SELECT '4/1/2003' UNION ALL SELECT '5/1/2003' UNION ALL SELECT '6/1/2003' UNION ALL
SELECT '7/1/2003' UNION ALL SELECT '8/1/2003' UNION ALL SELECT '9/1/2003' UNION ALL
SELECT '10/1/2003' UNION ALL SELECT '11/1/2003' UNION ALL SELECT '12/1/2003' UNION ALL
SELECT '1/1/2004' UNION ALL SELECT '2/1/2004' UNION ALL SELECT '3/1/2004' UNION ALL
SELECT '4/1/2004' UNION ALL SELECT '5/1/2004' UNION ALL SELECT '6/1/2004' UNION ALL
SELECT '7/1/2004' UNION ALL SELECT '8/1/2004' UNION ALL SELECT '9/1/2004' UNION ALL
SELECT '10/1/2004' UNION ALL SELECT '11/1/2004' UNION ALL SELECT '12/1/2004'
GO

-- Let's get the last 14 months of Data

SELECT * FROM myTable99
WHERE DATEDIFF(m,Col2,GetDate()) < 14
GO

SET NOCOUNT OFF
DROP TABLE myTable99
GOsql

Interesting problem with table/filesystem growth

Any body have any ideas on this one?
Have an Sqlserver 2000 instance with SP3a on it and had a
problem where we had multiple data files within the
primary filegroup. An end user was adding rows into the
table and received an out of space error on the data
component. Checking the properties on the files the auto
extend option had been turned off , which was fine in our
environment, however, checking the space used in each of
these files showed that there was plenty of space
available for use in all. (No, it wasnt the trans log that
gave grief), I allowed the autoextend on each file and got
over the problem for the table in the short term , (and
saw one of the files extend.)
This lead me to do some thinking about the way Sqlserver
handles the growth of tables on multiple files. The good
book says that Sqlserver will allocate in a round robin
fashion the data pages to a table, however this doesnt
seem to be the case. Also, How does the table what file it
is on. I found this in the sysindexes table and decoding
the first value (Contains fileid and page id and row
offset).
Thats fine, however the major problem is, if Sqlserver
doesnt do the round robin allocation of datapages like it
should, then are all your free space calcs on the file
allocation valid?
Any thoughts' Any stored procedures about to handle this'
cheers
MikeWe've had an experience in the past, where the disks seemed to get overused
and reported an error similar to (unable to allocate space). Unfortunately,
I cannot
remember the specifics. We've had a problem where the auto-extend conflicts
with
an insert.
With regard to the round robin filling, sql server will fill the files using
a proporitional
algorithm. Therefore if you fill one file then add another, the 2nd file
will get filled. If
you create 2 files at the same time, then you will observe that each file is
filled with the
same amount of data each time. In short a 20GB insert will put 10GB in each
file.
HTH
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:1a9101c3e08e$548d4c70$a101280a@.phx.gbl...
> Any body have any ideas on this one?
> Have an Sqlserver 2000 instance with SP3a on it and had a
> problem where we had multiple data files within the
> primary filegroup. An end user was adding rows into the
> table and received an out of space error on the data
> component. Checking the properties on the files the auto
> extend option had been turned off , which was fine in our
> environment, however, checking the space used in each of
> these files showed that there was plenty of space
> available for use in all. (No, it wasnt the trans log that
> gave grief), I allowed the autoextend on each file and got
> over the problem for the table in the short term , (and
> saw one of the files extend.)
> This lead me to do some thinking about the way Sqlserver
> handles the growth of tables on multiple files. The good
> book says that Sqlserver will allocate in a round robin
> fashion the data pages to a table, however this doesnt
> seem to be the case. Also, How does the table what file it
> is on. I found this in the sysindexes table and decoding
> the first value (Contains fileid and page id and row
> offset).
> Thats fine, however the major problem is, if Sqlserver
> doesnt do the round robin allocation of datapages like it
> should, then are all your free space calcs on the file
> allocation valid?
> Any thoughts' Any stored procedures about to handle this'
> cheers
> Mike|||Interesting,
still leads to the problem where you think you should have
space available because you tally the total of all file
systems and unfortunately one is full!!! Kind of makes one
stop and think about what level should your space
statistcs be collected at and how you manage them!
>--Original Message--
>We've had an experience in the past, where the disks
seemed to get overused
>and reported an error similar to (unable to allocate
space). Unfortunately,
>I cannot
>remember the specifics. We've had a problem where the
auto-extend conflicts
>with
>an insert.
>
>With regard to the round robin filling, sql server will
fill the files using
>a proporitional
>algorithm. Therefore if you fill one file then add
another, the 2nd file
>will get filled. If
>you create 2 files at the same time, then you will
observe that each file is
>filled with the
>same amount of data each time. In short a 20GB insert
will put 10GB in each
>file.
>HTH
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1a9101c3e08e$548d4c70$a101280a@.phx.gbl...
>> Any body have any ideas on this one?
>> Have an Sqlserver 2000 instance with SP3a on it and had
a
>> problem where we had multiple data files within the
>> primary filegroup. An end user was adding rows into the
>> table and received an out of space error on the data
>> component. Checking the properties on the files the auto
>> extend option had been turned off , which was fine in
our
>> environment, however, checking the space used in each of
>> these files showed that there was plenty of space
>> available for use in all. (No, it wasnt the trans log
that
>> gave grief), I allowed the autoextend on each file and
got
>> over the problem for the table in the short term , (and
>> saw one of the files extend.)
>> This lead me to do some thinking about the way Sqlserver
>> handles the growth of tables on multiple files. The good
>> book says that Sqlserver will allocate in a round robin
>> fashion the data pages to a table, however this doesnt
>> seem to be the case. Also, How does the table what file
it
>> is on. I found this in the sysindexes table and decoding
>> the first value (Contains fileid and page id and row
>> offset).
>> Thats fine, however the major problem is, if Sqlserver
>> doesnt do the round robin allocation of datapages like
it
>> should, then are all your free space calcs on the file
>> allocation valid?
>> Any thoughts' Any stored procedures about to handle
this'
>> cheers
>> Mike
>
>.
>

Interesting problem with table/filesystem growth

Any body have any ideas on this one?
Have an Sqlserver 2000 instance with SP3a on it and had a
problem where we had multiple data files within the
primary filegroup. An end user was adding rows into the
table and received an out of space error on the data
component. Checking the properties on the files the auto
extend option had been turned off , which was fine in our
environment, however, checking the space used in each of
these files showed that there was plenty of space
available for use in all. (No, it wasnt the trans log that
gave grief), I allowed the autoextend on each file and got
over the problem for the table in the short term , (and
saw one of the files extend.)
This lead me to do some thinking about the way Sqlserver
handles the growth of tables on multiple files. The good
book says that Sqlserver will allocate in a round robin
fashion the data pages to a table, however this doesnt
seem to be the case. Also, How does the table what file it
is on. I found this in the sysindexes table and decoding
the first value (Contains fileid and page id and row
offset).
Thats fine, however the major problem is, if Sqlserver
doesnt do the round robin allocation of datapages like it
should, then are all your free space calcs on the file
allocation valid?
Any thoughts' Any stored procedures about to handle this'
cheers
MikeWe've had an experience in the past, where the disks seemed to get overused
and reported an error similar to (unable to allocate space). Unfortunately,
I cannot
remember the specifics. We've had a problem where the auto-extend conflicts
with
an insert.
With regard to the round robin filling, sql server will fill the files using
a proporitional
algorithm. Therefore if you fill one file then add another, the 2nd file
will get filled. If
you create 2 files at the same time, then you will observe that each file is
filled with the
same amount of data each time. In short a 20GB insert will put 10GB in each
file.
HTH
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:1a9101c3e08e$548d4c70$a101280a@.phx.gbl...

quote:

---

> Any body have any ideas on this one?
> Have an Sqlserver 2000 instance with SP3a on it and had a
> problem where we had multiple data files within the
> primary filegroup. An end user was adding rows into the
> table and received an out of space error on the data
> component. Checking the properties on the files the auto
> extend option had been turned off , which was fine in our
> environment, however, checking the space used in each of
> these files showed that there was plenty of space
> available for use in all. (No, it wasnt the trans log that
> gave grief), I allowed the autoextend on each file and got
> over the problem for the table in the short term , (and
> saw one of the files extend.)
> This lead me to do some thinking about the way Sqlserver
> handles the growth of tables on multiple files. The good
> book says that Sqlserver will allocate in a round robin
> fashion the data pages to a table, however this doesnt
> seem to be the case. Also, How does the table what file it
> is on. I found this in the sysindexes table and decoding
> the first value (Contains fileid and page id and row
> offset).
> Thats fine, however the major problem is, if Sqlserver
> doesnt do the round robin allocation of datapages like it
> should, then are all your free space calcs on the file
> allocation valid?
> Any thoughts' Any stored procedures about to handle this'
> cheers
> Mike

---

|||Interesting,
still leads to the problem where you think you should have
space available because you tally the total of all file
systems and unfortunately one is full!!! Kind of makes one
stop and think about what level should your space
statistcs be collected at and how you manage them!

quote:

---

>--Original Message--
>We've had an experience in the past, where the disks

---

seemed to get overused

quote:

---

>and reported an error similar to (unable to allocate

---

space). Unfortunately,

quote:

---

>I cannot
>remember the specifics. We've had a problem where the

---

auto-extend conflicts

quote:

---

>with
>an insert.
>
>With regard to the round robin filling, sql server will

---

fill the files using

quote:

---

>a proporitional
>algorithm. Therefore if you fill one file then add

---

another, the 2nd file

quote:

---

>will get filled. If
>you create 2 files at the same time, then you will

---

observe that each file is

quote:

---

>filled with the
>same amount of data each time. In short a 20GB insert

---

will put 10GB in each

quote:

---

>file.
>HTH
>"Mike" <anonymous@.discussions.microsoft.com> wrote in

---

message

quote:

---

>news:1a9101c3e08e$548d4c70$a101280a@.phx.gbl...
a[QUOTE]
our[QUOTE]
that[QUOTE]
got[QUOTE]
it[QUOTE]
it[QUOTE]
this'[QUOTE]
>
>.
>

---

sql

Integration with Sharepoint Server 2007 - Second instance of servi

Ok, I have a SQL 2005 sp2 server running reporting service on one server, and
Sharepoint Portal 2007 on another server. As I have reports setup and want
to continue using reports manager, I installed a second instance of Report
services on my SQL server. I installed Portal server on the SQL server (as
front end server) and it appears as a member of the Sharepoint farm. I setup
a new database using the Reporting services Config wizard in integrated mode.
I am using a domain user for the windows and web service accounts.
On the sql server when browsing to the virtual directory for the reports
server "http://servername/reportserver" I get the following error:
"The report server has encountered a configuration error. See the report
server log files for more information. (rsServerConfigurationError) Get
Online Help "
from other network locations, I get a request for authentication that always
fails.
The log file contains the following:
w3wp!webserver!1!6/11/2007-10:24:13:: i INFO: Reporting Web Server started
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing ConnectionType to
'0' as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing IsSchedulingService
to 'True' as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing IsEventService to
'True' as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing PollingInterval to
'10' second(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
WindowsServiceUseFileShareStorage to 'False' as specified in Configuration
file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing MemoryLimit to '60'
percent as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing RecycleTime to
'720' minute(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing MaximumMemoryLimit
to '80' percent as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing MaxQueueThreads to
'0' thread(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing IsWebServiceEnabled
to 'True' as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing MaxScheduleWait to
'5' second(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration
file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing RunningRequestsAge
to '30' second(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing CleanupCycleMinutes
to '10' minute(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
DailyCleanupMinuteOfDay to default value of '120' minutes since midnight
because it was not specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing WatsonFlags to
'1064' as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
WatsonDumpOnExceptions to
'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
WatsonDumpExcludeIfContainsExceptions to
'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing DisplayErrorLink to
'True' as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!6/11/2007-10:24:13:: i INFO: Reporting Services
starting SKU: Standard
w3wp!resourceutilities!1!6/11/2007-10:24:13:: i INFO: Evaluation copy: 0
days left
w3wp!resourceutilities!1!6/11/2007-10:24:13:: i INFO: Running on 1 physical
processors, 2 logical processors
w3wp!runningjobs!1!6/11/2007-10:24:13:: i INFO: Database Cleanup (Web
Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!6/11/2007-10:24:13:: i INFO: Running Requests Scavenger
timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!6/11/2007-10:24:13:: i INFO: Running Requests DB timer
enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!6/11/2007-10:24:13:: i INFO: Memory stats update timer
enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!06/11/2007-10:24:14:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information., SharePoint content service is null.
Report Server may not have joined the SharePoint farm, or Report Server
service account may not have been granted access to farm.;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information.
w3wp!library!7!6/11/2007-10:25:13:: i INFO: Catalog SQL Server Edition = Standard
I have read a large number of posts, and went through installation steps
repeatedly. I setup SPN for the webservice account. I just can't see what I
am missing.
Please advise.
--
Fredrick A. Zilz
Director IT
InterHealth N.I.I made one step forward. I found I had a duplicate SPN which was preventing
a log in to the Reportserver web site. So I can now browse to the
http://machinename/reportserver site. I am, however still not able to set
the default settings on the Sharepoint Portal side. I may need to move this
to a sharepoint group.
Thanks in advance for any advice.
--
Fredrick A. Zilz
Director IT
InterHealth N.I.
"Fred Zilz" wrote:
> Ok, I have a SQL 2005 sp2 server running reporting service on one server, and
> Sharepoint Portal 2007 on another server. As I have reports setup and want
> to continue using reports manager, I installed a second instance of Report
> services on my SQL server. I installed Portal server on the SQL server (as
> front end server) and it appears as a member of the Sharepoint farm. I setup
> a new database using the Reporting services Config wizard in integrated mode.
> I am using a domain user for the windows and web service accounts.
> On the sql server when browsing to the virtual directory for the reports
> server "http://servername/reportserver" I get the following error:
> "The report server has encountered a configuration error. See the report
> server log files for more information. (rsServerConfigurationError) Get
> Online Help "
> from other network locations, I get a request for authentication that always
> fails.
> The log file contains the following:
> w3wp!webserver!1!6/11/2007-10:24:13:: i INFO: Reporting Web Server started
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing ConnectionType to
> '0' as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing IsSchedulingService
> to 'True' as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> IsNotificationService to 'True' as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing IsEventService to
> 'True' as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing PollingInterval to
> '10' second(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> WindowsServiceUseFileShareStorage to 'False' as specified in Configuration
> file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing MemoryLimit to '60'
> percent as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing RecycleTime to
> '720' minute(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing MaximumMemoryLimit
> to '80' percent as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing MaxQueueThreads to
> '0' thread(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing IsWebServiceEnabled
> to 'True' as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing MaxScheduleWait to
> '5' second(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> ProcessRecycleOptions to '0' as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration
> file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing RunningRequestsAge
> to '30' second(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing CleanupCycleMinutes
> to '10' minute(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> DailyCleanupMinuteOfDay to default value of '120' minutes since midnight
> because it was not specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing WatsonFlags to
> '1064' as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> WatsonDumpOnExceptions to
> 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
> as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> WatsonDumpExcludeIfContainsExceptions to
> 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
> as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> SecureConnectionLevel to '0' as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing DisplayErrorLink to
> 'True' as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
> w3wp!resourceutilities!1!6/11/2007-10:24:13:: i INFO: Reporting Services
> starting SKU: Standard
> w3wp!resourceutilities!1!6/11/2007-10:24:13:: i INFO: Evaluation copy: 0
> days left
> w3wp!resourceutilities!1!6/11/2007-10:24:13:: i INFO: Running on 1 physical
> processors, 2 logical processors
> w3wp!runningjobs!1!6/11/2007-10:24:13:: i INFO: Database Cleanup (Web
> Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
> w3wp!runningjobs!1!6/11/2007-10:24:13:: i INFO: Running Requests Scavenger
> timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
> w3wp!runningjobs!1!6/11/2007-10:24:13:: i INFO: Running Requests DB timer
> enabled: Next Event: 60 seconds. Cycle: 60 seconds
> w3wp!runningjobs!1!6/11/2007-10:24:13:: i INFO: Memory stats update timer
> enabled: Next Event: 60 seconds. Cycle: 60 seconds
> w3wp!library!1!06/11/2007-10:24:14:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The report server has encountered a configuration error. See the report
> server log files for more information., SharePoint content service is null.
> Report Server may not have joined the SharePoint farm, or Report Server
> service account may not have been granted access to farm.;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The report server has encountered a configuration error. See the report
> server log files for more information.
> w3wp!library!7!6/11/2007-10:25:13:: i INFO: Catalog SQL Server Edition => Standard
>
> I have read a large number of posts, and went through installation steps
> repeatedly. I setup SPN for the webservice account. I just can't see what I
> am missing.
> Please advise.
>
> --
> Fredrick A. Zilz
> Director IT
> InterHealth N.I.