BSM with SSRS(2005) on a different box

Could anybody help provide some detailed information about installing BSM with SSRS 2005? My installation needs to have SSRS running on a different box than the BSM server.

There are 2 issues involved here:

The BSM Server.msi by default looks for Reporting Services 2000. I need to have the complete installation based on SQL2005. Do i have to install RS2000 and then manually configure it to use SSRS2005?

In addition to this, I would prefer to have the Report Server on a different machine. How do you convey this altered configuration to the Server.msi file which looks for a reporting services instance on the same machine. The set up does not proceed without having RS2000 on the same box.

You'll probably have more luck in the Reporting Services forum, http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1. This one is dedictated to Microsoft SQL Server Notification Services.

In the meantime, you might find this thread interesting; it describes how BSM works with SQLNS. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=137502&SiteID=1

Good luck!

Joe

|||Thanks. I have posted the same question here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=252677&SiteID=1

British Summer Time stopping SQL backup routine

Hi All
I have set up several DB Maintenance Plans in my SQL 2000 installation to
backup 3 sep DBs to a designated 'day' folder (ie 7 different folders to
cover Mon - Sun) on the same HD every day at 1am. This was working fine
everyday until the clocks moved forward by 1 hour to accommodate BST
(British Summer Time) and then the backups stopped backing up.
Now my PC Server being a good SBS 2000 installation auto-changed it's clock
to 1 hour forward, but the backups have just stopped working.
To correct this, I simply went into each DB Maintenance plan , opened up the
schedule, unticked a day, ticked it again and then saved it (ala what I call
a refresh) and everything started working again.
I know I could put these backups into 1 folder so I didn't have to update 21
or so individual plans, but I need to put it into these day folders to make
it easier for the day-to-day monitor-er of these backups.
I also know this problem only appears to happen twice a year (day when the
clocks go back and day when the clocks go forward), but because it is such
an unnecessary procedure, I just wanted to ask you if there was any fix for
it.
Many thanks.
Rgds
RobbieThere's not really a "fix", as there isn't really a problem, at least not
with SQL Server. 1:00 AM doesn't exist on the day you go to summer time, as
the clock moves from 00:59:59 GMT to 02:00:00 BST. On the other side, you
would have 1:00 AM twice when the clocks go back.
The best practice, if you want to avoid these little irritations, is not to
schedule anything within this period, and instead start your backup at 00:59
AM.
--
Jacco Schalkwijk
SQL Server MVP
"Astra" <info@.noemail.com> wrote in message
news:emGph0QNFHA.3000@.TK2MSFTNGP10.phx.gbl...
> Hi All
> I have set up several DB Maintenance Plans in my SQL 2000 installation to
> backup 3 sep DBs to a designated 'day' folder (ie 7 different folders to
> cover Mon - Sun) on the same HD every day at 1am. This was working fine
> everyday until the clocks moved forward by 1 hour to accommodate BST
> (British Summer Time) and then the backups stopped backing up.
> Now my PC Server being a good SBS 2000 installation auto-changed it's
> clock
> to 1 hour forward, but the backups have just stopped working.
> To correct this, I simply went into each DB Maintenance plan , opened up
> the
> schedule, unticked a day, ticked it again and then saved it (ala what I
> call
> a refresh) and everything started working again.
> I know I could put these backups into 1 folder so I didn't have to update
> 21
> or so individual plans, but I need to put it into these day folders to
> make
> it easier for the day-to-day monitor-er of these backups.
> I also know this problem only appears to happen twice a year (day when the
> clocks go back and day when the clocks go forward), but because it is such
> an unnecessary procedure, I just wanted to ask you if there was any fix
> for
> it.
> Many thanks.
> Rgds
> Robbie
>|||Dohhh!!!
Many thanks Jacco
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid> wrote
in message news:ue9SDFRNFHA.3156@.TK2MSFTNGP15.phx.gbl...
There's not really a "fix", as there isn't really a problem, at least not
with SQL Server. 1:00 AM doesn't exist on the day you go to summer time, as
the clock moves from 00:59:59 GMT to 02:00:00 BST. On the other side, you
would have 1:00 AM twice when the clocks go back.
The best practice, if you want to avoid these little irritations, is not to
schedule anything within this period, and instead start your backup at 00:59
AM.
--
Jacco Schalkwijk
SQL Server MVP
"Astra" <info@.noemail.com> wrote in message
news:emGph0QNFHA.3000@.TK2MSFTNGP10.phx.gbl...
> Hi All
> I have set up several DB Maintenance Plans in my SQL 2000 installation to
> backup 3 sep DBs to a designated 'day' folder (ie 7 different folders to
> cover Mon - Sun) on the same HD every day at 1am. This was working fine
> everyday until the clocks moved forward by 1 hour to accommodate BST
> (British Summer Time) and then the backups stopped backing up.
> Now my PC Server being a good SBS 2000 installation auto-changed it's
> clock
> to 1 hour forward, but the backups have just stopped working.
> To correct this, I simply went into each DB Maintenance plan , opened up
> the
> schedule, unticked a day, ticked it again and then saved it (ala what I
> call
> a refresh) and everything started working again.
> I know I could put these backups into 1 folder so I didn't have to update
> 21
> or so individual plans, but I need to put it into these day folders to
> make
> it easier for the day-to-day monitor-er of these backups.
> I also know this problem only appears to happen twice a year (day when the
> clocks go back and day when the clocks go forward), but because it is such
> an unnecessary procedure, I just wanted to ask you if there was any fix
> for
> it.
> Many thanks.
> Rgds
> Robbie
>

breaking web service?

I currently have a SQL 2000 RS SP2 installation and upgraded the back end to
2005. I think I read somewhere that the web service is not compatible
anymore? I am using the web services and don't want to have to change any
code if I don't have to. Will my 2000 WS implementation continue to work
after I install SSRS 2005?
Thanks
ScottHi Scott,
As for the SQL Server reporting service, the webservice interface should
definitely change from version 2000 to version 2005 as Reporting service
2005 has involved some new objects and methods signatures. A simple way to
check this is compare the WSDL service description of the two ones and look
for the service interface definiations. If you want to migrate your
application from RS 2000 to RS 2005, I think it is necessary to regenerate
the service proxy and use the new proxy methods.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.

Brand New Newbie

Hello all. The installation instructions in "Microsoft SQL Server: System
Administration" tell me to Create a New User Account in the 'Active
Directory Users and Computers' application. But when I search Win XP Pro for
this filename, it can't find it. I started AddPrograms and clicked on
everything that I didn't install originally. Still search could not find it.
What am I overlooking or doing wrong? Thanks in advance for any help. Jim
RichardsOn Fri, 05 Nov 2004 18:43:02 GMT, Jim Richards wrote:

> Hello all. The installation instructions in "Microsoft SQL Server: System
> Administration" tell me to Create a New User Account in the 'Active
> Directory Users and Computers' application. But when I search Win XP Pro for
> this filename, it can't find it. I started AddPrograms and clicked on
> everything that I didn't install originally. Still search could not find it.
> What am I overlooking or doing wrong? Thanks in advance for any help. Jim
> Richards

If your SQL server is running on an XP machine that is not part of a
domain, you will want the Local Users and Groups segment under
Administrative Tools (or under Computer Management, same thing.)|||Thank you Ross. Now how do I tell if my XP Pro is, or is not, part of a
domain? This stuff is all new to me. TIA, Jim.

"Ross Presser" <rpresser@.imtek.com> wrote in message
news:2aps97kwfpfw$.dlg@.rpresser.invalid...
> On Fri, 05 Nov 2004 18:43:02 GMT, Jim Richards wrote:
>> Hello all. The installation instructions in "Microsoft SQL Server: System
>> Administration" tell me to Create a New User Account in the 'Active
>> Directory Users and Computers' application. But when I search Win XP Pro
>> for
>> this filename, it can't find it. I started AddPrograms and clicked on
>> everything that I didn't install originally. Still search could not find
>> it.
>> What am I overlooking or doing wrong? Thanks in advance for any help. Jim
>> Richards
> If your SQL server is running on an XP machine that is not part of a
> domain, you will want the Local Users and Groups segment under
> Administrative Tools (or under Computer Management, same thing.)|||Jim Richards (JWRichards@.satx.rr.com) writes:
> Thank you Ross. Now how do I tell if my XP Pro is, or is not, part of a
> domain? This stuff is all new to me. TIA, Jim.

Control Panel, the System applet. Go the Computer Name tab. If it says
Workgroup under "Full computer name", you are not in a domain. If it says
Domain followed by the domain name, you are in a domain.

If you have your machine, and not connected to anyone else's, you are
very likely not in a domain.

If you are in a domain, you might have to see your system administrator
to create that user.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks Erland. I checked and mine says "WORKGROUP" so I am not on a domain.
This makes sense as my LAN includes only my PC and my daughter's PC
upstairs. Thanks for the help and have a good day. Jim Richards

"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns9598EC6ADDB46Yazorman@.127.0.0.1...
> Jim Richards (JWRichards@.satx.rr.com) writes:
>> Thank you Ross. Now how do I tell if my XP Pro is, or is not, part of a
>> domain? This stuff is all new to me. TIA, Jim.
> Control Panel, the System applet. Go the Computer Name tab. If it says
> Workgroup under "Full computer name", you are not in a domain. If it says
> Domain followed by the domain name, you are in a domain.
> If you have your machine, and not connected to anyone else's, you are
> very likely not in a domain.
> If you are in a domain, you might have to see your system administrator
> to create that user.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp

BPA Installation Error

I am trying to install BPA on a W2K workstation that has SQL 2000 Personal
Edition SP3. Just befor completing the installation, I get a message box
that says
"One or more rules could not be installed. There is an error in XML document
(55, 15). Invalid SQL Server edition"
I tried using the local server for repository and also tried a SQL 2K
Enterprise Edition, SP 3 running on a W2K Advanced Server. I am getting the
same error.
What am I missing ?
Thanks for any help or any pointers I can get.
Sathish V
Hey Sathish, when you get those error there should be a box below that that
allow you to check in and out of that criteria.
"Sathish V" wrote:

> I am trying to install BPA on a W2K workstation that has SQL 2000 Personal
> Edition SP3. Just befor completing the installation, I get a message box
> that says
> "One or more rules could not be installed. There is an error in XML document
> (55, 15). Invalid SQL Server edition"
> I tried using the local server for repository and also tried a SQL 2K
> Enterprise Edition, SP 3 running on a W2K Advanced Server. I am getting the
> same error.
> What am I missing ?
> Thanks for any help or any pointers I can get.
> Sathish V
|||Thanks Garry. I will check it out let you know.
"Garry D" wrote:
[vbcol=seagreen]
> Hey Sathish, when you get those error there should be a box below that that
> allow you to check in and out of that criteria.
> "Sathish V" wrote:
|||I was having the same problem. I solved it by:
Removing BPA in Control Panel/Add Remove Programs
Removing the BPA database from my SQL Server
Removing the BPA directory in c:\Program Files
After doing all these, it installed fine. Now to try it...
"Sathish V" wrote:

> I am trying to install BPA on a W2K workstation that has SQL 2000 Personal
> Edition SP3. Just befor completing the installation, I get a message box
> that says
> "One or more rules could not be installed. There is an error in XML document
> (55, 15). Invalid SQL Server edition"
> I tried using the local server for repository and also tried a SQL 2K
> Enterprise Edition, SP 3 running on a W2K Advanced Server. I am getting the
> same error.
> What am I missing ?
> Thanks for any help or any pointers I can get.
> Sathish V
|||Sathish, Mike
Let us know if this issue has been resolved
Thanks
Sethu
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Mike W." <Mike W.@.discussions.microsoft.com> wrote in message
news:0669F4C0-04FA-4201-9E47-1432B89DBF54@.microsoft.com...[vbcol=seagreen]
>I was having the same problem. I solved it by:
> Removing BPA in Control Panel/Add Remove Programs
> Removing the BPA database from my SQL Server
> Removing the BPA directory in c:\Program Files
> After doing all these, it installed fine. Now to try it...
> "Sathish V" wrote: