OLAP / Analysis services version checking by client

The problem is that i would like to integrate a code to the file in net where MS Office Web Components and OLAP services are beeing used.
Code should automatically detect a version of olap client and office web service components (OWC) and if newer version is needed, then it should download it.
Good instructions were @. http://support.microsoft.com/default.aspx?scid=kb;en-us;312876
where ptssetup.exe included all necessary information, but it was applied to Microsoft SQL Server 2000 Analysis Services. Now what i need to know is how to write a code which is working on Microsoft SQL Server 2005. Or how the old code can be changed to get it work on sql server 2005?

Hello,

I'm going to move your question to one of the SQL Server forums were they should be able to help you.

Daniel Roth

|||

Erkki wrote:

The problem is that i would like to integrate a code to the file in net where MS Office Web Components and OLAP services are beeing used.
Code should automatically detect a version of olap client and office web service components (OWC) and if newer version is needed, then it should download it.
Good instructions were @. http://support.microsoft.com/default.aspx?scid=kb;en-us;312876
where ptssetup.exe included all necessary information, but it was applied to Microsoft SQL Server 2000 Analysis Services. Now what i need to know is how to write a code which is working on Microsoft SQL Server 2005. Or how the old code can be changed to get it work on sql server 2005?

I would like to know that too. Anyway, how is it possible to verify the version of OLAP ? How can it be done? Maybe to somehow connect to server where the olap is being used?

Office Web Components Security Settings...?

I have a number of reports for which it would be useful to allow users to make use of the office web Components to allow them to maniplulate the data and then export it to excel..

But as soon as i click the Excel symbol to dump out the pivot table to excel i get the error message;

"Safety settings on this computer prohibit accessing a data source on another domian."

Now i have been into Internet Explorers Tools >> Options >> security and enabled the 'Access Data sources across domains' on my computer (in both the internet and intranet zones) but it still pops up.. and wont let me export to excel

Any ideas.. anyone..?

worked it out.. as well as allowing the "Access data across domains" option in IE you also have to add the website to the 'Trusted Sites'.

Office web components basic authentication impersonation

Hi,

I have a question regarding office web components 10.0/11.0.

I've searched various forums without finding an answer.

My question is whether it's possible to use office web components with basic authentication so that the OWC uses the specified identity (basic authentication) to authenticate against AS 2000 instead of using the identity of the user that is currently logged on to the machine?

My problem is that we external users that aren't members of our AD that shall have access to AS2000. And when OWC uses the machine login instead of the basic authentication login the authentication fails.

And also, is it any difference when using OWC with AS 2000 compared to AS 2005?

I know that one solution that I've gotten to work with AS 2005 is to use HTTP connection, but then I must specify user name and password which isn't an ideal solution for us. It would be better if integrated security could be used.

Looking forward toward you answer

Regards,

Johan.

Moved as this seems to be AS related.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Not sure I get your question.

If you are trying to access Analysis Services using OWC through HTTP connection you got choice to ether use Basic Auth or Integrated. (Of cource there is anonymous)
If your user is coming from outside of AD, you got to use Basic Auth.
With Basic Auth your users needs to provide username and password, only integrated Auth works knows how to re-use existing user credentials.

HTH
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hello Edward,

My users are coming from outside of the AD. But I've created AD accounts for them to use when they login using basic authentication.

If I use HTTP connection will I have to add a username and a password in the connectionstring?

Is it possible for the user to connect to the AS database without using HTTP connection?

My experience of using OWC is that OWC will not use the identity of the web page but instead use the user's machine account.

/Johan

|||

You will need to provide usernames and passwords for Basic Auth to work.

As for protocols options to connect to Analysis Services: You have a choice of HTTP or TCP/IP.

Using TCP/IP you can establish connection to Analysis Server only using integrated windows authentication.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

> If I use HTTP connection will I have to add a username and a password in the connectionstring?

No, I think you can set up the virtual folder that holds the HTTP connectivity stuff using Basic Auth and it will then prompt and in this case you should not put the username/password in the connection string.

> My experience of using OWC is that OWC will not use the identity of the web page but instead use the user's machine account.

This is correct. OWC is an ActiveX component and it executes on the client machine (not on the server). It creates it's own connection back to the AS server. Therefore if you have Basic Auth setup on the website and on the HTTP connection, the users will get prompted twice. The only way around this would be to either:

allow anonymous access to the web page, and let the AS HTTP connection do the prompting setup an explicit username/password in the connection string, but this means you cannot apply role based security as AS only "sees" one user connecting.

Office Web Components & Analysis Services

Hi,
We've been asked to enable an external client to access a cube via OWC.
The idea is that if they play about with the cube through the PivotTable
control, this will enable them to define their requirements for a reporting
system to sit on top of the cube.
I've read and implemented the contents of the following document:-
- http://www.microsoft.com/technet/pr...5/httpasws.mspx
I've installed OWC and the SQL data access components on a test machine, and
have been trying to access the cube through a web-page hosting the pivot
table control.
Data access across domains is enabled in IE
The error returned is "The query could not be processed: The HTTP server
returned the following error: Forbidden."
Obviosuly some security setting somewhere needs to be tweaked ... but which
one :/
Access to the web-page hosting the OWC control will be locked down by IP
address.
Bearing all the above, what is the most straightforward means of enabling
access via the OWC PivotTble control?
Thank you for help.does the XMLA virtual directory is hosted on the SSAS server himself or on
another HTTP server?
what is the security mode of the virtual directory? Anonymous, Basic, or
integrated security?
"craig_amtdatatechnologies@.discussions.mi"
< craigamtdatatechnologiesdiscussionsmi@.di
scussions.microsoft.com> wrote in
message news:075C02A4-F2FC-485C-BBFB-63B55EF261C8@.microsoft.com...
> Hi,
> We've been asked to enable an external client to access a cube via OWC.
> The idea is that if they play about with the cube through the PivotTable
> control, this will enable them to define their requirements for a
> reporting
> system to sit on top of the cube.
> I've read and implemented the contents of the following document:-
> - http://www.microsoft.com/technet/pr...5/httpasws.mspx
>
> I've installed OWC and the SQL data access components on a test machine,
> and
> have been trying to access the cube through a web-page hosting the pivot
> table control.
> Data access across domains is enabled in IE
> The error returned is "The query could not be processed: The HTTP server
> returned the following error: Forbidden."
> Obviosuly some security setting somewhere needs to be tweaked ... but
> which
> one :/
> Access to the web-page hosting the OWC control will be locked down by IP
> address.
> Bearing all the above, what is the most straightforward means of enabling
> access via the OWC PivotTble control?
>
> Thank you for help.
>
>

Office Web Components

Do the interactivity features of OWC client side exist with reporting
services?
Can we replace the work that we do now with OWC and lots of javascript with
RS?I've looked at trying to replicate the pivottable owc in reporting services
but rs just isn't for that, well not without a mega amount of programming.
What part of OWC are you using?
--
Tony Rogerson
SQL Server MVP
http://www.sqlserverfaq.com?mbr=21
(Create your own groups, Forum, FAQ's and a ton more)|||No, RS matrix and chart regions are not meant to replace OWC. As you would
understand it is difficult to implement the same functionality in HTML than
using ActiveX controls. However, you can integrate your OWC components to
run RS reports, e.g. when the lowest level in a dimension hierarchy is
reached.
One more thing. In RS OWC are used only when exporting the report to HTML
OWC format. When this happen, RS exports matrix regions as pivot tables,
charts as chart space objects. However, OWC is not linked to the data
source. Instead, the data is always restricted to the data that the report
query returns.
--
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/
---
"Mike B" <MikeB@.discussions.microsoft.com> wrote in message
news:D7C0A07C-527C-45AD-9ECE-614BBF123027@.microsoft.com...
> Do the interactivity features of OWC client side exist with reporting
> services?
> Can we replace the work that we do now with OWC and lots of javascript
with
> RS?

Office Web Component Pivottable functionality

I use the Office Web Component 2003 Pivottable in SharePoint but there are some bad behaviours.

- slow loading

- error messages like: An Error 0x0040200 occured

We use Reporting Services in most cases, but the positive aspects like Dynamic Dimensions and measure usage or Dynamic filtering in Hierarchies are to import to lose.

The Office Web Components are not developed anymore. In SharePoint Services 3.0 they can function, but it is not 100% the correct way. Does someone know the best way to use Pivottables in SharePoint Services 3.0?

Thnx

Hessel Appers

Hi,

I am using OWC 11 and it works perfectly for me,

although I am not using sharepoint, but have my own Asp.Net portal.

I am using OWC pivottables and pivotcharts.

OWC should be as fast as your BI studio/visual studio 2005 while loading/displaying or browsing a cube. (I believe)

because BI studio or Visual studio uses OWC.

If the performance is slower in both the cases, then it might be that you need to improve performance of your cube.

if the loading time is slower, try to display a filtered dataset or a higher level dataset,

the users can then drill down to the level required.

When using OWC, it is always better to show only the most required data and also the most minimum set.

This is because OWC is browser based, it would make IE take up a lot of memory,

and thus make IE slower, eventually your OWC component would also become slow with more data.

As an alternative to using OWC pivottables,

is to use the newer excel services (Microsoft Office 2005).

It jells best with sharepoint and is infact built to support sharepoint.

another alternative is to try other third party and free OLAP controls.

one free control that I can suggest is the "CellSetGrid".

The source code is also avaliable,

so you can look through it and make changes if required.

also the simple usage is pretty easy.

search for 'CellSetGrid' in google.

please do let me know,

how this comes, what you choose and what gave you best performance and features.

Regards

Office Move

My company located in Delware,is moving to a new office and I need to
keep our production database online by moving it onto servers in our
Las Vegas office. I'm looking for suggested ways to move the
databases
as seamlessly as possible to our Vegas office.
We conduct business Monday through Saturday. The way I understand the
move, after close of business on Saturday we want the data center to
be moved to Vegas and available on Monday morning, which doesn't
provide much time to get the db up and running.
We currently have our production database on an active/passive
cluster
running SQL 2005 with transactional replication in place to support
reporting for our enterprise application.
What options are available besides copying a backup across my WAN and
restoring the database?
What limitations are imposed by Log Shipping given the physical
distance betwen locations, etc.
If anyone can help point me in the proper direction I would greatly
appreciate the help.
NC3
Consider database mirroring. Once you have done the initial synch, then
just failover to the new site and dismantle the old one.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"NC3" <ncoleman3@.yahoo.com> wrote in message
news:cc76a479-5b61-41ba-8f5c-95e98883d924@.z17g2000hsg.googlegroups.com...
My company located in Delware,is moving to a new office and I need to
keep our production database online by moving it onto servers in our
Las Vegas office. I'm looking for suggested ways to move the
databases
as seamlessly as possible to our Vegas office.
We conduct business Monday through Saturday. The way I understand the
move, after close of business on Saturday we want the data center to
be moved to Vegas and available on Monday morning, which doesn't
provide much time to get the db up and running.
We currently have our production database on an active/passive
cluster
running SQL 2005 with transactional replication in place to support
reporting for our enterprise application.
What options are available besides copying a backup across my WAN and
restoring the database?
What limitations are imposed by Log Shipping given the physical
distance betwen locations, etc.
If anyone can help point me in the proper direction I would greatly
appreciate the help.
NC3
|||Hi
You don't say if the hardware is moving or not or if when it moves any
configuration changes will be made? If the kit is moving do you have
alternate kit as a backup in case of problems?
If you are moving to new/alternate kit then you can test the procedures
before hand so you will know if they are feasable or take too long. You
should also look at how you can minimise the actual work needed when you do
make the move, such as having everything in place and tested on a copy of the
database so there is only a more up-to-date version of the database to slot
in.
John
"NC3" wrote:

> My company located in Delware,is moving to a new office and I need to
> keep our production database online by moving it onto servers in our
> Las Vegas office. I'm looking for suggested ways to move the
> databases
> as seamlessly as possible to our Vegas office.
> We conduct business Monday through Saturday. The way I understand the
> move, after close of business on Saturday we want the data center to
> be moved to Vegas and available on Monday morning, which doesn't
> provide much time to get the db up and running.
>
> We currently have our production database on an active/passive
> cluster
> running SQL 2005 with transactional replication in place to support
> reporting for our enterprise application.
>
> What options are available besides copying a backup across my WAN and
> restoring the database?
>
> What limitations are imposed by Log Shipping given the physical
> distance betwen locations, etc.
>
> If anyone can help point me in the proper direction I would greatly
> appreciate the help.
>
> NC3
>
|||On Feb 20, 3:47Xpm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> Consider database mirroring. XOnce you have done the initial synch, then
> just failover to the new site and dismantle the old one.
> --
> X XTom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON X Canadahttps://mvp.support.microsoft.com/profile/Tom.Moreau
> "NC3" <ncolem...@.yahoo.com> wrote in message
> news:cc76a479-5b61-41ba-8f5c-95e98883d924@.z17g2000hsg.googlegroups.com...
> My company located in Delware,is moving to a new office and I need to
> keep our production database online by moving it onto servers in our
> Las Vegas office. I'm looking for suggested ways to move the
> databases
> as seamlessly as possible to our Vegas office.
> We conduct business Monday through Saturday. The way I understand the
> move, after close of business on Saturday we want the data center to
> be moved to Vegas and available on Monday morning, which doesn't
> provide much time to get the db up and running.
> We currently have our production database on an active/passive
> cluster
> running SQL 2005 with transactional replication in place to support
> reporting for our enterprise application.
> What options are available besides copying a backup across my WAN and
> restoring the database?
> What limitations are imposed by Log Shipping given the physical
> distance betwen locations, etc.
> If anyone can help point me in the proper direction I would greatly
> appreciate the help.
> NC3
How would Mirroring effect transactional replication and can I mirror
a SQL Cluster
|||Not sure about replication but you can mirror between clusters:
http://www.microsoft.com/technet/technetmag/issues/2007/03/sqlclusters/default.aspx?loc=en
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"NC3" <ncoleman3@.yahoo.com> wrote in message
news:833e7401-6825-4586-ae4a-b0a25de9b52f@.p25g2000hsf.googlegroups.com...
On Feb 20, 3:47 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> Consider database mirroring. Once you have done the initial synch, then
> just failover to the new site and dismantle the old one.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canadahttps://mvp.support.microsoft.com/profile/Tom.Moreau
> "NC3" <ncolem...@.yahoo.com> wrote in message
> news:cc76a479-5b61-41ba-8f5c-95e98883d924@.z17g2000hsg.googlegroups.com...
> My company located in Delware,is moving to a new office and I need to
> keep our production database online by moving it onto servers in our
> Las Vegas office. I'm looking for suggested ways to move the
> databases
> as seamlessly as possible to our Vegas office.
> We conduct business Monday through Saturday. The way I understand the
> move, after close of business on Saturday we want the data center to
> be moved to Vegas and available on Monday morning, which doesn't
> provide much time to get the db up and running.
> We currently have our production database on an active/passive
> cluster
> running SQL 2005 with transactional replication in place to support
> reporting for our enterprise application.
> What options are available besides copying a backup across my WAN and
> restoring the database?
> What limitations are imposed by Log Shipping given the physical
> distance betwen locations, etc.
> If anyone can help point me in the proper direction I would greatly
> appreciate the help.
> NC3
How would Mirroring effect transactional replication and can I mirror
a SQL Cluster
|||On Feb 21, 3:46Xpm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> Not sure about replication but you can mirror between clusters:
> http://www.microsoft.com/technet/technetmag/issues/2007/03/sqlcluster...
> --
> X XTom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON X Canadahttps://mvp.support.microsoft.com/profile/Tom.Moreau
> "NC3" <ncolem...@.yahoo.com> wrote in message
> news:833e7401-6825-4586-ae4a-b0a25de9b52f@.p25g2000hsf.googlegroups.com...
> On Feb 20, 3:47 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
>
>
>
>
>
>
>
>
> How would Mirroring effect transactional replication and can I mirror
> a SQL Cluster- Hide quoted text -
> - Show quoted text -
What do you thing of having 2 subscribers for the same publisher. Do
think that's something that might work?
|||Not sure what you mean. You can have as many subscribers to a publication
that you want.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"NC3" <ncoleman3@.yahoo.com> wrote in message
news:991ea951-2d8c-44bd-93e2-10871e6d4bce@.i7g2000prf.googlegroups.com...
On Feb 21, 3:46 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> Not sure about replication but you can mirror between clusters:
> http://www.microsoft.com/technet/technetmag/issues/2007/03/sqlcluster...
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canadahttps://mvp.support.microsoft.com/profile/Tom.Moreau
> "NC3" <ncolem...@.yahoo.com> wrote in message
> news:833e7401-6825-4586-ae4a-b0a25de9b52f@.p25g2000hsf.googlegroups.com...
> On Feb 20, 3:47 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
>
>
>
>
>
>
>
>
> How would Mirroring effect transactional replication and can I mirror
> a SQL Cluster- Hide quoted text -
> - Show quoted text -
What do you thing of having 2 subscribers for the same publisher. Do
think that's something that might work?

Office Move

My company located in Delware,is moving to a new office and I need to
keep our production database online by moving it onto servers in our
Las Vegas office. I'm looking for suggested ways to move the
databases
as seamlessly as possible to our Vegas office.
We conduct business Monday through Saturday. The way I understand the
move, after close of business on Saturday we want the data center to
be moved to Vegas and available on Monday morning, which doesn't
provide much time to get the db up and running.
We currently have our production database on an active/passive
cluster
running SQL 2005 with transactional replication in place to support
reporting for our enterprise application.
What options are available besides copying a backup across my WAN and
restoring the database?
What limitations are imposed by Log Shipping given the physical
distance betwen locations, etc.
If anyone can help point me in the proper direction I would greatly
appreciate the help.
NC3Consider database mirroring. Once you have done the initial synch, then
just failover to the new site and dismantle the old one.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"NC3" <ncoleman3@.yahoo.com> wrote in message
news:cc76a479-5b61-41ba-8f5c-95e98883d924@.z17g2000hsg.googlegroups.com...
My company located in Delware,is moving to a new office and I need to
keep our production database online by moving it onto servers in our
Las Vegas office. I'm looking for suggested ways to move the
databases
as seamlessly as possible to our Vegas office.
We conduct business Monday through Saturday. The way I understand the
move, after close of business on Saturday we want the data center to
be moved to Vegas and available on Monday morning, which doesn't
provide much time to get the db up and running.
We currently have our production database on an active/passive
cluster
running SQL 2005 with transactional replication in place to support
reporting for our enterprise application.
What options are available besides copying a backup across my WAN and
restoring the database?
What limitations are imposed by Log Shipping given the physical
distance betwen locations, etc.
If anyone can help point me in the proper direction I would greatly
appreciate the help.
NC3|||Hi
You don't say if the hardware is moving or not or if when it moves any
configuration changes will be made? If the kit is moving do you have
alternate kit as a backup in case of problems?
If you are moving to new/alternate kit then you can test the procedures
before hand so you will know if they are feasable or take too long. You
should also look at how you can minimise the actual work needed when you do
make the move, such as having everything in place and tested on a copy of the
database so there is only a more up-to-date version of the database to slot
in.
John
"NC3" wrote:
> My company located in Delware,is moving to a new office and I need to
> keep our production database online by moving it onto servers in our
> Las Vegas office. I'm looking for suggested ways to move the
> databases
> as seamlessly as possible to our Vegas office.
> We conduct business Monday through Saturday. The way I understand the
> move, after close of business on Saturday we want the data center to
> be moved to Vegas and available on Monday morning, which doesn't
> provide much time to get the db up and running.
>
> We currently have our production database on an active/passive
> cluster
> running SQL 2005 with transactional replication in place to support
> reporting for our enterprise application.
>
> What options are available besides copying a backup across my WAN and
> restoring the database?
>
> What limitations are imposed by Log Shipping given the physical
> distance betwen locations, etc.
>
> If anyone can help point me in the proper direction I would greatly
> appreciate the help.
>
> NC3
>|||On Feb 20, 3:47=A0pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> Consider database mirroring. =A0Once you have done the initial synch, then=
> just failover to the new site and dismantle the old one.
> --
> =A0 =A0Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON =A0 Canadahttps://mvp.support.microsoft.com/profile/Tom.Moreau=
> "NC3" <ncolem...@.yahoo.com> wrote in message
> news:cc76a479-5b61-41ba-8f5c-95e98883d924@.z17g2000hsg.googlegroups.com...
> My company located in Delware,is moving to a new office and I need to
> keep our production database online by moving it onto servers in our
> Las Vegas office. I'm looking for suggested ways to move the
> databases
> as seamlessly as possible to our Vegas office.
> We conduct business Monday through Saturday. The way I understand the
> move, after close of business on Saturday we want the data center to
> be moved to Vegas and available on Monday morning, which doesn't
> provide much time to get the db up and running.
> We currently have our production database on an active/passive
> cluster
> running SQL 2005 with transactional replication in place to support
> reporting for our enterprise application.
> What options are available besides copying a backup across my WAN and
> restoring the database?
> What limitations are imposed by Log Shipping given the physical
> distance betwen locations, etc.
> If anyone can help point me in the proper direction I would greatly
> appreciate the help.
> NC3
How would Mirroring effect transactional replication and can I mirror
a SQL Cluster|||Not sure about replication but you can mirror between clusters:
http://www.microsoft.com/technet/technetmag/issues/2007/03/sqlclusters/default.aspx?loc=en
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"NC3" <ncoleman3@.yahoo.com> wrote in message
news:833e7401-6825-4586-ae4a-b0a25de9b52f@.p25g2000hsf.googlegroups.com...
On Feb 20, 3:47 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> Consider database mirroring. Once you have done the initial synch, then
> just failover to the new site and dismantle the old one.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canadahttps://mvp.support.microsoft.com/profile/Tom.Moreau
> "NC3" <ncolem...@.yahoo.com> wrote in message
> news:cc76a479-5b61-41ba-8f5c-95e98883d924@.z17g2000hsg.googlegroups.com...
> My company located in Delware,is moving to a new office and I need to
> keep our production database online by moving it onto servers in our
> Las Vegas office. I'm looking for suggested ways to move the
> databases
> as seamlessly as possible to our Vegas office.
> We conduct business Monday through Saturday. The way I understand the
> move, after close of business on Saturday we want the data center to
> be moved to Vegas and available on Monday morning, which doesn't
> provide much time to get the db up and running.
> We currently have our production database on an active/passive
> cluster
> running SQL 2005 with transactional replication in place to support
> reporting for our enterprise application.
> What options are available besides copying a backup across my WAN and
> restoring the database?
> What limitations are imposed by Log Shipping given the physical
> distance betwen locations, etc.
> If anyone can help point me in the proper direction I would greatly
> appreciate the help.
> NC3
How would Mirroring effect transactional replication and can I mirror
a SQL Cluster|||On Feb 21, 3:46=A0pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> Not sure about replication but you can mirror between clusters:
> http://www.microsoft.com/technet/technetmag/issues/2007/03/sqlcluster...
> --
> =A0 =A0Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON =A0 Canadahttps://mvp.support.microsoft.com/profile/Tom.Moreau=
> "NC3" <ncolem...@.yahoo.com> wrote in message
> news:833e7401-6825-4586-ae4a-b0a25de9b52f@.p25g2000hsf.googlegroups.com...
> On Feb 20, 3:47 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
>
>
> > Consider database mirroring. Once you have done the initial synch, then
> > just failover to the new site and dismantle the old one.
> > --
> > Tom
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON Canadahttps://mvp.support.microsoft.com/profile/Tom.Moreau
> > "NC3" <ncolem...@.yahoo.com> wrote in message
> >news:cc76a479-5b61-41ba-8f5c-95e98883d924@.z17g2000hsg.googlegroups.com...=
> > My company located in Delware,is moving to a new office and I need to
> > keep our production database online by moving it onto servers in our
> > Las Vegas office. I'm looking for suggested ways to move the
> > databases
> > as seamlessly as possible to our Vegas office.
> > We conduct business Monday through Saturday. The way I understand the
> > move, after close of business on Saturday we want the data center to
> > be moved to Vegas and available on Monday morning, which doesn't
> > provide much time to get the db up and running.
> > We currently have our production database on an active/passive
> > cluster
> > running SQL 2005 with transactional replication in place to support
> > reporting for our enterprise application.
> > What options are available besides copying a backup across my WAN and
> > restoring the database?
> > What limitations are imposed by Log Shipping given the physical
> > distance betwen locations, etc.
> > If anyone can help point me in the proper direction I would greatly
> > appreciate the help.
> > NC3
> How would Mirroring effect transactional replication and can I mirror
> a SQL Cluster- Hide quoted text -
> - Show quoted text -
What do you thing of having 2 subscribers for the same publisher. Do
think that's something that might work?|||Not sure what you mean. You can have as many subscribers to a publication
that you want.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"NC3" <ncoleman3@.yahoo.com> wrote in message
news:991ea951-2d8c-44bd-93e2-10871e6d4bce@.i7g2000prf.googlegroups.com...
On Feb 21, 3:46 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> Not sure about replication but you can mirror between clusters:
> http://www.microsoft.com/technet/technetmag/issues/2007/03/sqlcluster...
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canadahttps://mvp.support.microsoft.com/profile/Tom.Moreau
> "NC3" <ncolem...@.yahoo.com> wrote in message
> news:833e7401-6825-4586-ae4a-b0a25de9b52f@.p25g2000hsf.googlegroups.com...
> On Feb 20, 3:47 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
>
>
> > Consider database mirroring. Once you have done the initial synch, then
> > just failover to the new site and dismantle the old one.
> > --
> > Tom
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON Canadahttps://mvp.support.microsoft.com/profile/Tom.Moreau
> > "NC3" <ncolem...@.yahoo.com> wrote in message
> >news:cc76a479-5b61-41ba-8f5c-95e98883d924@.z17g2000hsg.googlegroups.com...
> > My company located in Delware,is moving to a new office and I need to
> > keep our production database online by moving it onto servers in our
> > Las Vegas office. I'm looking for suggested ways to move the
> > databases
> > as seamlessly as possible to our Vegas office.
> > We conduct business Monday through Saturday. The way I understand the
> > move, after close of business on Saturday we want the data center to
> > be moved to Vegas and available on Monday morning, which doesn't
> > provide much time to get the db up and running.
> > We currently have our production database on an active/passive
> > cluster
> > running SQL 2005 with transactional replication in place to support
> > reporting for our enterprise application.
> > What options are available besides copying a backup across my WAN and
> > restoring the database?
> > What limitations are imposed by Log Shipping given the physical
> > distance betwen locations, etc.
> > If anyone can help point me in the proper direction I would greatly
> > appreciate the help.
> > NC3
> How would Mirroring effect transactional replication and can I mirror
> a SQL Cluster- Hide quoted text -
> - Show quoted text -
What do you thing of having 2 subscribers for the same publisher. Do
think that's something that might work?sql

Office Interop Assemblies and SSIS

Hi guys,

I'm trying to write an SSIS script that will create an excel file and append data to it.

I downloaded the Office 2007 PIAs (Primary Interop Assemblies) and installed them on my desktop PC where i'm developing from.

However, and even though the assemblies are in the GAC, they don't appear when you look in "Add Reference" for your script task.

If i create a standard .NET web or windows app and try to "Add Reference" I can find them there.

Am I missing anything obvious?

Thanks for your help in advance

Mike

Do you have the Visual Studio Tools for Office 2007 installed?

Just curious, why create the excel file in the script task?

|||

Mike_Gaziotis wrote:

Hi guys,

I'm trying to write an SSIS script that will create an excel file and append data to it.

I downloaded the Office 2007 PIAs (Primary Interop Assemblies) and installed them on my desktop PC where i'm developing from.

However, and even though the assemblies are in the GAC, they don't appear when you look in "Add Reference" for your script task.

If i create a standard .NET web or windows app and try to "Add Reference" I can find them there.

Am I missing anything obvious?

Thanks for your help in advance

Mike

This should help.

VSA requires DLLs to be in the Microsoft.Net folder (but not all the time)

(http://blogs.conchango.com/jamiethomson/archive/2005/11/02/SSIS_3A00_-VSA-requires-DLLs-to-be-in-the-Microsoft.Net-folder-_2800_but-not-all-the-time_2900_.aspx)

-Jamie

|||

The VSA designer's "Add Reference" dialog does not look for assemblies in the GAC but only in the %ProgramFiles%\Microsoft SQL Server\90\SDK\Assemblies and %windir%\Microsoft.NET\Framework\v2.0.50727

We recomend that you copy them to the SQL server location pointed above for the "Add Reference" to work.

|||Thanks very much Jamie and Silviu!
Putting the DLLs in the .NET Folder seems to have done the trick.

In response to jwelch's question: I would have used the standard Data Flow task but it didn't seem to support some of the functionality i needed (ie dynamically building the file path and file name based on content etc)

Thanks again guys

Mike
|||

Actually, that sounds like a great opportunity to use variables or expressions. If you describe your scenario a little more, perhaps there might be some alternative approaches.

Not trying to change your mind on direction, just want to make sure you know what options are available.

|||Hi Jwelch,

Always keen to find out if there are more approaches that i haven't considered. Even if they're not used in this scenario it's good to know of the possibilites

Here are my SSIS job requirements:
- Execute (several) SQL queries which retrieve report data
- Insert the data in worksheets of several excel files
- Save the files by:
a: Putting a timestapt in their name (ie reportA_04072007)
b: storing them in different locations on the server based on the report
(ie %Reports%/ReportA/reportA_04072007.xls)
- Send mails with excel files attached

This is to be a scheduled job managed by the SQL server agent.

It's not a job of enormous complexity i must admit, but i somehow i found myself (perhaps because of me being a developer rather than a DBA by nature) more keen to write code than having to use loops, data flow tasks and all the rest. In fact when i first had the problem with the assemblies i half considered writing a windows app that would do that job and then run that from the sql server agent. And really, is there such a big difference between writing an app or a script-only SSIS job?

Thanks and sorry for the babble
Mike

Office Document Properties

If I use the Indexing Services built into the OS, I can query the office
doc properties (title, author etc).
Is it possible to do this if I have an office doc stored in an Image field
that is full-text indexed ?
Steve
It is possible in SQL 2005 - however you can't query for a specific
properties' value. IE I could not query to see if the DocAuthor property was
SteveW, but rather I could query to see if SteveW occurred in the content or
any of the document properties.
AS you are familiar with indexing Services the analog is the ALL property.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Steve W" <BunnyBoy123@.community.nospam> wrote in message
news:enEwUtxBGHA.3792@.TK2MSFTNGP10.phx.gbl...
> If I use the Indexing Services built into the OS, I can query the office
> doc properties (title, author etc).
> Is it possible to do this if I have an office doc stored in an Image field
> that is full-text indexed ?
> Steve
>

Office and Adobe Compatibiiltly

SQL Server Reporting Services can export to Excel and Adobe. Which versions
of these products are supported?for rs 2005
pdf is 1.3
i have tested xls only on Offce 2003 and above
"Dave" wrote:
> SQL Server Reporting Services can export to Excel and Adobe. Which versions
> of these products are supported?|||Actually, the Adobe version supported is 4.x and above. For Excel, it's what
they call the 97-2003 .xls format in Excel 2007 (which works fine in Excel
2007, btw).
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Jimbo" <Jimbo@.discussions.microsoft.com> wrote in message
news:744AC534-34CF-4EC5-8518-95C41E29E617@.microsoft.com...
> for rs 2005
> pdf is 1.3
> i have tested xls only on Offce 2003 and above
>
>
>
> "Dave" wrote:
>> SQL Server Reporting Services can export to Excel and Adobe. Which
>> versions
>> of these products are supported?|||Hi Alain,
Yes, you are right. I just would like to clarify that although PDF 1.3 is
compatible with Adobe Acrobat 4, Reporting Services supports Adobe Acrobat
6 or later.
You can refer to:
Designing for PDF Output
http://msdn2.microsoft.com/en-us/library/ms159713.aspx
Exporting Reports (Reporting Services)
http://msdn2.microsoft.com/en-us/library/ms157153(SQL.100).aspx
Thank you and have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@.microsoft.com.
===========================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================|||Great stuff. Thanks all!
"Charles Wang[MSFT]" wrote:
> Hi Alain,
> Yes, you are right. I just would like to clarify that although PDF 1.3 is
> compatible with Adobe Acrobat 4, Reporting Services supports Adobe Acrobat
> 6 or later.
> You can refer to:
> Designing for PDF Output
> http://msdn2.microsoft.com/en-us/library/ms159713.aspx
> Exporting Reports (Reporting Services)
> http://msdn2.microsoft.com/en-us/library/ms157153(SQL.100).aspx
> Thank you and have a nice day!
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ===========================================================> Delighting our customers is our #1 priority. We welcome your
> comments and suggestions about how we can improve the
> support we provide to you. Please feel free to let my manager
> know what you think of the level of service provided. You can
> send feedback directly to my manager at: msdnmg@.microsoft.com.
> ===========================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for
> non-urgent issues where an initial response from the community
> or a Microsoft Support Engineer within 1 business day is acceptable.
> Please note that each follow up response may take approximately
> 2 business days as the support professional working with you may
> need further investigation to reach the most efficient resolution.
> The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by
> contacting Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ============================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> =========================================================>

Office 2003 Web Service Reference Tool fails on ReportingService

I am trying to add a web reference to an Access 2003 database form using the
latest version of the Web Services Toolkit. When I try to add the reference
it runs for a while and then blows up with the following message.
Cannot Create Class.
The Web Service References Tool could not generate the requested code. Any
changes that were made to your project have been rolled back.
Any help would be appreciated.this newsgroup is for SQL Server Reporting Services. You will get better
responses if you post this in one of the Access newsgroups.
"TMesich" <TMesich@.discussions.microsoft.com> wrote in message
news:6EB2929F-C179-4348-B931-E15451985189@.microsoft.com...
>I am trying to add a web reference to an Access 2003 database form using
>the
> latest version of the Web Services Toolkit. When I try to add the
> reference
> it runs for a while and then blows up with the following message.
> Cannot Create Class.
> The Web Service References Tool could not generate the requested code.
> Any
> changes that were made to your project have been rolled back.
> Any help would be appreciated.

Odd SQL IN usage?

Hi guys,

Got an odd SQL string that I need to produce that is most probably simple to
construct but with it being hot in our office, I simply can't get my head
around it...!!

Its based around an online emailing facility whereby multiple hotels can be
emailed via a single application. Users within the application have access
rights to email only specific hotels.

The tables are laid out like this (irrelevant columns left out)...

CampaignID, CampaignName, CampaignHotelIDs
1 Test Campaign 1,4,5,7,9
2 Test Campaign2 1,2

UserID, UserName, UserHotelIDAccess
1 Test User 1,6,7
2 Test User 2,7

Now on the stats page I want to give users access to view ONLY sent
campaigns to which they have access to view, I was considering the IN SQL
statement to achieve something like this...

'WHERE CampaignHotelIDs IN UserHotelIDAcess'

...but that doesn't want to work, can anyone give me any ideas to get this
working within just a single SQL query?

Cheers, @.sh@.sh wrote:

Quote:

Originally Posted by

Hi guys,
>
Got an odd SQL string that I need to produce that is most probably simple to
construct but with it being hot in our office, I simply can't get my head
around it...!!
>
Its based around an online emailing facility whereby multiple hotels can be
emailed via a single application. Users within the application have access
rights to email only specific hotels.
>
The tables are laid out like this (irrelevant columns left out)...
>
CampaignID, CampaignName, CampaignHotelIDs
1 Test Campaign 1,4,5,7,9
2 Test Campaign2 1,2
>
UserID, UserName, UserHotelIDAccess
1 Test User 1,6,7
2 Test User 2,7
>
Now on the stats page I want to give users access to view ONLY sent
campaigns to which they have access to view, I was considering the IN SQL
statement to achieve something like this...
>
'WHERE CampaignHotelIDs IN UserHotelIDAcess'
>
...but that doesn't want to work, can anyone give me any ideas to get this
working within just a single SQL query?

--BEGIN PGP SIGNED MESSAGE--
Hash: SHA1

Your columns "UserHotelIDAccess" and "CampaignHotelIDs" are in violation
of 1NF (First Normal Form) "A cell must be atomic." I.e., there must
only be one item per column. If your data was like this:

CampaignID, CampaignName, CampaignHotelIDs
1 Test Campaign 1
1 Test Campaign 4
1 Test Campaign 5
1 Test Campaign 7
1 Test Campaign 9
2 Test Campaign2 1
2 Test Campaign2 2

UserID, UserName, UserHotelIDAccess
1 Test User 1
1 Test User 6
1 Test User 7
2 Test User 2
2 Test User 7

Your WHERE clause would work like this:

WHERE CampaignHotelIDs = UserHotelIDAccess
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)

--BEGIN PGP SIGNATURE--
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRK15H4echKqOuFEgEQJqNgCePdnBVao0mJq2YSFXG/GubalXfhMAoNRY
UlESaxNSeKctgZhjJ5pZ1UFV
=kzX+
--END PGP SIGNATURE--|||@.sh (spam@.spam.com) writes:

Quote:

Originally Posted by

Got an odd SQL string that I need to produce that is most probably
simple to construct but with it being hot in our office, I simply can't
get my head around it...!!

It must also have been hot in the office when this was desiged:

Quote:

Originally Posted by

CampaignID, CampaignName, CampaignHotelIDs
1 Test Campaign 1,4,5,7,9
2 Test Campaign2 1,2
>
UserID, UserName, UserHotelIDAccess
1 Test User 1,6,7
2 Test User 2,7

If you are on SQL 2000, this is very painful to work with. If you are on
SQL 2005, it's slightly less painful.

Before I go, which version of SQL Server do you actually have?

--
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|||Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, data types, etc. in
your schema are. Sample data is also a good idea, along with clear
specifications. It is very hard to debug code when you do not let us
see it.

You can immediately improve your database by not allowing the moron
that crammed everything into a single column to write code until he can
explain Normal Forms. I would also inspect everything he has done and
pull it out. That kind of fundamental error tells you what kind of
programmer you have.|||Thanks for your reply, I see what you're suggesting but its too late to
change the overall structure of the table now ;o(

"MGFoster" <me@.privacy.comwrote in message
news:tOerg.596$vO.300@.newsread4.news.pas.earthlink .net...

Quote:

Originally Posted by

>
Your columns "UserHotelIDAccess" and "CampaignHotelIDs" are in violation
of 1NF (First Normal Form) "A cell must be atomic." I.e., there must
only be one item per column. If your data was like this:
>
CampaignID, CampaignName, CampaignHotelIDs
1 Test Campaign 1
1 Test Campaign 4
1 Test Campaign 5
1 Test Campaign 7
1 Test Campaign 9
2 Test Campaign2 1
2 Test Campaign2 2
>
UserID, UserName, UserHotelIDAccess
1 Test User 1
1 Test User 6
1 Test User 7
2 Test User 2
2 Test User 7
>
Your WHERE clause would work like this:
>
WHERE CampaignHotelIDs = UserHotelIDAccess
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
>
--BEGIN PGP SIGNATURE--
Version: PGP for Personal Privacy 5.0
Charset: noconv
>
iQA/AwUBRK15H4echKqOuFEgEQJqNgCePdnBVao0mJq2YSFXG/GubalXfhMAoNRY
UlESaxNSeKctgZhjJ5pZ1UFV
=kzX+
--END PGP SIGNATURE--

|||"Erland Sommarskog" <esquel@.sommarskog.sewrote in message

Quote:

Originally Posted by

news:Xns97F91FCEE7C9Yazorman@.127.0.0.1...
It must also have been hot in the office when this was desiged:

Well it seemed a good idea at the time, and infact works within the
application itself brilliantly and efficiently without numerous hits on the
DB - however this one element now is proving tricky

We're using SQL 7 so based on what you've said, I guess you can't help ;o)

Cheers, @.sh|||On Fri, 7 Jul 2006 10:46:12 +0100, @.sh wrote:

Quote:

Originally Posted by

Quote:

Originally Posted by

>"Erland Sommarskog" <esquel@.sommarskog.sewrote in message
>news:Xns97F91FCEE7C9Yazorman@.127.0.0.1...
>It must also have been hot in the office when this was desiged:

>
>Well it seemed a good idea at the time, and infact works within the
>application itself brilliantly and efficiently without numerous hits on the
>DB - however this one element now is proving tricky
>
>We're using SQL 7 so based on what you've said, I guess you can't help ;o)

Hi @.sh,

Oh, Erland certainly can help you. Just check out his site:
http://www.sommarskog.se/arrays-in-sql.html#SQL7
--
Hugo Kornelis, SQL Server MVP|||@.sh (spam@.spam.com) writes:

Quote:

Originally Posted by

Quote:

Originally Posted by

>"Erland Sommarskog" <esquel@.sommarskog.sewrote in message
>news:Xns97F91FCEE7C9Yazorman@.127.0.0.1...
>It must also have been hot in the office when this was desiged:

>
Well it seemed a good idea at the time, and infact works within the
application itself brilliantly and efficiently without numerous hits on
the DB - however this one element now is proving tricky
>
We're using SQL 7 so based on what you've said, I guess you can't help
;o)

SQL 7? That will not make it even less painful. :-)

There are two approaches. One is to run a cursor over the rows and
for each row call a stored procedure that unpacks the row into a
table, so that you can run the queries the proper way. You can find
examples of such procedures on my web site:
http://www.sommarskog.se/arrays-in-sql.html#SQL7.

I would in such case such suggest that you put this code in the trigger
on this table, so that you always can work on properly desinged tables.
Overall, you should strive of changing the database design to move away
from this structure. Yes, I see that you in other post said that it's
too late to change the design, but I disagree. Unless the product already
has a declared end of life, it's never too late to change a flat-out
incorrect design like this one.

The other approach is a query similar to:

WHERE ',' + UserHotelIDAcess + ',' LIKE
'%,' + CampaignHotelIDs + ',%'

This theme has some variations, see
http://www.sommarskog.se/arrays-in-sql.html#realslow. All of them are
painfully slow, and could prove unworkable if your data has any volumes.

--
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