I had my IT dept. install sql server 2005 enterprise edition on a new windows server 2003. All other machines are running sql 2000 server on windows server 2000. I am a sa and local admin on all servers. I tried performing copy database, backup and restore and detach and attach to upgrade the sql server 2000 databases to 2005 and all fail. They also installed sql server 2005 sp2. I followed all steps. It's like the servers dont talk to each other. Their all on the company's domain. I am wondering if something happen with the install but the IT dept. insist that everything went fine. It's strange that I can't perform a simple backup and restore it on the new server buy when I click on restore it doesn't let me browse to get the backup file on the 2000 server. I never had a problem in Sql 2000 with backup. Can it be the installation was corrupted somehow. It seems fine. I haven't created any new databases because I wanted to move the databases from sql 2000. Can anyone help me get a clue of what the problem is please?
ThanksSounds like the service account for the SQL Server 2005 service has no network rights. Try copying the backup file locally, then doing the restore.
Showing posts with label machines. Show all posts
Showing posts with label machines. Show all posts
Friday, March 30, 2012
Tuesday, March 20, 2012
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
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >
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
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >
Subscribe to:
Posts (Atom)