Running 2000 and 2005 Sql Server on 1 machine

I'm currently running SQL Server 2000 and 2005 on one machine at least I
think I am. I have Enterprise Manager and all the other components for 2000
on my laptop. I also loaded SQL Server 2005 with the .NET application from a
CD that I got from a Microsoft convention a long time ago. Basically, my
problem is when I click on the SQL SERVER 2005 Management Studio and run a
SELECT @.@.VERSION query it shows me that 2000 is installed. I created a
database in 2005 and the mdf and ldf files are stored in the C:\...\Microsoft
SQL Server\MSSQL.1\BIN directory seperate from the 2000 bin directory. What
am I doing wrong? Can 2000 and 2005 not run on the same box? This is
preventing me from changing the database compatiblity level to 90 because it
doesn't show up. Can anyone help? or suggest what I should do?
-- TCI guess you are connecting to your SQL Server 2000 Instance using SQL Server
Management Studio. That's why it tells you it's 2000 when you run SELECT
@.@.VERSION.
Go to SQL Server Configuration Manager and see if your SQL Server 2005
instance is running. And connect to that instance using SSMS. So, you'll be
able to create databases compatibility level 90.
--
Ekrem Ã?nsoy
"Terrance" <Terrance@.discussions.microsoft.com> wrote in message
news:8EC78FDB-283B-4391-A9D9-6BEB46BC7F9C@.microsoft.com...
> I'm currently running SQL Server 2000 and 2005 on one machine at least I
> think I am. I have Enterprise Manager and all the other components for
> 2000
> on my laptop. I also loaded SQL Server 2005 with the .NET application from
> a
> CD that I got from a Microsoft convention a long time ago. Basically, my
> problem is when I click on the SQL SERVER 2005 Management Studio and run a
> SELECT @.@.VERSION query it shows me that 2000 is installed. I created a
> database in 2005 and the mdf and ldf files are stored in the
> C:\...\Microsoft
> SQL Server\MSSQL.1\BIN directory seperate from the 2000 bin directory.
> What
> am I doing wrong? Can 2000 and 2005 not run on the same box? This is
> preventing me from changing the database compatiblity level to 90 because
> it
> doesn't show up. Can anyone help? or suggest what I should do?
> -- TC|||Hi Terrance
Along with the other posts!! The second instance (i.e. SQL 2005) would be
installed as a named instance, therefore you should know what instance has
been connected to.
I would not expect the SQL Server 2000 instance to know if the
...\MSSQL.1\BIN directory as the MSSQL.1 directory naming was introduced in
SQL 2005. Even for the SQL 2005 instance you would expect the database files
to be put into ...\MSSQL.1\MSSQL\DATA How are you creating this database?
For a
SQL 2005 instance you can right click the instance in SSMS and choose
properties then the Database Settings will tell you the default data and log
directories, a CREATE DATABASE in a query window without specifying any of
the file names will use these directories.
To see or set the databases compatability level use sp_dbcmptlevel
EXEC sp_dbcmptlevel AdventureWorks;
GO
EXEC sp_dbcmptlevel AdventureWorks, 90;
GO
It is best to change compatibility while no users are connected to the
database!
John
"Terrance" wrote:
> I'm currently running SQL Server 2000 and 2005 on one machine at least I
> think I am. I have Enterprise Manager and all the other components for 2000
> on my laptop. I also loaded SQL Server 2005 with the .NET application from a
> CD that I got from a Microsoft convention a long time ago. Basically, my
> problem is when I click on the SQL SERVER 2005 Management Studio and run a
> SELECT @.@.VERSION query it shows me that 2000 is installed. I created a
> database in 2005 and the mdf and ldf files are stored in the C:\...\Microsoft
> SQL Server\MSSQL.1\BIN directory seperate from the 2000 bin directory. What
> am I doing wrong? Can 2000 and 2005 not run on the same box? This is
> preventing me from changing the database compatiblity level to 90 because it
> doesn't show up. Can anyone help? or suggest what I should do?
> -- TC

Running 2000 and 2005 Sql Server on 1 machine

I'm currently running SQL Server 2000 and 2005 on one machine at least I
think I am. I have Enterprise Manager and all the other components for 2000
on my laptop. I also loaded SQL Server 2005 with the .NET application from a
CD that I got from a Microsoft convention a long time ago. Basically, my
problem is when I click on the SQL SERVER 2005 Management Studio and run a
SELECT @.@.VERSION query it shows me that 2000 is installed. I created a
database in 2005 and the mdf and ldf files are stored in the C:\...\Microsoft
SQL Server\MSSQL.1\BIN directory seperate from the 2000 bin directory. What
am I doing wrong? Can 2000 and 2005 not run on the same box? This is
preventing me from changing the database compatiblity level to 90 because it
doesn't show up. Can anyone help? or suggest what I should do?
-- TC
I guess you are connecting to your SQL Server 2000 Instance using SQL Server
Management Studio. That's why it tells you it's 2000 when you run SELECT
@.@.VERSION.
Go to SQL Server Configuration Manager and see if your SQL Server 2005
instance is running. And connect to that instance using SSMS. So, you'll be
able to create databases compatibility level 90.
Ekrem ?nsoy
"Terrance" <Terrance@.discussions.microsoft.com> wrote in message
news:8EC78FDB-283B-4391-A9D9-6BEB46BC7F9C@.microsoft.com...
> I'm currently running SQL Server 2000 and 2005 on one machine at least I
> think I am. I have Enterprise Manager and all the other components for
> 2000
> on my laptop. I also loaded SQL Server 2005 with the .NET application from
> a
> CD that I got from a Microsoft convention a long time ago. Basically, my
> problem is when I click on the SQL SERVER 2005 Management Studio and run a
> SELECT @.@.VERSION query it shows me that 2000 is installed. I created a
> database in 2005 and the mdf and ldf files are stored in the
> C:\...\Microsoft
> SQL Server\MSSQL.1\BIN directory seperate from the 2000 bin directory.
> What
> am I doing wrong? Can 2000 and 2005 not run on the same box? This is
> preventing me from changing the database compatiblity level to 90 because
> it
> doesn't show up. Can anyone help? or suggest what I should do?
> -- TC
|||Hi Terrance
Along with the other posts!! The second instance (i.e. SQL 2005) would be
installed as a named instance, therefore you should know what instance has
been connected to.
I would not expect the SQL Server 2000 instance to know if the
...\MSSQL.1\BIN directory as the MSSQL.1 directory naming was introduced in
SQL 2005. Even for the SQL 2005 instance you would expect the database files
to be put into ...\MSSQL.1\MSSQL\DATA How are you creating this database?
For a
SQL 2005 instance you can right click the instance in SSMS and choose
properties then the Database Settings will tell you the default data and log
directories, a CREATE DATABASE in a query window without specifying any of
the file names will use these directories.
To see or set the databases compatability level use sp_dbcmptlevel
EXEC sp_dbcmptlevel AdventureWorks;
GO
EXEC sp_dbcmptlevel AdventureWorks, 90;
GO
It is best to change compatibility while no users are connected to the
database!
John
"Terrance" wrote:

> I'm currently running SQL Server 2000 and 2005 on one machine at least I
> think I am. I have Enterprise Manager and all the other components for 2000
> on my laptop. I also loaded SQL Server 2005 with the .NET application from a
> CD that I got from a Microsoft convention a long time ago. Basically, my
> problem is when I click on the SQL SERVER 2005 Management Studio and run a
> SELECT @.@.VERSION query it shows me that 2000 is installed. I created a
> database in 2005 and the mdf and ldf files are stored in the C:\...\Microsoft
> SQL Server\MSSQL.1\BIN directory seperate from the 2000 bin directory. What
> am I doing wrong? Can 2000 and 2005 not run on the same box? This is
> preventing me from changing the database compatiblity level to 90 because it
> doesn't show up. Can anyone help? or suggest what I should do?
> -- TC

Running 2000 and 2005 Sql Server on 1 machine

I'm currently running SQL Server 2000 and 2005 on one machine at least I
think I am. I have Enterprise Manager and all the other components for 2000
on my laptop. I also loaded SQL Server 2005 with the .NET application from a
CD that I got from a Microsoft convention a long time ago. Basically, my
problem is when I click on the SQL SERVER 2005 Management Studio and run a
SELECT @.@.VERSION query it shows me that 2000 is installed. I created a
database in 2005 and the mdf and ldf files are stored in the C:\...\Microsof
t
SQL Server\MSSQL.1\BIN directory seperate from the 2000 bin directory. What
am I doing wrong? Can 2000 and 2005 not run on the same box? This is
preventing me from changing the database compatiblity level to 90 because it
doesn't show up. Can anyone help? or suggest what I should do?
-- TCI guess you are connecting to your SQL Server 2000 Instance using SQL Server
Management Studio. That's why it tells you it's 2000 when you run SELECT
@.@.VERSION.
Go to SQL Server Configuration Manager and see if your SQL Server 2005
instance is running. And connect to that instance using SSMS. So, you'll be
able to create databases compatibility level 90.
Ekrem ?nsoy
"Terrance" <Terrance@.discussions.microsoft.com> wrote in message
news:8EC78FDB-283B-4391-A9D9-6BEB46BC7F9C@.microsoft.com...
> I'm currently running SQL Server 2000 and 2005 on one machine at least I
> think I am. I have Enterprise Manager and all the other components for
> 2000
> on my laptop. I also loaded SQL Server 2005 with the .NET application from
> a
> CD that I got from a Microsoft convention a long time ago. Basically, my
> problem is when I click on the SQL SERVER 2005 Management Studio and run a
> SELECT @.@.VERSION query it shows me that 2000 is installed. I created a
> database in 2005 and the mdf and ldf files are stored in the
> C:\...\Microsoft
> SQL Server\MSSQL.1\BIN directory seperate from the 2000 bin directory.
> What
> am I doing wrong? Can 2000 and 2005 not run on the same box? This is
> preventing me from changing the database compatiblity level to 90 because
> it
> doesn't show up. Can anyone help? or suggest what I should do?
> -- TC|||Hi Terrance
Along with the other posts!! The second instance (i.e. SQL 2005) would be
installed as a named instance, therefore you should know what instance has
been connected to.
I would not expect the SQL Server 2000 instance to know if the
...\MSSQL.1\BIN directory as the MSSQL.1 directory naming was introduced in
SQL 2005. Even for the SQL 2005 instance you would expect the database files
to be put into ...\MSSQL.1\MSSQL\DATA How are you creating this database?
For a
SQL 2005 instance you can right click the instance in SSMS and choose
properties then the Database Settings will tell you the default data and log
directories, a CREATE DATABASE in a query window without specifying any of
the file names will use these directories.
To see or set the databases compatability level use sp_dbcmptlevel
EXEC sp_dbcmptlevel AdventureWorks;
GO
EXEC sp_dbcmptlevel AdventureWorks, 90;
GO
It is best to change compatibility while no users are connected to the
database!
John
"Terrance" wrote:

> I'm currently running SQL Server 2000 and 2005 on one machine at least I
> think I am. I have Enterprise Manager and all the other components for 200
0
> on my laptop. I also loaded SQL Server 2005 with the .NET application from
a
> CD that I got from a Microsoft convention a long time ago. Basically, my
> problem is when I click on the SQL SERVER 2005 Management Studio and run a
> SELECT @.@.VERSION query it shows me that 2000 is installed. I created a
> database in 2005 and the mdf and ldf files are stored in the C:\...\Micros
oft
> SQL Server\MSSQL.1\BIN directory seperate from the 2000 bin directory. Wha
t
> am I doing wrong? Can 2000 and 2005 not run on the same box? This is
> preventing me from changing the database compatiblity level to 90 because
it
> doesn't show up. Can anyone help? or suggest what I should do?
> -- TCsql

run sp1 where??

i have 3 machines running report service components:
1 - a sql server
2 - a web server
3 - a development machine with vsnet2003
do i run sp1 on all 3?
please help
dushan bilbijaInstall it everywhere you installed Reporting Services.
I have IIS (and Reporting Services) installed on my SQL Server, so the only
location I had to install the SP was on the combination database/web server
and on my machine to update the client piece (that runs within VS.NET 2003).
--
Keith
"Dushan Bilbija" <dbilbija@.msn.com> wrote in message
news:e%23rFxdTXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> i have 3 machines running report service components:
> 1 - a sql server
> 2 - a web server
> 3 - a development machine with vsnet2003
> do i run sp1 on all 3?
> please help
> dushan bilbija
>|||On 2 and 3.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dushan Bilbija" <dbilbija@.msn.com> wrote in message
news:e#rFxdTXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> i have 3 machines running report service components:
> 1 - a sql server
> 2 - a web server
> 3 - a development machine with vsnet2003
> do i run sp1 on all 3?
> please help
> dushan bilbija
>|||Tudor, doesn't SP1 also update the server as well?
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
news:uKCfRmTXEHA.384@.TK2MSFTNGP10.phx.gbl...
> On 2 and 3.
> --
> Tudor Trufinescu
> Dev Lead
> Sql Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Dushan Bilbija" <dbilbija@.msn.com> wrote in message
> news:e#rFxdTXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> > i have 3 machines running report service components:
> >
> > 1 - a sql server
> > 2 - a web server
> > 3 - a development machine with vsnet2003
> >
> > do i run sp1 on all 3?
> >
> > please help
> >
> > dushan bilbija
> >
> >
>|||I did a diff on my development SQL Server box that is running both the
reporting service and database and my production (pre SP1) ReportServer db
and there are large differences between the two. That makes me believe that
I will need to run the SP on the production database server as well as the
production Reporting Service, unless running it on the production Reporting
Service will pass the database updates automatically to its database server.
Worst thing that happens is I run the SP on the production Reporting
Service, do my diff, notice the changes haven't propogated as expected, run
the SP on the SQL Server db.
Thx, Joel
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:uKoXakWXEHA.3564@.TK2MSFTNGP11.phx.gbl...
> Tudor, doesn't SP1 also update the server as well?
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
> "Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
> news:uKCfRmTXEHA.384@.TK2MSFTNGP10.phx.gbl...
> > On 2 and 3.
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Dushan Bilbija" <dbilbija@.msn.com> wrote in message
> > news:e#rFxdTXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> > > i have 3 machines running report service components:
> > >
> > > 1 - a sql server
> > > 2 - a web server
> > > 3 - a development machine with vsnet2003
> > >
> > > do i run sp1 on all 3?
> > >
> > > please help
> > >
> > > dushan bilbija
> > >
> > >
> >
> >
>|||You don't need to run SP1 setup on the SQL Server box - if that's separate
from the report server box.
When you run SP1 setup on the RS box it will update stored procs and tables
on the SQL Server box.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:uKoXakWXEHA.3564@.TK2MSFTNGP11.phx.gbl...
> Tudor, doesn't SP1 also update the server as well?
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
> "Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
> news:uKCfRmTXEHA.384@.TK2MSFTNGP10.phx.gbl...
> > On 2 and 3.
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Dushan Bilbija" <dbilbija@.msn.com> wrote in message
> > news:e#rFxdTXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> > > i have 3 machines running report service components:
> > >
> > > 1 - a sql server
> > > 2 - a web server
> > > 3 - a development machine with vsnet2003
> > >
> > > do i run sp1 on all 3?
> > >
> > > please help
> > >
> > > dushan bilbija
> > >
> > >
> >
> >
>|||I don't think that there are any database related changes within Reporting
Services SP1.
--
Keith
"Mark Barker" <MarkBarker@.discussions.microsoft.com> wrote in message
news:9E97C141-6BFA-424F-A6C2-A5F6524FC824@.microsoft.com...
> Iâ've upgrade in a similar scenario (a 2 node NLB running Reporting
Services and a separate server running SQL Server). Reporting Services is
showing the appropriate version number (8.00.878.00) so all seems well on
the NLB.
> The only thing that makes me slightly nervous about the upgrade is the
fact that I didnâ't see any kind of â'upgrading database...â' dialog box, and I
have seen this dialog box where I have upgraded Reporting Services servers
that are running SQL Server and Reporting Services on the same server.
> Should I just forget about this nervousness and assume that the database
has successfully upgraded â' Is there any way to verify that the upgrade has
taken place on the SQL Server?
> Thanks,
> Mark
>
> "Tudor Trufinescu (MSFT)" wrote:
> > You don't need to run SP1 setup on the SQL Server box - if that's
separate
> > from the report server box.
> > When you run SP1 setup on the RS box it will update stored procs and
tables
> > on the SQL Server box.
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
> > news:uKoXakWXEHA.3564@.TK2MSFTNGP11.phx.gbl...
> > > Tudor, doesn't SP1 also update the server as well?
> > >
> > > --
> > > ____________________________________
> > > William (Bill) Vaughn
> > > Author, Mentor, Consultant
> > > Microsoft MVP
> > > www.betav.com
> > > Please reply only to the newsgroup so that others can benefit.
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > __________________________________
> > >
> > > "Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
> > > news:uKCfRmTXEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > > On 2 and 3.
> > > >
> > > > --
> > > > Tudor Trufinescu
> > > > Dev Lead
> > > > Sql Server Reporting Services
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > >
> > > >
> > > > "Dushan Bilbija" <dbilbija@.msn.com> wrote in message
> > > > news:e#rFxdTXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> > > > > i have 3 machines running report service components:
> > > > >
> > > > > 1 - a sql server
> > > > > 2 - a web server
> > > > > 3 - a development machine with vsnet2003
> > > > >
> > > > > do i run sp1 on all 3?
> > > > >
> > > > > please help
> > > > >
> > > > > dushan bilbija
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
> >|||The SP1 bits would only work on the SP1 schema, so your upgrade is OK.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Barker" <MarkBarker@.discussions.microsoft.com> wrote in message
news:9E97C141-6BFA-424F-A6C2-A5F6524FC824@.microsoft.com...
> I've upgrade in a similar scenario (a 2 node NLB running Reporting
Services and a separate server running SQL Server). Reporting Services is
showing the appropriate version number (8.00.878.00) so all seems well on
the NLB.
> The only thing that makes me slightly nervous about the upgrade is the
fact that I didn't see any kind of 'upgrading database...' dialog box, and I
have seen this dialog box where I have upgraded Reporting Services servers
that are running SQL Server and Reporting Services on the same server.
> Should I just forget about this nervousness and assume that the database
has successfully upgraded - Is there any way to verify that the upgrade has
taken place on the SQL Server?
> Thanks,
> Mark
>
> "Tudor Trufinescu (MSFT)" wrote:
> > You don't need to run SP1 setup on the SQL Server box - if that's
separate
> > from the report server box.
> > When you run SP1 setup on the RS box it will update stored procs and
tables
> > on the SQL Server box.
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
> > news:uKoXakWXEHA.3564@.TK2MSFTNGP11.phx.gbl...
> > > Tudor, doesn't SP1 also update the server as well?
> > >
> > > --
> > > ____________________________________
> > > William (Bill) Vaughn
> > > Author, Mentor, Consultant
> > > Microsoft MVP
> > > www.betav.com
> > > Please reply only to the newsgroup so that others can benefit.
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > __________________________________
> > >
> > > "Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
> > > news:uKCfRmTXEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > > On 2 and 3.
> > > >
> > > > --
> > > > Tudor Trufinescu
> > > > Dev Lead
> > > > Sql Server Reporting Services
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > >
> > > >
> > > > "Dushan Bilbija" <dbilbija@.msn.com> wrote in message
> > > > news:e#rFxdTXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> > > > > i have 3 machines running report service components:
> > > > >
> > > > > 1 - a sql server
> > > > > 2 - a web server
> > > > > 3 - a development machine with vsnet2003
> > > > >
> > > > > do i run sp1 on all 3?
> > > > >
> > > > > please help
> > > > >
> > > > > dushan bilbija
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
> >|||There are definetly database changes. My diff showed 1 table change and 13
stored procedure changes. It's just as Tudor said though, the RS Service
takes care of the updates.
-Joel
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:Oweg%239eXEHA.1152@.TK2MSFTNGP09.phx.gbl...
> I don't think that there are any database related changes within Reporting
> Services SP1.
> --
> Keith
>
> "Mark Barker" <MarkBarker@.discussions.microsoft.com> wrote in message
> news:9E97C141-6BFA-424F-A6C2-A5F6524FC824@.microsoft.com...
> > I've upgrade in a similar scenario (a 2 node NLB running Reporting
> Services and a separate server running SQL Server). Reporting Services is
> showing the appropriate version number (8.00.878.00) so all seems well on
> the NLB.
> >
> > The only thing that makes me slightly nervous about the upgrade is the
> fact that I didn't see any kind of 'upgrading database...' dialog box, and
I
> have seen this dialog box where I have upgraded Reporting Services servers
> that are running SQL Server and Reporting Services on the same server.
> >
> > Should I just forget about this nervousness and assume that the database
> has successfully upgraded - Is there any way to verify that the upgrade
has
> taken place on the SQL Server?
> >
> > Thanks,
> > Mark
> >
> >
> > "Tudor Trufinescu (MSFT)" wrote:
> >
> > > You don't need to run SP1 setup on the SQL Server box - if that's
> separate
> > > from the report server box.
> > > When you run SP1 setup on the RS box it will update stored procs and
> tables
> > > on the SQL Server box.
> > >
> > > --
> > > Tudor Trufinescu
> > > Dev Lead
> > > Sql Server Reporting Services
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
> > > news:uKoXakWXEHA.3564@.TK2MSFTNGP11.phx.gbl...
> > > > Tudor, doesn't SP1 also update the server as well?
> > > >
> > > > --
> > > > ____________________________________
> > > > William (Bill) Vaughn
> > > > Author, Mentor, Consultant
> > > > Microsoft MVP
> > > > www.betav.com
> > > > Please reply only to the newsgroup so that others can benefit.
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > > __________________________________
> > > >
> > > > "Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
> > > > news:uKCfRmTXEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > > > On 2 and 3.
> > > > >
> > > > > --
> > > > > Tudor Trufinescu
> > > > > Dev Lead
> > > > > Sql Server Reporting Services
> > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > > rights.
> > > > >
> > > > >
> > > > > "Dushan Bilbija" <dbilbija@.msn.com> wrote in message
> > > > > news:e#rFxdTXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> > > > > > i have 3 machines running report service components:
> > > > > >
> > > > > > 1 - a sql server
> > > > > > 2 - a web server
> > > > > > 3 - a development machine with vsnet2003
> > > > > >
> > > > > > do i run sp1 on all 3?
> > > > > >
> > > > > > please help
> > > > > >
> > > > > > dushan bilbija
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> > >
>|||Thanks Tudor
Sounds like we are all agreed that the steps for running SP1 in a Web Farm outlined in the SP1 readme should be ignored?
â'The order in which you apply SP1 is important. You must first apply SP1 to the server that hosts the report server database (this updates the database format to the SP1 version). Once you update the database, you can update the report server nodes in any order.â'
Cleary if I have implemented my Web Farm following the recommendations in Reporting Services BOL , Step 1 (run SP1 on the database server) will never work.
Thanks,
Mark
"Tudor Trufinescu (MSFT)" wrote:
> The SP1 bits would only work on the SP1 schema, so your upgrade is OK.
> --
> Tudor Trufinescu
> Dev Lead
> Sql Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Mark Barker" <MarkBarker@.discussions.microsoft.com> wrote in message
> news:9E97C141-6BFA-424F-A6C2-A5F6524FC824@.microsoft.com...
> > I've upgrade in a similar scenario (a 2 node NLB running Reporting
> Services and a separate server running SQL Server). Reporting Services is
> showing the appropriate version number (8.00.878.00) so all seems well on
> the NLB.
> >
> > The only thing that makes me slightly nervous about the upgrade is the
> fact that I didn't see any kind of 'upgrading database...' dialog box, and I
> have seen this dialog box where I have upgraded Reporting Services servers
> that are running SQL Server and Reporting Services on the same server.
> >
> > Should I just forget about this nervousness and assume that the database
> has successfully upgraded - Is there any way to verify that the upgrade has
> taken place on the SQL Server?
> >
> > Thanks,
> > Mark
> >
> >
> > "Tudor Trufinescu (MSFT)" wrote:
> >
> > > You don't need to run SP1 setup on the SQL Server box - if that's
> separate
> > > from the report server box.
> > > When you run SP1 setup on the RS box it will update stored procs and
> tables
> > > on the SQL Server box.
> > >
> > > --
> > > Tudor Trufinescu
> > > Dev Lead
> > > Sql Server Reporting Services
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
> > > news:uKoXakWXEHA.3564@.TK2MSFTNGP11.phx.gbl...
> > > > Tudor, doesn't SP1 also update the server as well?
> > > >
> > > > --
> > > > ____________________________________
> > > > William (Bill) Vaughn
> > > > Author, Mentor, Consultant
> > > > Microsoft MVP
> > > > www.betav.com
> > > > Please reply only to the newsgroup so that others can benefit.
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > > __________________________________
> > > >
> > > > "Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
> > > > news:uKCfRmTXEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > > > On 2 and 3.
> > > > >
> > > > > --
> > > > > Tudor Trufinescu
> > > > > Dev Lead
> > > > > Sql Server Reporting Services
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > > rights.
> > > > >
> > > > >
> > > > > "Dushan Bilbija" <dbilbija@.msn.com> wrote in message
> > > > > news:e#rFxdTXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> > > > > > i have 3 machines running report service components:
> > > > > >
> > > > > > 1 - a sql server
> > > > > > 2 - a web server
> > > > > > 3 - a development machine with vsnet2003
> > > > > >
> > > > > > do i run sp1 on all 3?
> > > > > >
> > > > > > please help
> > > > > >
> > > > > > dushan bilbija
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> > >
>
>|||Yes, the wording is wrong here, I will pass this to our doc team.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Barker" <MarkBarker@.discussions.microsoft.com> wrote in message
news:74CA554A-9BCD-46CF-B99C-AC8B8445CF55@.microsoft.com...
> Thanks Tudor
> Sounds like we are all agreed that the steps for running SP1 in a Web Farm
outlined in the SP1 readme should be ignored?
> "The order in which you apply SP1 is important. You must first apply SP1
to the server that hosts the report server database (this updates the
database format to the SP1 version). Once you update the database, you can
update the report server nodes in any order."
> Cleary if I have implemented my Web Farm following the recommendations in
Reporting Services BOL , Step 1 (run SP1 on the database server) will never
work.
> Thanks,
> Mark
>
> "Tudor Trufinescu (MSFT)" wrote:
> > The SP1 bits would only work on the SP1 schema, so your upgrade is OK.
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Mark Barker" <MarkBarker@.discussions.microsoft.com> wrote in message
> > news:9E97C141-6BFA-424F-A6C2-A5F6524FC824@.microsoft.com...
> > > I've upgrade in a similar scenario (a 2 node NLB running Reporting
> > Services and a separate server running SQL Server). Reporting Services
is
> > showing the appropriate version number (8.00.878.00) so all seems well
on
> > the NLB.
> > >
> > > The only thing that makes me slightly nervous about the upgrade is the
> > fact that I didn't see any kind of 'upgrading database...' dialog box,
and I
> > have seen this dialog box where I have upgraded Reporting Services
servers
> > that are running SQL Server and Reporting Services on the same server.
> > >
> > > Should I just forget about this nervousness and assume that the
database
> > has successfully upgraded - Is there any way to verify that the upgrade
has
> > taken place on the SQL Server?
> > >
> > > Thanks,
> > > Mark
> > >
> > >
> > > "Tudor Trufinescu (MSFT)" wrote:
> > >
> > > > You don't need to run SP1 setup on the SQL Server box - if that's
> > separate
> > > > from the report server box.
> > > > When you run SP1 setup on the RS box it will update stored procs and
> > tables
> > > > on the SQL Server box.
> > > >
> > > > --
> > > > Tudor Trufinescu
> > > > Dev Lead
> > > > Sql Server Reporting Services
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > > "William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in
message
> > > > news:uKoXakWXEHA.3564@.TK2MSFTNGP11.phx.gbl...
> > > > > Tudor, doesn't SP1 also update the server as well?
> > > > >
> > > > > --
> > > > > ____________________________________
> > > > > William (Bill) Vaughn
> > > > > Author, Mentor, Consultant
> > > > > Microsoft MVP
> > > > > www.betav.com
> > > > > Please reply only to the newsgroup so that others can benefit.
> > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > > rights.
> > > > > __________________________________
> > > > >
> > > > > "Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
> > > > > news:uKCfRmTXEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > > > > On 2 and 3.
> > > > > >
> > > > > > --
> > > > > > Tudor Trufinescu
> > > > > > Dev Lead
> > > > > > Sql Server Reporting Services
> > > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > > > rights.
> > > > > >
> > > > > >
> > > > > > "Dushan Bilbija" <dbilbija@.msn.com> wrote in message
> > > > > > news:e#rFxdTXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> > > > > > > i have 3 machines running report service components:
> > > > > > >
> > > > > > > 1 - a sql server
> > > > > > > 2 - a web server
> > > > > > > 3 - a development machine with vsnet2003
> > > > > > >
> > > > > > > do i run sp1 on all 3?
> > > > > > >
> > > > > > > please help
> > > > > > >
> > > > > > > dushan bilbija
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >