Data Driven Subscriptions

I read somewhere that Data Driven Subscriptions are only for Enterpise Edition.
In this case, why is it available in the Standard edition web interface of
the Report Manager?Data driven subscriptions are not available with Standard edition
(http://www.microsoft.com/sql/reporting/productinfo/features.asp). The
button is probably there because the subscription types are not
configurable.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Minas Papageorgiou" <MinasPapageorgiou@.discussions.microsoft.com> wrote in
message news:5C3CF96E-15DC-45F0-9C81-E4B913FDAECB@.microsoft.com...
> I read somewhere that Data Driven Subscriptions are only for Enterpise
Edition.
> In this case, why is it available in the Standard edition web interface of
> the Report Manager?sql

Data Driven Subscription Disabled

Hi All,

We are using SQL Server 2005 enterprise edition for our project with SSRS 2005.

We are not getting the Data driven subscription option enabled. That is we see the tab in Report Manager but its disabled.

We have ensured the following:

1- The server is enterprise edition with SP1

2- The users are part of local admin group on the report server

3- The report credentials are stored in the database.

Is there anything missed out?

Thank

Manish

Did you ever get an answer to this? We are having the same thing going on. Are you using integrated security or just Windows?|||

I guess Data Driven Subscription button is not disabled but you're getting error message if it's pressed. Correct? Make sure your report does not contain expressions depending on user like User!UserID. See http://msdn2.microsoft.com/en-us/library/ms156012.aspx for all DD subscription creation guidelines.

|||

No, the Data Driven Subscription button is disabled. I have through the tutorial about4 times. We use the Developer edition and the SQL Server Agent is running. I have also set up the datasource as instructed.

Any other ideas?

Thanks,

SP

|||

I know we installed the Developer edition, but when I use select @.@.version, it says only standard edition. We installed it through the MSDN subscription CD Disc 3097.1

Is there another way to tell what version you have?

Thanks,

SP

Data Driven Subscription Disabled

Hi All,

We are using SQL Server 2005 enterprise edition for our project with SSRS 2005.

We are not getting the Data driven subscription option enabled. That is we see the tab in Report Manager but its disabled.

We have ensured the following:

1- The server is enterprise edition with SP1

2- The users are part of local admin group on the report server

3- The report credentials are stored in the database.

Is there anything missed out?

Thank

Manish

Did you ever get an answer to this? We are having the same thing going on. Are you using integrated security or just Windows?|||

I guess Data Driven Subscription button is not disabled but you're getting error message if it's pressed. Correct? Make sure your report does not contain expressions depending on user like User!UserID. See http://msdn2.microsoft.com/en-us/library/ms156012.aspx for all DD subscription creation guidelines.

|||

No, the Data Driven Subscription button is disabled. I have through the tutorial about4 times. We use the Developer edition and the SQL Server Agent is running. I have also set up the datasource as instructed.

Any other ideas?

Thanks,

SP

|||

I know we installed the Developer edition, but when I use select @.@.version, it says only standard edition. We installed it through the MSDN subscription CD Disc 3097.1

Is there another way to tell what version you have?

Thanks,

SP

Data Driven Subscription Disabled

Hi All,

We are using SQL Server 2005 enterprise edition for our project with SSRS 2005.

We are not getting the Data driven subscription option enabled. That is we see the tab in Report Manager but its disabled.

We have ensured the following:

1- The server is enterprise edition with SP1

2- The users are part of local admin group on the report server

3- The report credentials are stored in the database.

Is there anything missed out?

Thank

Manish

Did you ever get an answer to this? We are having the same thing going on. Are you using integrated security or just Windows?|||

I guess Data Driven Subscription button is not disabled but you're getting error message if it's pressed. Correct? Make sure your report does not contain expressions depending on user like User!UserID. See http://msdn2.microsoft.com/en-us/library/ms156012.aspx for all DD subscription creation guidelines.

|||

No, the Data Driven Subscription button is disabled. I have through the tutorial about4 times. We use the Developer edition and the SQL Server Agent is running. I have also set up the datasource as instructed.

Any other ideas?

Thanks,

SP

|||

I know we installed the Developer edition, but when I use select @.@.version, it says only standard edition. We installed it through the MSDN subscription CD Disc 3097.1

Is there another way to tell what version you have?

Thanks,

SP

Data Conversion supported on Standard Edition?

I created an Integration Services Package that runs fine from my local computer using BIDS. However when I imported into our SQL Server and try to run it from there I get the following error:

DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Data Conversion"

We are running SQL Server 2005 Standard Edition 64-bit.

We have integration services installed on the server. Is data conversion something that is not supported on Standard Edition?

Also have a similar message for "Send Mail Task."

Is there anywhere that outlines what features are supported on each version?

What version of SQL Server are you running on your developer's workstation?|||

I'm running BIDS on my workstation which is connecting to our SQL Server. The same SQL Server where the integration package will not run from when imported into. So I'm actually not running a full blown SQL Server database on my workstation, just using BIDS on it along with Studio.

The Management Studio on my workstation is 9.00.3042.

SQL Server Integration Services is 9.00.3042. (Found by going to About > Help in Visual Studio)

Our SQL Server version is 9.00.3050

|||So both your workstation and the server are running SQL Server Standard edition? Not developer/enterprise edition?|||

Server is definitely Standard Edition. When I installed the workstation components on my workstation I honestly don't remember if I installed them from the Standard edition or Developer edition. Most likely I installed the workstation components using the Developer edition. Is there a way to check?

I guess that would explain why it works on my workstation but not on the server?

|||

Erikk Ross wrote:

Server is definitely Standard Edition. When I installed the workstation components on my workstation I honestly don't remember if I installed them from the Standard edition or Developer edition. Most likely I installed the workstation components using the Developer edition. Is there a way to check?

Run this query on the server and again on your local version:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')|||

Yeah, like I said I don't have the actual Database engine installed on my workstation. But our server version is SP2: 9.00.3050.

So I guess Data Conversion is not supported in Standard Edition? Or send mail? Is there a matrix somewhere that shows what features in Integration Services are supported in each version of SQL Server? It would seem to me that data conversion is something that is pretty common...I'm a little suprised it would require the Enterprise edition.

|||Alright, well, I do think it's because you're developing a package in a Developer environment, which is a higher level than the Standard edition that your server runs. If your server was an Enterprise version, you wouldn't have a problem (of course).

Uninstall and reinstall the SSIS components from the Standard Edition CDs and you should be fine. The Data Conversion component should work in the Standard Edition.|||

Phil Brammer wrote:

Alright, well, I do think it's because you're developing a package in a Developer environment, which is a higher level than the Standard edition that your server runs. If your server was an Enterprise version, you wouldn't have a problem (of course).

Uninstall and reinstall the SSIS components from the Standard Edition CDs and you should be fine. The Data Conversion component should work in the Standard Edition.

That was indeed the solution. I just did a quick test and creating the package from a Standard edition version did allow the data conversion to work correctly. Thank you!!

|||

Well, after uninstalling SQL Server workstation components on my development machine and reinstalling the Standard version it did not fix my problem. Any package created on my local development machine still does not work when imported into SQL Server. Get the same Product level to low error.

At least the good news is that I can create packages on the SQL Server itself and they seem to work fine. My best guess is that uninstalling the developer edition and reinstalling the standard edition just wasn't enough. I would suspect that if I was to completely wipe my machine clean then install Standard Edition it would probably be ok. But that is more hassle than it's worth.

|||

Erikk Ross wrote:

Well, after uninstalling SQL Server workstation components on my development machine and reinstalling the Standard version it did not fix my problem. Any package created on my local development machine still does not work when imported into SQL Server. Get the same Product level to low error.

At least the good news is that I can create packages on the SQL Server itself and they seem to work fine. My best guess is that uninstalling the developer edition and reinstalling the standard edition just wasn't enough. I would suspect that if I was to completely wipe my machine clean then install Standard Edition it would probably be ok. But that is more hassle than it's worth.

Any NEW packages created still don't work?|||

Correct, I created a brand new package. Well I first tried to rebuild my old package but that didn't work either, so I just created a new one. Same problems, runs fine on my local workstation, but when imported into SQL Server gives the same error.

I am currently installing standard edition workstation components on a new workstation with Visual Studio and will try to create a package from there and import it and see if that works.

|||Run this on the server, please:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')|||

Phil Brammer wrote:

Run this on the server, please:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

9.00.3050.00 SP2 Standard Edition (64-bit)

Well now I am completely lost. I just installed the standard edition workstation components on a brand new machine. A machine that has never had SQL Server installed on it. I created a new package in Visual Studio, imported it into our SQL Server, ran it, and still get the same ProductLevelToLow errors.

Error: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Data Conversion".

|||

After reading this I realized my problem: http://blogs.msdn.com/michen/archive/2006/08/11/package-exec-location.aspx

I was running the package from my workstation using Management Studio, unaware that the package was actually running on my local workstation and not on the server. Since it was running on my workstation it required Integration Services to be installed which it wasn't, so that is why I got those error messages. As soon as I ran it directly from the server it worked fine.

*sigh* I wish this was more obvious. I thought that by running it in Management Studio it was just automatically running it on the server.

Data Center

Can anyone point me to documentation on when you would choose Windows Data Center edition rather than other editions of Windows.
Compare the Editions of Windows Server 2003
http://www.microsoft.com/windowsserv...eeditions.mspx
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cathy S." <Cathy S.@.discussions.microsoft.com> wrote in message
news:DF73FC99-5F5D-4457-884B-FF437BCBCFF1@.microsoft.com...
> Can anyone point me to documentation on when you would choose Windows Data
Center edition rather than other editions of Windows.
|||Many thanks. That's one hard page to find.
"Geoff N. Hiten" wrote:

> Compare the Editions of Windows Server 2003
> http://www.microsoft.com/windowsserv...eeditions.mspx
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Cathy S." <Cathy S.@.discussions.microsoft.com> wrote in message
> news:DF73FC99-5F5D-4457-884B-FF437BCBCFF1@.microsoft.com...
> Center edition rather than other editions of Windows.
>
>
|||Try using Google to search Microsoft.com. It works lots better than the
native search.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cathy Soloway" <Cathy Soloway@.discussions.microsoft.com> wrote in message
news:A525956A-95DA-4F97-A898-7A64EBC00CE2@.microsoft.com...[vbcol=seagreen]
> Many thanks. That's one hard page to find.
> "Geoff N. Hiten" wrote:
http://www.microsoft.com/windowsserv...eeditions.mspx[vbcol=seagreen]
Data[vbcol=seagreen]

Data Center

Can anyone point me to documentation on when you would choose Windows Data Center edition rather than other editions of Windows.Compare the Editions of Windows Server 2003
http://www.microsoft.com/windowsserver2003/evaluation/features/compareeditions.mspx
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cathy S." <Cathy S.@.discussions.microsoft.com> wrote in message
news:DF73FC99-5F5D-4457-884B-FF437BCBCFF1@.microsoft.com...
> Can anyone point me to documentation on when you would choose Windows Data
Center edition rather than other editions of Windows.|||Try using Google to search Microsoft.com. It works lots better than the
native search.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cathy Soloway" <Cathy Soloway@.discussions.microsoft.com> wrote in message
news:A525956A-95DA-4F97-A898-7A64EBC00CE2@.microsoft.com...
> Many thanks. That's one hard page to find.
> "Geoff N. Hiten" wrote:
> > Compare the Editions of Windows Server 2003
> >
http://www.microsoft.com/windowsserver2003/evaluation/features/compareeditions.mspx
> >
> >
> > --
> > Geoff N. Hiten
> > Microsoft SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> > I support the Professional Association for SQL Server
> > www.sqlpass.org
> >
> > "Cathy S." <Cathy S.@.discussions.microsoft.com> wrote in message
> > news:DF73FC99-5F5D-4457-884B-FF437BCBCFF1@.microsoft.com...
> > > Can anyone point me to documentation on when you would choose Windows
Data
> > Center edition rather than other editions of Windows.
> >
> >
> >

Data Center

Can anyone point me to documentation on when you would choose Windows Data C
enter edition rather than other editions of Windows.Compare the Editions of Windows Server 2003
x" target="_blank">http://www.microsoft.com/windowsser...ns.msp
x
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cathy S." <Cathy S.@.discussions.microsoft.com> wrote in message
news:DF73FC99-5F5D-4457-884B-FF437BCBCFF1@.microsoft.com...
> Can anyone point me to documentation on when you would choose Windows Data
Center edition rather than other editions of Windows.|||Many thanks. That's one hard page to find.
"Geoff N. Hiten" wrote:

> Compare the Editions of Windows Server 2003
> spx" target="_blank">http://www.microsoft.com/windowsser...ns.m
spx
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Cathy S." <Cathy S.@.discussions.microsoft.com> wrote in message
> news:DF73FC99-5F5D-4457-884B-FF437BCBCFF1@.microsoft.com...
> Center edition rather than other editions of Windows.
>
>|||Try using Google to search Microsoft.com. It works lots better than the
native search.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cathy Soloway" <Cathy Soloway@.discussions.microsoft.com> wrote in message
news:A525956A-95DA-4F97-A898-7A64EBC00CE2@.microsoft.com...[vbcol=seagreen]
> Many thanks. That's one hard page to find.
> "Geoff N. Hiten" wrote:
>
http://www.microsoft.com/windowsser...reeditions.mspx[vbcol=se
agreen]
Data[vbcol=seagreen]

Data Base Mirroring in SQL server 2005 Express Edition

HI,

Does SQL server 2005 Express Edition or

Does SQL server 2005 Express Edition Sp1 supports Data base Mirroring?

Here is direct quote from BOL,

http://msdn2.microsoft.com/en-us/library/ms188712.aspx

Before you use the Mirroring page to configure database mirroring, ensure that the following requirements have been met:

The principal and mirror server instances must be running the same edition of SQL Server-either Standard Edition or Enterprise Edition. Also, we strongly recommend that they run on comparable systems that can handle identical workloads.

Note:

The witness server instance can run on SQL Server Standard Edition, Enterprise Edition, Workgroup Edition, or Express Edition.

|||It answers to my question. Thank you.

Damn Newbie

I am looking to make a program using express edition Visual C#. I want my
application to interact with Microsoft SQL server, create tables, inserts,
lookups, the normal.

First I would like to read the documentation,and now to the point of my
post. Due to the (recently pointed out) ineptitude of my googling skills I
cannot find what I am looking for.

I presume this is an obvious and easy request so all comments on that front
will be directed to the bit bucket :-)

TIAShane (shane@.weasel.is-a-geek.net) writes:

Quote:

Originally Posted by

I am looking to make a program using express edition Visual C#. I want my
application to interact with Microsoft SQL server, create tables, inserts,
lookups, the normal.
>
First I would like to read the documentation,and now to the point of my
post. Due to the (recently pointed out) ineptitude of my googling
skills I cannot find what I am looking for.
>
I presume this is an obvious and easy request so all comments on that
front will be directed to the bit bucket :-)

Not sure what documentation you are asking for. But SQL Server comes with
Books Online, see also links below.

I don't know what Visual C# Express comes with, but you should find MSDN
Library on msdn.microsoft.com.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Daily Backups SQL 2005 Standard Edition

With SQL 2000 I was backing up to a NAS server by mapping a drive share to
Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
focused on a networking issue?
Thanks!
ChrisBackups are always done with the privileges of the account SQL Server is
running under. Does this account have access to that share? You never want
to use mapped drives. Use UNC pathing instead.
Andrew J. Kelly SQL MVP
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:eRk0J22LGHA.420@.tk2msftngp13.phx.gbl...
> With SQL 2000 I was backing up to a NAS server by mapping a drive share to
> Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
> focused on a networking issue?
> Thanks!
> Chris
>

Daily Backups SQL 2005 Standard Edition

With SQL 2000 I was backing up to a NAS server by mapping a drive share to
Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
focused on a networking issue?
Thanks!
Chris
Backups are always done with the privileges of the account SQL Server is
running under. Does this account have access to that share? You never want
to use mapped drives. Use UNC pathing instead.
Andrew J. Kelly SQL MVP
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:eRk0J22LGHA.420@.tk2msftngp13.phx.gbl...
> With SQL 2000 I was backing up to a NAS server by mapping a drive share to
> Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
> focused on a networking issue?
> Thanks!
> Chris
>

Daily Backups SQL 2005 Standard Edition

With SQL 2000 I was backing up to a NAS server by mapping a drive share to
Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
focused on a networking issue?
Thanks!
ChrisBackups are always done with the privileges of the account SQL Server is
running under. Does this account have access to that share? You never want
to use mapped drives. Use UNC pathing instead.
--
Andrew J. Kelly SQL MVP
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:eRk0J22LGHA.420@.tk2msftngp13.phx.gbl...
> With SQL 2000 I was backing up to a NAS server by mapping a drive share to
> Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
> focused on a networking issue?
> Thanks!
> Chris
>