Showing posts with label server2005. Show all posts
Showing posts with label server2005. Show all posts

Wednesday, March 21, 2012

Run SSIS in automatically

hi

This is Elangovan. How to automatically run the SSIS (SQl SERVER2005 )

plz help me

bye

elangovan

Could you be more specific? Are you taking about a SSIS package?|||

hi

i want to retrieve data from more than mutliple table.

i am using Stored procedure to do this but i want to do same thing in SSIS program-(SQL SERVER 2005)

bye

elangovan

|||

Have you been through the SSIS tutorials?

What you are asking is the equivalent of "How do I create a program in C#?" We need more specific detail on what you want to accomplish in order to help you.

Saturday, February 25, 2012

Rules and defaults

Hi,

Can any one provide me information on creating rules and defaults in SQL Server2005, when i tried right clicking rules or defaults in management studio instead of new option i'am getting only refresh option.

This feature was working smoothly in sql2000.....I'am trying this on Microsoft SQL Server2005 Standard Edition.

thanks in advance

Mat

Rules and defaults are deprecated in 2005. You should now use constraints, which you define in the table designer. Rules and defaults are still supported, but you have to create them manually by writing the code yourself. You cannot create them in Management Studio because you should not be using them any more.

This comes from the 2000 documentation
"Rules are a backward-compatibility feature that perform some of the same functions as CHECK constraints. CHECK constraints are the preferred, standard way to restrict the values in a column."
"Defaults, a backward compatibility feature, perform some of the same functions as default definitions created using the DEFAULT keyword of ALTER or CREATE TABLE statements. Default definitions are the preferred, standard way to restrict column data because the definition is stored with the table and automatically dropped when the table is dropped."

And this from the 2005 documentation
"CREATE RULE will be removed in a future version of Microsoft SQL Server. Avoid using CREATE RULE in new development work, and plan to modify applications that currently use it. We recommend that you use check constraints instead."
"CREATE DEFAULT will be removed in a future version of Microsoft SQL Server. Avoid using CREATE DEFAULT in new development work, and plan to modify applications that currently use it. Instead, use default definitions created using the DEFAULT keyword of ALTER TABLE or CREATE TABLE."

Tuesday, February 21, 2012

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
> > > >> >
> > > >> >
> > > >> >
> > >
> > >
> > >