Run Policies /Surface Area Configuration - Bug

Hi!

I've created the "Off By Default Policy" as described in BOL (ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/41c3022d-ab13-443e-ac64-ba1d64584f79.htm) for SQL Mail and Database Mail.

When I then activate SQL Mail and Database Mail through Surface Area Configuration (without closing it!) and then run the policy and configure it (so that SQL Mail and Database Mail) is then off, these changes are not reflected by Surface Area Configuration.

You must restart Surface Area Configuration, so that you can see the changes.

HTH

Klaus Aschenbrenner

http://www.csharp.at

http://www.csharp.at/blog

The SAC doesn't auto refresh but that seems quite normal to me.

Maybe a refresh button would be nice since restarting is not an intuitive way to refresh of course :-)

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

The Surface Area Configuration tool will most likely be pulled in a later CTP; probably as soon as we can support all of the server types (DB Engine, Analysis Services, and Reporting Services) in Management Studio using policies. For now you'll need to close and re-open the Surface Area Configuration tool to see the changes.

Cheers,

Dan

Run a DTS Package "in the background" or with low priority?

Configuration:
Windows 2000
Sql Server 2000
Quad CPU
Problem:
I have a DTS update operation that takes many hours to run. The
process is monthly, and for that process speed is not an issue; however,
the database server hosts multiple databases, some with applications
that do interactive queries. The DTS Update step brings down the speed
of interactive queries on the database being updated and all other
databases dramatically.
Is there any way to lower the priority of a DTS package operation so
that it does not impact interactive queries on that databases and other
databases running on the server?
Basically, can I run a DTS package "in the background" or with a very
low priority?Hi
You may want to read The Guru's Guide to SQL Server Architecture and
Internals by Ken Henderson ISDN 0-201-70047-6 which goes into depth on
thread scheduling. You may get some benefit by setting the MAXDOP query hint
on some of your statements. Highlighting what part of your process is slow
and why it is slow may help you to provide a more efficient solution.
You may also want to review the architecture of this process and either
split it into smaller independent chunks that can be run separately, or if
the data created by this process is read-only to the other processes, then
you may want to look at doing it offline and then swapping it in when the
process is complete e.g. having it all in a separate read-only database.
John
"John Bailo" <jabailo@.texeme.com> wrote in message
news:gsudneQq3ZlEYAzeRVn-uw@.speakeasy.net...
> Configuration:
> Windows 2000
> Sql Server 2000
> Quad CPU
>
> Problem:
> I have a DTS update operation that takes many hours to run. The process
> is monthly, and for that process speed is not an issue; however,
> the database server hosts multiple databases, some with applications that
> do interactive queries. The DTS Update step brings down the speed of
> interactive queries on the database being updated and all other databases
> dramatically.
> Is there any way to lower the priority of a DTS package operation so that
> it does not impact interactive queries on that databases and other
> databases running on the server?
> Basically, can I run a DTS package "in the background" or with a very low
> priority?
>
>

Rules based Configuration ER design

I'm looking at a head start in developing a "Rules based configuration
system." One like Dell Computer has where you build your PC. Are there any
database designs available for this type of thing?
Regards,
Gary Blakely
Hello Gary,
Since rules based system is too general and you may want to be more
specific.
A very simple sample, let's say you have 3 configuration parameters and 2
rules. 1 rule has some relation to all 3 parameters. The tables shall be
tbl-rule
ruleid rulename ..
1rule1
tbl-parameters
paramid paramname ..
1p1
tbl-rule-parm-relation
ruleid paramid value relation
1110>
125<
Some more complex situation might be based on knowledge management, expert
system etc which is beyond a simple E-R desgin.
Some issues may require a bit more in depth attention and may fall under
the umbrella of Advisory Services. Microsoft now offers short-term and
proactive assistance for specific planning, design, development or
assistance with installing, deploying, and general "how to" advice via
telephone. For more information:
http://support.microsoft.com/default.aspx?scid=fh;en-us;advisoryservice
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Rules based Configuration ER design

I'm looking at a head start in developing a "Rules based configuration
system." One like Dell Computer has where you build your PC. Are there any
database designs available for this type of thing?
Regards,
Gary BlakelyHello Gary,
Since rules based system is too general and you may want to be more
specific.
A very simple sample, let's say you have 3 configuration parameters and 2
rules. 1 rule has some relation to all 3 parameters. The tables shall be
tbl-rule
ruleid rulename ..
1 rule1
tbl-parameters
paramid paramname ..
1 p1
tbl-rule-parm-relation
ruleid paramid value relation
1 1 10 >
1 2 5 <
Some more complex situation might be based on knowledge management, expert
system etc which is beyond a simple E-R desgin.
Some issues may require a bit more in depth attention and may fall under
the umbrella of Advisory Services. Microsoft now offers short-term and
proactive assistance for specific planning, design, development or
assistance with installing, deploying, and general "how to" advice via
telephone. For more information:
http://support.microsoft.com/defaul...advisoryservice
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
<http://msdn.microsoft.com/subscript...ps/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscript...rt/default.aspx>.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.

Rules based Configuration ER design

I'm looking at a head start in developing a "Rules based configuration
system." One like Dell Computer has where you build your PC. Are there any
database designs available for this type of thing?
--
Regards,
Gary BlakelyHello Gary,
Since rules based system is too general and you may want to be more
specific.
A very simple sample, let's say you have 3 configuration parameters and 2
rules. 1 rule has some relation to all 3 parameters. The tables shall be
tbl-rule
ruleid rulename ..
1 rule1
tbl-parameters
paramid paramname ..
1 p1
tbl-rule-parm-relation
ruleid paramid value relation
1 1 10 >
1 2 5 <
Some more complex situation might be based on knowledge management, expert
system etc which is beyond a simple E-R desgin.
Some issues may require a bit more in depth attention and may fall under
the umbrella of Advisory Services. Microsoft now offers short-term and
proactive assistance for specific planning, design, development or
assistance with installing, deploying, and general "how to" advice via
telephone. For more information:
http://support.microsoft.com/default.aspx?scid=fh;en-us;advisoryservice
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

RSS Verifying DB version while upgrade

In Reporting Server2005 Configuration, while verifying database version and
trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40 does not
match your reporting server installation. you must upgrade your reporting
services database.
Please help, can not move forward.
Regards...Piku.This is a multi-part message in MIME format.
--=_NextPart_000_0047_01C6DC0C.4F605770
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
By the error message, it seems you're trying to install the RS 2005 =database to a database instance running SQL Server 2000. This seems to =be possible, but you have to do things differently during setup. This =article might help you in the right direction:
Using SQL 2000 for SSRS 2005 metadata storage
When setting up SQL Server Reporting Services 2005, can you use SQL 2000 =as the host for the reportserver database? Yes, you can (with an obvious =caveat in one scenario).

https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
Kaisa M. Lindahl Lervik
"Piku" <Piku@.discussions.microsoft.com> wrote in message =news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...
> In Reporting Server2005 Configuration, while verifying database =version and > trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40 =does not > match your reporting server installation. you must upgrade your =reporting > services database.
> > Please help, can not move forward.
> > Regards...Piku.
--=_NextPart_000_0047_01C6DC0C.4F605770
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

By the error message, it seems you're =trying to install the RS 2005 database to a database instance running SQL Server =2000. This seems to be possible, but you have to do things differently during =setup. This article might help you in the right direction:
Using SQL 2000 for SSRS 2005 =metadata storage
When setting up SQL Server Reporting Services 2005, can you =use SQL 2000 as the host for the reportserver database? Yes, you can (with an =obvious caveat in one scenario).
=https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.a=spx
Kaisa M. Lindahl Lervik
"Piku" wrote in message news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...> =In Reporting Server2005 Configuration, while verifying database version and > =trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40 does =not > match your reporting server installation. you must upgrade your =reporting > services database.> > Please help, can =not move forward.> > Regards...Piku.

---

--=_NextPart_000_0047_01C6DC0C.4F605770--|||I am installing rss 2005 on a SQL Server 2005 database, please help
"Kaisa M. Lindahl Lervik" wrote:
> By the error message, it seems you're trying to install the RS 2005 database to a database instance running SQL Server 2000. This seems to be possible, but you have to do things differently during setup. This article might help you in the right direction:
> Using SQL 2000 for SSRS 2005 metadata storage
>
> When setting up SQL Server Reporting Services 2005, can you use SQL 2000 as the host for the reportserver database? Yes, you can (with an obvious caveat in one scenario).
>
> https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
>
> Kaisa M. Lindahl Lervik
>
> "Piku" <Piku@.discussions.microsoft.com> wrote in message news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...
> > In Reporting Server2005 Configuration, while verifying database version and
> > trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40 does not
> > match your reporting server installation. you must upgrade your reporting
> > services database.
> >
> > Please help, can not move forward.
> >
> > Regards...Piku|||OK, seems like someone else had the same problem a few weeks ago. His
problem and solution:
I had the same problem.
It was caused by that I had installed reporting services after I had run
SP1 on SQL Server 2005.
Solved it by runing SQL Server 2005 SP1 again.
Hope this helps!
(At the end of this thread:)
http://groups.google.no/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/f94ed9da97f6cf0a/
Kaisa
"Piku" <Piku@.discussions.microsoft.com> wrote in message
news:3EDD6003-1110-4BC5-9887-793C480A97C9@.microsoft.com...
>I am installing rss 2005 on a SQL Server 2005 database, please help
> "Kaisa M. Lindahl Lervik" wrote:
>> By the error message, it seems you're trying to install the RS 2005
>> database to a database instance running SQL Server 2000. This seems to be
>> possible, but you have to do things differently during setup. This
>> article might help you in the right direction:
>> Using SQL 2000 for SSRS 2005 metadata storage
>>
>> When setting up SQL Server Reporting Services 2005, can you use SQL 2000
>> as the host for the reportserver database? Yes, you can (with an obvious
>> caveat in one scenario).
>>
>> https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
>>
>> Kaisa M. Lindahl Lervik
>>
>> "Piku" <Piku@.discussions.microsoft.com> wrote in message
>> news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...
>> > In Reporting Server2005 Configuration, while verifying database version
>> > and
>> > trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40 does
>> > not
>> > match your reporting server installation. you must upgrade your
>> > reporting
>> > services database.
>> >
>> > Please help, can not move forward.
>> >
>> > Regards...Piku|||Yes, My scenario is exactly same, sql2k5, sp1 and then rss2005...let me
install SQ1 again and see what happens, but have a doubt, SQL2005 instance
already has sp1 though. Thanks and appreciate your very quick response.
"Kaisa M. Lindahl Lervik" wrote:
> OK, seems like someone else had the same problem a few weeks ago. His
> problem and solution:
> I had the same problem.
> It was caused by that I had installed reporting services after I had run
> SP1 on SQL Server 2005.
> Solved it by runing SQL Server 2005 SP1 again.
>
> Hope this helps!
> (At the end of this thread:)
> http://groups.google.no/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/f94ed9da97f6cf0a/
> Kaisa
> "Piku" <Piku@.discussions.microsoft.com> wrote in message
> news:3EDD6003-1110-4BC5-9887-793C480A97C9@.microsoft.com...
> >I am installing rss 2005 on a SQL Server 2005 database, please help
> >
> > "Kaisa M. Lindahl Lervik" wrote:
> >
> >> By the error message, it seems you're trying to install the RS 2005
> >> database to a database instance running SQL Server 2000. This seems to be
> >> possible, but you have to do things differently during setup. This
> >> article might help you in the right direction:
> >> Using SQL 2000 for SSRS 2005 metadata storage
> >>
> >>
> >> When setting up SQL Server Reporting Services 2005, can you use SQL 2000
> >> as the host for the reportserver database? Yes, you can (with an obvious
> >> caveat in one scenario).
> >>
> >>
> >>
> >> https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
> >>
> >>
> >> Kaisa M. Lindahl Lervik
> >>
> >>
> >> "Piku" <Piku@.discussions.microsoft.com> wrote in message
> >> news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...
> >> > In Reporting Server2005 Configuration, while verifying database version
> >> > and
> >> > trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40 does
> >> > not
> >> > match your reporting server installation. you must upgrade your
> >> > reporting
> >> > services database.
> >> >
> >> > Please help, can not move forward.
> >> >
> >> > Regards...Piku
>
>|||Actually my BUILD is 2153, which is one hotfix more than sp1
"Piku" wrote:
> Yes, My scenario is exactly same, sql2k5, sp1 and then rss2005...let me
> install SQ1 again and see what happens, but have a doubt, SQL2005 instance
> already has sp1 though. Thanks and appreciate your very quick response.
> "Kaisa M. Lindahl Lervik" wrote:
> > OK, seems like someone else had the same problem a few weeks ago. His
> > problem and solution:
> >
> > I had the same problem.
> > It was caused by that I had installed reporting services after I had run
> > SP1 on SQL Server 2005.
> >
> > Solved it by runing SQL Server 2005 SP1 again.
> >
> >
> > Hope this helps!
> >
> > (At the end of this thread:)
> > http://groups.google.no/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/f94ed9da97f6cf0a/
> >
> > Kaisa
> >
> > "Piku" <Piku@.discussions.microsoft.com> wrote in message
> > news:3EDD6003-1110-4BC5-9887-793C480A97C9@.microsoft.com...
> > >I am installing rss 2005 on a SQL Server 2005 database, please help
> > >
> > > "Kaisa M. Lindahl Lervik" wrote:
> > >
> > >> By the error message, it seems you're trying to install the RS 2005
> > >> database to a database instance running SQL Server 2000. This seems to be
> > >> possible, but you have to do things differently during setup. This
> > >> article might help you in the right direction:
> > >> Using SQL 2000 for SSRS 2005 metadata storage
> > >>
> > >>
> > >> When setting up SQL Server Reporting Services 2005, can you use SQL 2000
> > >> as the host for the reportserver database? Yes, you can (with an obvious
> > >> caveat in one scenario).
> > >>
> > >>
> > >>
> > >> https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
> > >>
> > >>
> > >> Kaisa M. Lindahl Lervik
> > >>
> > >>
> > >> "Piku" <Piku@.discussions.microsoft.com> wrote in message
> > >> news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...
> > >> > In Reporting Server2005 Configuration, while verifying database version
> > >> > and
> > >> > trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40 does
> > >> > not
> > >> > match your reporting server installation. you must upgrade your
> > >> > reporting
> > >> > services database.
> > >> >
> > >> > Please help, can not move forward.
> > >> >
> > >> > Regards...Piku
> >
> >
> >|||OK, don't know what to do about that. :(
Kaisa
"Piku" <Piku@.discussions.microsoft.com> wrote in message
news:EFB33C14-C348-4457-A3FA-EEAD02FD932D@.microsoft.com...
> Actually my BUILD is 2153, which is one hotfix more than sp1
> "Piku" wrote:
>> Yes, My scenario is exactly same, sql2k5, sp1 and then rss2005...let me
>> install SQ1 again and see what happens, but have a doubt, SQL2005
>> instance
>> already has sp1 though. Thanks and appreciate your very quick response.
>> "Kaisa M. Lindahl Lervik" wrote:
>> > OK, seems like someone else had the same problem a few weeks ago. His
>> > problem and solution:
>> >
>> > I had the same problem.
>> > It was caused by that I had installed reporting services after I had
>> > run
>> > SP1 on SQL Server 2005.
>> >
>> > Solved it by runing SQL Server 2005 SP1 again.
>> >
>> >
>> > Hope this helps!
>> >
>> > (At the end of this thread:)
>> > http://groups.google.no/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/f94ed9da97f6cf0a/
>> >
>> > Kaisa
>> >
>> > "Piku" <Piku@.discussions.microsoft.com> wrote in message
>> > news:3EDD6003-1110-4BC5-9887-793C480A97C9@.microsoft.com...
>> > >I am installing rss 2005 on a SQL Server 2005 database, please help
>> > >
>> > > "Kaisa M. Lindahl Lervik" wrote:
>> > >
>> > >> By the error message, it seems you're trying to install the RS 2005
>> > >> database to a database instance running SQL Server 2000. This seems
>> > >> to be
>> > >> possible, but you have to do things differently during setup. This
>> > >> article might help you in the right direction:
>> > >> Using SQL 2000 for SSRS 2005 metadata storage
>> > >>
>> > >>
>> > >> When setting up SQL Server Reporting Services 2005, can you use SQL
>> > >> 2000
>> > >> as the host for the reportserver database? Yes, you can (with an
>> > >> obvious
>> > >> caveat in one scenario).
>> > >>
>> > >>
>> > >>
>> > >> https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
>> > >>
>> > >>
>> > >> Kaisa M. Lindahl Lervik
>> > >>
>> > >>
>> > >> "Piku" <Piku@.discussions.microsoft.com> wrote in message
>> > >> news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...
>> > >> > In Reporting Server2005 Configuration, while verifying database
>> > >> > version
>> > >> > and
>> > >> > trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40
>> > >> > does
>> > >> > not
>> > >> > match your reporting server installation. you must upgrade your
>> > >> > reporting
>> > >> > services database.
>> > >> >
>> > >> > Please help, can not move forward.
>> > >> >
>> > >> > Regards...Piku
>> >
>> >
>> >|||I reinstall the sp1 and it worked, doesn,t make any sense as I was already
having the higher build, anyway THANKS.
Now everything thing looks good BUT when I am trying to connect to the
report server by http://servername/reportserver OR
http://servername/reports getting Msg : " The feature: "Scale-out deployment"
is not supported in this edition of Reporting Services.
(rsOperationNotSupported) (rsRPCError"
I have installed One report server one sql server standard edition all on
one machine, then why am I getting this msg, I know only Dev and Entp Edition
supports Scale-Out deployment how to resolve it, please help.
Regards.
"Kaisa M. Lindahl Lervik" wrote:
> OK, don't know what to do about that. :(
> Kaisa
> "Piku" <Piku@.discussions.microsoft.com> wrote in message
> news:EFB33C14-C348-4457-A3FA-EEAD02FD932D@.microsoft.com...
> > Actually my BUILD is 2153, which is one hotfix more than sp1
> >
> > "Piku" wrote:
> >
> >> Yes, My scenario is exactly same, sql2k5, sp1 and then rss2005...let me
> >> install SQ1 again and see what happens, but have a doubt, SQL2005
> >> instance
> >> already has sp1 though. Thanks and appreciate your very quick response.
> >>
> >> "Kaisa M. Lindahl Lervik" wrote:
> >>
> >> > OK, seems like someone else had the same problem a few weeks ago. His
> >> > problem and solution:
> >> >
> >> > I had the same problem.
> >> > It was caused by that I had installed reporting services after I had
> >> > run
> >> > SP1 on SQL Server 2005.
> >> >
> >> > Solved it by runing SQL Server 2005 SP1 again.
> >> >
> >> >
> >> > Hope this helps!
> >> >
> >> > (At the end of this thread:)
> >> > http://groups.google.no/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/f94ed9da97f6cf0a/
> >> >
> >> > Kaisa
> >> >
> >> > "Piku" <Piku@.discussions.microsoft.com> wrote in message
> >> > news:3EDD6003-1110-4BC5-9887-793C480A97C9@.microsoft.com...
> >> > >I am installing rss 2005 on a SQL Server 2005 database, please help
> >> > >
> >> > > "Kaisa M. Lindahl Lervik" wrote:
> >> > >
> >> > >> By the error message, it seems you're trying to install the RS 2005
> >> > >> database to a database instance running SQL Server 2000. This seems
> >> > >> to be
> >> > >> possible, but you have to do things differently during setup. This
> >> > >> article might help you in the right direction:
> >> > >> Using SQL 2000 for SSRS 2005 metadata storage
> >> > >>
> >> > >>
> >> > >> When setting up SQL Server Reporting Services 2005, can you use SQL
> >> > >> 2000
> >> > >> as the host for the reportserver database? Yes, you can (with an
> >> > >> obvious
> >> > >> caveat in one scenario).
> >> > >>
> >> > >>
> >> > >>
> >> > >> https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
> >> > >>
> >> > >>
> >> > >> Kaisa M. Lindahl Lervik
> >> > >>
> >> > >>
> >> > >> "Piku" <Piku@.discussions.microsoft.com> wrote in message
> >> > >> news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...
> >> > >> > In Reporting Server2005 Configuration, while verifying database
> >> > >> > version
> >> > >> > and
> >> > >> > trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40
> >> > >> > does
> >> > >> > not
> >> > >> > match your reporting server installation. you must upgrade your
> >> > >> > reporting
> >> > >> > services database.
> >> > >> >
> >> > >> > Please help, can not move forward.
> >> > >> >
> >> > >> > Regards...Piku
> >> >
> >> >
> >> >
>
>|||Same problem here. I am trying to solve this issue since DAYS on the Italian
localized SQL 2005 Workgroup Edition of SQL 2005 on a SBS 2003 R2 PDC. Fresh
install, not upgrade.
I'm trying to install Reporting Services on the default db instance. The db
engine is now at 9.0.2153.
On the Report Server Configuration tool I'm on the "database setting" tab
(I'm translating everything from Italian, so labels could be literally
different).
I can connect to the server. I push the "New..." button. I create a db on
the default SQL instance. Credentials: Current user (running in the
Administrator context). DB Name: ReportServer. Language: either English or
Italian.
The DB gets built. I push the "Apply" button and a "Update the db"? message
appears. I click "OK". The status shows:
GREEN: Verification of the db edition: completed.
YELLOW TRIANGLE: Verification of the db version: "The DATABASE VERSION
C.0.8.40 does not match your reporting server installation. You must upgrade
your reporting services db".
YELLOW TRIANGLE: Creating the update script for the DB version C.0.8.40: No
update script available for this version of the db!
"Piku" wrote:
> I reinstall the sp1 and it worked, doesn,t make any sense as I was already
> having the higher build, anyway THANKS.
> Now everything thing looks good BUT when I am trying to connect to the
> report server by http://servername/reportserver OR
> http://servername/reports getting Msg : " The feature: "Scale-out deployment"
> is not supported in this edition of Reporting Services.
> (rsOperationNotSupported) (rsRPCError"
> I have installed One report server one sql server standard edition all on
> one machine, then why am I getting this msg, I know only Dev and Entp Edition
> supports Scale-Out deployment how to resolve it, please help.
> Regards.
> "Kaisa M. Lindahl Lervik" wrote:
> > OK, don't know what to do about that. :(
> >
> > Kaisa
> >
> > "Piku" <Piku@.discussions.microsoft.com> wrote in message
> > news:EFB33C14-C348-4457-A3FA-EEAD02FD932D@.microsoft.com...
> > > Actually my BUILD is 2153, which is one hotfix more than sp1
> > >
> > > "Piku" wrote:
> > >
> > >> Yes, My scenario is exactly same, sql2k5, sp1 and then rss2005...let me
> > >> install SQ1 again and see what happens, but have a doubt, SQL2005
> > >> instance
> > >> already has sp1 though. Thanks and appreciate your very quick response.
> > >>
> > >> "Kaisa M. Lindahl Lervik" wrote:
> > >>
> > >> > OK, seems like someone else had the same problem a few weeks ago. His
> > >> > problem and solution:
> > >> >
> > >> > I had the same problem.
> > >> > It was caused by that I had installed reporting services after I had
> > >> > run
> > >> > SP1 on SQL Server 2005.
> > >> >
> > >> > Solved it by runing SQL Server 2005 SP1 again.
> > >> >
> > >> >
> > >> > Hope this helps!
> > >> >
> > >> > (At the end of this thread:)
> > >> > http://groups.google.no/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/f94ed9da97f6cf0a/
> > >> >
> > >> > Kaisa
> > >> >
> > >> > "Piku" <Piku@.discussions.microsoft.com> wrote in message
> > >> > news:3EDD6003-1110-4BC5-9887-793C480A97C9@.microsoft.com...
> > >> > >I am installing rss 2005 on a SQL Server 2005 database, please help
> > >> > >
> > >> > > "Kaisa M. Lindahl Lervik" wrote:
> > >> > >
> > >> > >> By the error message, it seems you're trying to install the RS 2005
> > >> > >> database to a database instance running SQL Server 2000. This seems
> > >> > >> to be
> > >> > >> possible, but you have to do things differently during setup. This
> > >> > >> article might help you in the right direction:
> > >> > >> Using SQL 2000 for SSRS 2005 metadata storage
> > >> > >>
> > >> > >>
> > >> > >> When setting up SQL Server Reporting Services 2005, can you use SQL
> > >> > >> 2000
> > >> > >> as the host for the reportserver database? Yes, you can (with an
> > >> > >> obvious
> > >> > >> caveat in one scenario).
> > >> > >>
> > >> > >>
> > >> > >>
> > >> > >> https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
> > >> > >>
> > >> > >>
> > >> > >> Kaisa M. Lindahl Lervik
> > >> > >>
> > >> > >>
> > >> > >> "Piku" <Piku@.discussions.microsoft.com> wrote in message
> > >> > >> news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...
> > >> > >> > In Reporting Server2005 Configuration, while verifying database
> > >> > >> > version
> > >> > >> > and
> > >> > >> > trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40
> > >> > >> > does
> > >> > >> > not
> > >> > >> > match your reporting server installation. you must upgrade your
> > >> > >> > reporting
> > >> > >> > services database.
> > >> > >> >
> > >> > >> > Please help, can not move forward.
> > >> > >> >
> > >> > >> > Regards...Piku
> > >> >
> > >> >
> > >> >
> >
> >
> >|||I forgot to say: when I run the SQL 2005 SP1 install, it works for everything
except the reporting services. That gives "error" and stayis on SP0!
"davideC" wrote:
> Same problem here. I am trying to solve this issue since DAYS on the Italian
> localized SQL 2005 Workgroup Edition of SQL 2005 on a SBS 2003 R2 PDC. Fresh
> install, not upgrade.
> I'm trying to install Reporting Services on the default db instance. The db
> engine is now at 9.0.2153.
> On the Report Server Configuration tool I'm on the "database setting" tab
> (I'm translating everything from Italian, so labels could be literally
> different).
> I can connect to the server. I push the "New..." button. I create a db on
> the default SQL instance. Credentials: Current user (running in the
> Administrator context). DB Name: ReportServer. Language: either English or
> Italian.
> The DB gets built. I push the "Apply" button and a "Update the db"? message
> appears. I click "OK". The status shows:
> GREEN: Verification of the db edition: completed.
> YELLOW TRIANGLE: Verification of the db version: "The DATABASE VERSION
> C.0.8.40 does not match your reporting server installation. You must upgrade
> your reporting services db".
> YELLOW TRIANGLE: Creating the update script for the DB version C.0.8.40: No
> update script available for this version of the db!
>
> "Piku" wrote:
> > I reinstall the sp1 and it worked, doesn,t make any sense as I was already
> > having the higher build, anyway THANKS.
> >
> > Now everything thing looks good BUT when I am trying to connect to the
> > report server by http://servername/reportserver OR
> > http://servername/reports getting Msg : " The feature: "Scale-out deployment"
> > is not supported in this edition of Reporting Services.
> > (rsOperationNotSupported) (rsRPCError"
> >
> > I have installed One report server one sql server standard edition all on
> > one machine, then why am I getting this msg, I know only Dev and Entp Edition
> > supports Scale-Out deployment how to resolve it, please help.
> >
> > Regards.
> >
> > "Kaisa M. Lindahl Lervik" wrote:
> >
> > > OK, don't know what to do about that. :(
> > >
> > > Kaisa
> > >
> > > "Piku" <Piku@.discussions.microsoft.com> wrote in message
> > > news:EFB33C14-C348-4457-A3FA-EEAD02FD932D@.microsoft.com...
> > > > Actually my BUILD is 2153, which is one hotfix more than sp1
> > > >
> > > > "Piku" wrote:
> > > >
> > > >> Yes, My scenario is exactly same, sql2k5, sp1 and then rss2005...let me
> > > >> install SQ1 again and see what happens, but have a doubt, SQL2005
> > > >> instance
> > > >> already has sp1 though. Thanks and appreciate your very quick response.
> > > >>
> > > >> "Kaisa M. Lindahl Lervik" wrote:
> > > >>
> > > >> > OK, seems like someone else had the same problem a few weeks ago. His
> > > >> > problem and solution:
> > > >> >
> > > >> > I had the same problem.
> > > >> > It was caused by that I had installed reporting services after I had
> > > >> > run
> > > >> > SP1 on SQL Server 2005.
> > > >> >
> > > >> > Solved it by runing SQL Server 2005 SP1 again.
> > > >> >
> > > >> >
> > > >> > Hope this helps!
> > > >> >
> > > >> > (At the end of this thread:)
> > > >> > http://groups.google.no/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/f94ed9da97f6cf0a/
> > > >> >
> > > >> > Kaisa
> > > >> >
> > > >> > "Piku" <Piku@.discussions.microsoft.com> wrote in message
> > > >> > news:3EDD6003-1110-4BC5-9887-793C480A97C9@.microsoft.com...
> > > >> > >I am installing rss 2005 on a SQL Server 2005 database, please help
> > > >> > >
> > > >> > > "Kaisa M. Lindahl Lervik" wrote:
> > > >> > >
> > > >> > >> By the error message, it seems you're trying to install the RS 2005
> > > >> > >> database to a database instance running SQL Server 2000. This seems
> > > >> > >> to be
> > > >> > >> possible, but you have to do things differently during setup. This
> > > >> > >> article might help you in the right direction:
> > > >> > >> Using SQL 2000 for SSRS 2005 metadata storage
> > > >> > >>
> > > >> > >>
> > > >> > >> When setting up SQL Server Reporting Services 2005, can you use SQL
> > > >> > >> 2000
> > > >> > >> as the host for the reportserver database? Yes, you can (with an
> > > >> > >> obvious
> > > >> > >> caveat in one scenario).
> > > >> > >>
> > > >> > >>
> > > >> > >>
> > > >> > >> https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
> > > >> > >>
> > > >> > >>
> > > >> > >> Kaisa M. Lindahl Lervik
> > > >> > >>
> > > >> > >>
> > > >> > >> "Piku" <Piku@.discussions.microsoft.com> wrote in message
> > > >> > >> news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...
> > > >> > >> > In Reporting Server2005 Configuration, while verifying database
> > > >> > >> > version
> > > >> > >> > and
> > > >> > >> > trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40
> > > >> > >> > does
> > > >> > >> > not
> > > >> > >> > match your reporting server installation. you must upgrade your
> > > >> > >> > reporting
> > > >> > >> > services database.
> > > >> > >> >
> > > >> > >> > Please help, can not move forward.
> > > >> > >> >
> > > >> > >> > Regards...Piku
> > > >> >
> > > >> >
> > > >> >
> > >
> > >
> > >