data-driven subscription

Does Reporting Services 2000 have data-driven subscriptions or will I need
to upgrade to RS 2005. I would like different employees to pass different
parameters by default. I receive the following message in RS 2000 and I'm
storing a sql account password so I don't think security is the issue.
The error says the following "Subscriptions cannot be created because the
credentials used to run the report are not stored, the report is using
user-defined parameter values"data-driven subscriptions do work in RS 2000. I believe the problem with
your subscription is that one of your parameters is the user login. You are
probably defaulting the current user into the field. You may need to remove
the default value so that you can supply it from the data driven query for
your subscription.
"Colin" wrote:
> Does Reporting Services 2000 have data-driven subscriptions or will I need
> to upgrade to RS 2005. I would like different employees to pass different
> parameters by default. I receive the following message in RS 2000 and I'm
> storing a sql account password so I don't think security is the issue.
>
> The error says the following "Subscriptions cannot be created because the
> credentials used to run the report are not stored, the report is using
> user-defined parameter values"
>
>

Databases per Server

All,

I have 2 web applications running on 2 W2K servers. Each server has a local SQL server(2000). We are about to upgrade the servers to Windows 2003. The web applications are running classic ASP and VB COM+ objects. We are going to take the opportunity to seperate SQL from the web server. What will end up with is 2 web servers running the applications and a single database server with 2 databases servering up the data. We will upgrade the SQL2K to SQL2K5.

My question is how will the SQL performance be affected? What's the best place to locate the COM+ objects? What kind of pitfalls do I need to be aware of?

Thanks

BB

Make sure that the consolidated box has suitable hardware to support both apps (memory, disks, processors). Also, remember that now the a failure of the SQL Server will bring down both while if one database starts hogging resources, the other would be adversely affected. Similarly you'll only have one set of system databases so make sure that tempdb is on a fast set of disks.

Certainly one area you may need to check any conflicts arising from any SQL Server configurations that may differ on the current boxes and also any login conflicts. Remember, also that future patches will be applied at the server level and both apps will need to be able to run on the same SQL version.

You are able to run multiple instances on one box which would allow you to allocate resources better to each application or could consider virtual servers which is becoming more and more popular these days.

HTH!

|||

Great advice - thanks!

What about the increase in network traffic. Is there something to do hardware wise? Like adding a second NIC card? Will that even make a difference?

Thanks

Database versipn (C.0.8.40) does not match

When I click the "Upgrade" button while trying to configure reporting
services I get a couple of errors here are the two errors:
"Verify Database Version" First Yellow "!" Says :
The database version (C.0.8.40) does not match your reporting services
installation. You must upgrade your reporting services database.
"Create Upgrade Script for Database Version" Second Yellow "!" say:
Couldn't generate the upgrade script. There is no upgrade script available
for this version.
Has anyone seen these errors before. How to I get around these. Right now
my "Database Setup" in has a red "X" on the "Reporting Services Configuration
Manager" window.I have the same exact problem. Any fixes yet?
--
---
Yes, I searched first :)
"Greg Larsen" wrote:
> When I click the "Upgrade" button while trying to configure reporting
> services I get a couple of errors here are the two errors:
> "Verify Database Version" First Yellow "!" Says :
> The database version (C.0.8.40) does not match your reporting services
> installation. You must upgrade your reporting services database.
> "Create Upgrade Script for Database Version" Second Yellow "!" say:
> Couldn't generate the upgrade script. There is no upgrade script available
> for this version.
> Has anyone seen these errors before. How to I get around these. Right now
> my "Database Setup" in has a red "X" on the "Reporting Services Configuration
> Manager" window.
>|||Do you have a resolution to this issue? I ahve the exact same problem.
"Greg Larsen" wrote:
> When I click the "Upgrade" button while trying to configure reporting
> services I get a couple of errors here are the two errors:
> "Verify Database Version" First Yellow "!" Says :
> The database version (C.0.8.40) does not match your reporting services
> installation. You must upgrade your reporting services database.
> "Create Upgrade Script for Database Version" Second Yellow "!" say:
> Couldn't generate the upgrade script. There is no upgrade script available
> for this version.
> Has anyone seen these errors before. How to I get around these. Right now
> my "Database Setup" in has a red "X" on the "Reporting Services Configuration
> Manager" window.
>|||I had the same problem.
It was caused by that I had installed reporting services after I had run
SP1 on SQL Server 2005.
Solved it by runing SQL Server 2005 SP1 again.
Hope this helps!
"Rich" wrote:
> Do you have a resolution to this issue? I ahve the exact same problem.
> "Greg Larsen" wrote:
> > When I click the "Upgrade" button while trying to configure reporting
> > services I get a couple of errors here are the two errors:
> >
> > "Verify Database Version" First Yellow "!" Says :
> > The database version (C.0.8.40) does not match your reporting services
> > installation. You must upgrade your reporting services database.
> >
> > "Create Upgrade Script for Database Version" Second Yellow "!" say:
> > Couldn't generate the upgrade script. There is no upgrade script available
> > for this version.
> >
> > Has anyone seen these errors before. How to I get around these. Right now
> > my "Database Setup" in has a red "X" on the "Reporting Services Configuration
> > Manager" window.
> >