OLAP connection problems

I have two systems setup with SQL Server 2000 + Analysis Services. Both servers have been patched with both SP3a patches.

I wrote a trivial command line app that tests connection strings through ADO.

On each system, I can connect locally perfectly using the connection string:
"Provider=MSOLAP;Data Source=localhost;Initial Catalog=FoodMart 2000"

However, once I change "Data Source" to refer to the other system, the call to ADODB.Connection.Open throws a "System.Runtime.InteropServices.COMException" with message: "Unspecified error". (The simple app is written in C# and talks to ADO through Interop)

I've tried referencing ADO 2.1, ADO 2.5 and ADO 2.7
I've tried a "Provider" of "MSOLAP.2" as well as just "MSOLAP"
I've also tried a variety of different connection strings with many different permissions settings.

It is very frustrating to get an absolutely generic error message.

Any ideas?

Thanks in advance!Have you tried adding "User ID=xxx;Password=xxx"

or

"Integrated Security=SSPI"|||Yes, just retried all of them and they all result in the same System.Runtime.InteropServices.COMException, "Unspecified error"

adomdtest "Provider=MSOLAP;Data Source=localhost;Initial Catalog=FoodMart 2000"
adomdtest "Provider=MSOLAP;Data Source=192.168.128.53;Initial Catalog=FoodMart 2000"
adomdtest "Provider=MSOLAP;Data Source=192.168.128.53;Integrated Security=SSPI;Initial Catalog=FoodMart 2000"
adomdtest "Provider=MSOLAP;Data Source=192.168.128.53;User Id=sa;Password=xxxx;Initial Catalog=FoodMart 2000"|||Let me reclarify. This one works fine:

adomdtest "Provider=MSOLAP;Data Source=localhost;Initial Catalog=FoodMart 2000"

These (that reference another system) fail with System.Runtime.InteropServices.COMException, "Unspecified error":

adomdtest "Provider=MSOLAP;Data Source=192.168.128.53;Initial Catalog=FoodMart 2000"
adomdtest "Provider=MSOLAP;Data Source=192.168.128.53;Integrated Security=SSPI;Initial Catalog=FoodMart 2000"
adomdtest "Provider=MSOLAP;Data Source=192.168.128.53;User Id=sa;Password=xxxx;Initial Catalog=FoodMart 2000"

I experience the same effect from two systems; either system can open its own database but can't open a remote one.|||Can't think of anything here...Maybe these links can give you some ideas?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/agtroubleshoot_8wfm.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/agtroubleshoot_64fb.asp

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

OFF TOPIC: weld in servers room

hi
--really off topic--
tomorrow will arrive a tecnician
to change the SERVER's ROOM air conditioner
he need to weld metals on the window
the concern is about the integrity
of the electronic components
since the weld machine creates an "electric arc"
should we shutdown servers
and move them to another place ?
how much distance must be there
between the weld machine and servers
to weld relatively safe ?
how much distance from the electrode and equipment ?
really off topic, yes
atte,
Hernn
On Wed, 14 Feb 2007 10:18:45 -0300, "bajopalabra"
<bajopalabra@.hotmail.com> wrote:

>hi
>--really off topic--
>tomorrow will arrive a tecnician
>to change the SERVER's ROOM air conditioner
>he need to weld metals on the window
>the concern is about the integrity
>of the electronic components
>since the weld machine creates an "electric arc"
>should we shutdown servers
>and move them to another place ?
>how much distance must be there
>between the weld machine and servers
>to weld relatively safe ?
>how much distance from the electrode and equipment ?
>really off topic, yes
If your servers are on a filtered power supply, properly installed in
racks, your equipment ground is good, and the welder plugs into a
separate circuit, things should be fine. I don't think the broadcast
EMF is a problem, the surge on the power line might be. If there's
even a foot or two between the arc and the servers, should be OK.
Won't help if he spatters hot metal all over things, though, or throws
a tarp over the servers so they overheat!
J.
|||thank you JX
i'll take care of that
"JXStern" <JXSternChangeX2R@.gte.net> escribi en el mensaje
news:g756t25vh4sf7n1cmjqkdfaft17d8udf7i@.4ax.com...
| On Wed, 14 Feb 2007 10:18:45 -0300, "bajopalabra"
| <bajopalabra@.hotmail.com> wrote:
|
| >hi
| >--really off topic--
| >tomorrow will arrive a tecnician
| >to change the SERVER's ROOM air conditioner
| >he need to weld metals on the window
| >
| >the concern is about the integrity
| >of the electronic components
| >since the weld machine creates an "electric arc"
| >
| >should we shutdown servers
| >and move them to another place ?
| >
| >how much distance must be there
| >between the weld machine and servers
| >to weld relatively safe ?
| >how much distance from the electrode and equipment ?
| >
| >really off topic, yes
|
| If your servers are on a filtered power supply, properly installed in
| racks, your equipment ground is good, and the welder plugs into a
| separate circuit, things should be fine. I don't think the broadcast
| EMF is a problem, the surge on the power line might be. If there's
| even a foot or two between the arc and the servers, should be OK.
|
| Won't help if he spatters hot metal all over things, though, or throws
| a tarp over the servers so they overheat!
|
| J.
|
sql

OFF TOPIC: weld in servers room

hi
--really off topic--
tomorrow will arrive a tecnician
to change the SERVER's ROOM air conditioner
he need to weld metals on the window
the concern is about the integrity
of the electronic components
since the weld machine creates an "electric arc"
should we shutdown servers
and move them to another place ?
how much distance must be there
between the weld machine and servers
to weld relatively safe ?
how much distance from the electrode and equipment ?
really off topic, yes
atte,
HernnOn Wed, 14 Feb 2007 10:18:45 -0300, "bajopalabra"
<bajopalabra@.hotmail.com> wrote:

>hi
>--really off topic--
>tomorrow will arrive a tecnician
>to change the SERVER's ROOM air conditioner
>he need to weld metals on the window
>the concern is about the integrity
>of the electronic components
>since the weld machine creates an "electric arc"
>should we shutdown servers
>and move them to another place ?
>how much distance must be there
>between the weld machine and servers
>to weld relatively safe ?
>how much distance from the electrode and equipment ?
>really off topic, yes
If your servers are on a filtered power supply, properly installed in
racks, your equipment ground is good, and the welder plugs into a
separate circuit, things should be fine. I don't think the broadcast
EMF is a problem, the surge on the power line might be. If there's
even a foot or two between the arc and the servers, should be OK.
Won't help if he spatters hot metal all over things, though, or throws
a tarp over the servers so they overheat!
J.|||thank you JX
i'll take care of that
"JXStern" <JXSternChangeX2R@.gte.net> escribi en el mensaje
news:g756t25vh4sf7n1cmjqkdfaft17d8udf7i@.
4ax.com...
| On Wed, 14 Feb 2007 10:18:45 -0300, "bajopalabra"
| <bajopalabra@.hotmail.com> wrote:
|
| >hi
| >--really off topic--
| >tomorrow will arrive a tecnician
| >to change the SERVER's ROOM air conditioner
| >he need to weld metals on the window
| >
| >the concern is about the integrity
| >of the electronic components
| >since the weld machine creates an "electric arc"
| >
| >should we shutdown servers
| >and move them to another place ?
| >
| >how much distance must be there
| >between the weld machine and servers
| >to weld relatively safe ?
| >how much distance from the electrode and equipment ?
| >
| >really off topic, yes
|
| If your servers are on a filtered power supply, properly installed in
| racks, your equipment ground is good, and the welder plugs into a
| separate circuit, things should be fine. I don't think the broadcast
| EMF is a problem, the surge on the power line might be. If there's
| even a foot or two between the arc and the servers, should be OK.
|
| Won't help if he spatters hot metal all over things, though, or throws
| a tarp over the servers so they overheat!
|
| J.
|

OFF TOPIC: weld in servers room

hi
--really off topic--
tomorrow will arrive a tecnician
to change the SERVER's ROOM air conditioner
he need to weld metals on the window
the concern is about the integrity
of the electronic components
since the weld machine creates an "electric arc"
should we shutdown servers
and move them to another place ?
how much distance must be there
between the weld machine and servers
to weld relatively safe ?
how much distance from the electrode and equipment ?
really off topic, yes
--
atte,
HernánOn Wed, 14 Feb 2007 10:18:45 -0300, "bajopalabra"
<bajopalabra@.hotmail.com> wrote:
>hi
>--really off topic--
>tomorrow will arrive a tecnician
>to change the SERVER's ROOM air conditioner
>he need to weld metals on the window
>the concern is about the integrity
>of the electronic components
>since the weld machine creates an "electric arc"
>should we shutdown servers
>and move them to another place ?
>how much distance must be there
>between the weld machine and servers
>to weld relatively safe ?
>how much distance from the electrode and equipment ?
>really off topic, yes
If your servers are on a filtered power supply, properly installed in
racks, your equipment ground is good, and the welder plugs into a
separate circuit, things should be fine. I don't think the broadcast
EMF is a problem, the surge on the power line might be. If there's
even a foot or two between the arc and the servers, should be OK.
Won't help if he spatters hot metal all over things, though, or throws
a tarp over the servers so they overheat!
J.|||thank you JX
i'll take care of that
"JXStern" <JXSternChangeX2R@.gte.net> escribió en el mensaje
news:g756t25vh4sf7n1cmjqkdfaft17d8udf7i@.4ax.com...
| On Wed, 14 Feb 2007 10:18:45 -0300, "bajopalabra"
| <bajopalabra@.hotmail.com> wrote:
|
| >hi
| >--really off topic--
| >tomorrow will arrive a tecnician
| >to change the SERVER's ROOM air conditioner
| >he need to weld metals on the window
| >
| >the concern is about the integrity
| >of the electronic components
| >since the weld machine creates an "electric arc"
| >
| >should we shutdown servers
| >and move them to another place ?
| >
| >how much distance must be there
| >between the weld machine and servers
| >to weld relatively safe ?
| >how much distance from the electrode and equipment ?
| >
| >really off topic, yes
|
| If your servers are on a filtered power supply, properly installed in
| racks, your equipment ground is good, and the welder plugs into a
| separate circuit, things should be fine. I don't think the broadcast
| EMF is a problem, the surge on the power line might be. If there's
| even a foot or two between the arc and the servers, should be OK.
|
| Won't help if he spatters hot metal all over things, though, or throws
| a tarp over the servers so they overheat!
|
| J.
|

Off Site Backup Server

We are in the process of setting up an Off Site backup Server. Our
production Server is currently Window Servers 2003 with TS, and we will be
using DFS to duplicate the data on the other Server. Both Servers will be
running GoldMine and SQL Server 2000. The queston is, will we be able to use
the same SQL Server License for replication on the other Server or would we
have to purchase a seperate License?
Kent Williamson
IT Specialist
No, if you are using DFS to replicate your data files to the standby server
(or Double Take or log shipping) you do not need a SQL Server license on the
standby server as long as the standby server is not actively running SQL
Server and serving clients, and both servers will not be serving clients at
the same time. If you are using SQL Server replication to do this you will.
Note that I would be careful about using DFS to replicated your live
database files.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"K_Willy" <KWilly@.discussions.microsoft.com> wrote in message
news:D1B6F160-9E62-4E90-B3E9-3F5E8922D45C@.microsoft.com...
> We are in the process of setting up an Off Site backup Server. Our
> production Server is currently Window Servers 2003 with TS, and we will be
> using DFS to duplicate the data on the other Server. Both Servers will be
> running GoldMine and SQL Server 2000. The queston is, will we be able to
> use
> the same SQL Server License for replication on the other Server or would
> we
> have to purchase a seperate License?
> --
> Kent Williamson
> IT Specialist
sql

Odd query problem

All,
Sql 2000, sp3, Server 2000 sp4
I have 2 servers, a production and a warm standby that I
use for some reporting. The problem I am having is that on
my production server, execution plan is showing a 55% use
for a sort. That same sort is not on the standby server.
The standby completes queries in 10% of the time on
production. They are not identical servers, my production
is a much faster machine. This problem has just started in
the last week. I have done update statistics for all the
tables in the db. I do indexdefrags about once a month, my
db is 350 gbs in size. There is one table that I have not
touched at all yet, there are 1.5 billion rows in this
table. Any other ideas, before I tackle this table.
Interesting note, if I do a select top 100 on production
the ep is similar to the one on my standby. Any reasons?
Thanks in advance all,
Gary AbbottProbably due to other load and use on your production server. You can try
clearing data and procedure cache on the production box (NOTE: This may
cause a severe performance bottleneck if your server is experiencing any
kind of load. Do this during way-off-peak hours only).
To clear data cache: DBCC DROPCLEANBUFFERS
To clear procedure cache: DBCC FREEPROCCACHE
If you are comparing query performance on two different systems, this is the
only way to make sure current cache state doesn't overly influience the
outcomes.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Gary Abbott" <anonymous@.discussions.microsoft.com> wrote in message
news:ed1901c3f0c0$0fe1f700$a501280a@.phx.gbl...
> All,
> Sql 2000, sp3, Server 2000 sp4
> I have 2 servers, a production and a warm standby that I
> use for some reporting. The problem I am having is that on
> my production server, execution plan is showing a 55% use
> for a sort. That same sort is not on the standby server.
> The standby completes queries in 10% of the time on
> production. They are not identical servers, my production
> is a much faster machine. This problem has just started in
> the last week. I have done update statistics for all the
> tables in the db. I do indexdefrags about once a month, my
> db is 350 gbs in size. There is one table that I have not
> touched at all yet, there are 1.5 billion rows in this
> table. Any other ideas, before I tackle this table.
> Interesting note, if I do a select top 100 on production
> the ep is similar to the one on my standby. Any reasons?
> Thanks in advance all,
> Gary Abbott|||you need to provide more info on the query, relevent
indexes in each db, and the execution plan details,
if there is a difference in the execution plan, then
either one has difference indexes or the statistics are
different, what does the execution plan show for estimated
row count in each case?
>--Original Message--
>All,
>Sql 2000, sp3, Server 2000 sp4
>I have 2 servers, a production and a warm standby that I
>use for some reporting. The problem I am having is that
on
>my production server, execution plan is showing a 55% use
>for a sort. That same sort is not on the standby server.
>The standby completes queries in 10% of the time on
>production. They are not identical servers, my production
>is a much faster machine. This problem has just started
in
>the last week. I have done update statistics for all the
>tables in the db. I do indexdefrags about once a month,
my
>db is 350 gbs in size. There is one table that I have not
>touched at all yet, there are 1.5 billion rows in this
>table. Any other ideas, before I tackle this table.
>Interesting note, if I do a select top 100 on production
>the ep is similar to the one on my standby. Any reasons?
>Thanks in advance all,
>Gary Abbott
>.
>

Odd query problem

All,
Sql 2000, sp3, Server 2000 sp4
I have 2 servers, a production and a warm standby that I
use for some reporting. The problem I am having is that on
my production server, execution plan is showing a 55% use
for a sort. That same sort is not on the standby server.
The standby completes queries in 10% of the time on
production. They are not identical servers, my production
is a much faster machine. This problem has just started in
the last week. I have done update statistics for all the
tables in the db. I do indexdefrags about once a month, my
db is 350 gbs in size. There is one table that I have not
touched at all yet, there are 1.5 billion rows in this
table. Any other ideas, before I tackle this table.
Interesting note, if I do a select top 100 on production
the ep is similar to the one on my standby. Any reasons?
Thanks in advance all,
Gary AbbottProbably due to other load and use on your production server. You can try
clearing data and procedure cache on the production box (NOTE: This may
cause a severe performance bottleneck if your server is experiencing any
kind of load. Do this during way-off-peak hours only).
To clear data cache: DBCC DROPCLEANBUFFERS
To clear procedure cache: DBCC FREEPROCCACHE
If you are comparing query performance on two different systems, this is the
only way to make sure current cache state doesn't overly influience the
outcomes.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Gary Abbott" <anonymous@.discussions.microsoft.com> wrote in message
news:ed1901c3f0c0$0fe1f700$a501280a@.phx.gbl...
> All,
> Sql 2000, sp3, Server 2000 sp4
> I have 2 servers, a production and a warm standby that I
> use for some reporting. The problem I am having is that on
> my production server, execution plan is showing a 55% use
> for a sort. That same sort is not on the standby server.
> The standby completes queries in 10% of the time on
> production. They are not identical servers, my production
> is a much faster machine. This problem has just started in
> the last week. I have done update statistics for all the
> tables in the db. I do indexdefrags about once a month, my
> db is 350 gbs in size. There is one table that I have not
> touched at all yet, there are 1.5 billion rows in this
> table. Any other ideas, before I tackle this table.
> Interesting note, if I do a select top 100 on production
> the ep is similar to the one on my standby. Any reasons?
> Thanks in advance all,
> Gary Abbott

ODBC System DSN Questions

We are running an SBS2000 network with around 40 clients being 60% Windows
2000 Pro and 40% WinXP Pro. We have around 3 member servers (not DC) and one
of the servers is a SQL server running SQL 2000.
A user on the domain has created a dBasev5.7 form that needs an ODBC System
DSN connection from the client to the SQL server in order for his form to be
populated with data. He wanted to roll out the DSNs to all the machines on
the network via Group Policy - I did a bit of digging around in the
Newsgroups and someone suggested this automated way by running a vbs script:
http://www.databasejournal.com/featu...e.php/2238221. Although
this works - we have a slight problem. We have no idea if this is to do with
dBase (it uses 16-bit architecture) but when we roll out the DSNs using the
script the registry gets updated (HKEYLOCAL
MACHINE>SOFTWARE>ODBC>ODBC.INI...) with all the right keys (as if you set it
up manually in Control Panel's ODBC) but we need to go through the System DSN
wizard (to the last page of the wizard) and click the "Test connection"
button in order for the dBase program to access the ODBC database connection.
It seems as if the ODBC System DSN is dead without clicking the "Test
Connection" button.
Questions:
1. Is it a requirement to hit the Test Network Connection button on the
last page of the wizard. I thought that this was only for troubleshooting?
2. It appears that this "Test Connection" button in the wizard posts a
registry key to allow the ODBC SYstem DSN (it has created) to be used. Where
abouts is this registry key?
3. Is there a Group Policy way of doing this? Chances are we may change
settings in the future and may want a server-side script running to update
any changes to clients automatically.
Please help.
THanks,
Skc
I am not usre why this is happening, but I can tell you that the Test
Connection button does not write a registry entry anywhere. It is just used
for testing the connection. Possibly teh script leaves something out that
is necessary and going through the wizard completes the process.
It is possible that an alias to the SQL Server is geing created when the
wizard is accessed. There is a cliconfg tuiltiy that you can use to verify
this.
Run the script on a client machine and then run cliconfg from Start - Run.
Check the alias tab to see if there is an alias to this SQL Server. If not,
then run the Wizard and go through the steps. After it completes go back to
cliconfg and see if there is an alias. In many case the cliconfg utility
will create an alias or a SQL Server when a DSN has been created.
Rand
This posting is provided "as is" with no warranties and confers no rights.

ODBC System DSN Questions

We are running an SBS2000 network with around 40 clients being 60% Windows
2000 Pro and 40% WinXP Pro. We have around 3 member servers (not DC) and on
e
of the servers is a SQL server running SQL 2000.
A user on the domain has created a dBasev5.7 form that needs an ODBC System
DSN connection from the client to the SQL server in order for his form to be
populated with data. He wanted to roll out the DSNs to all the machines on
the network via Group Policy - I did a bit of digging around in the
Newsgroups and someone suggested this automated way by running a vbs script:
http://www.databasejournal.com/feat...le.php/2238221. Although
this works - we have a slight problem. We have no idea if this is to do wit
h
dBase (it uses 16-bit architecture) but when we roll out the DSNs using the
script the registry gets updated (HKEYLOCAL
MACHINE>SOFTWARE>ODBC>ODBC.INI...) with all the right keys (as if you set it
up manually in Control Panel's ODBC) but we need to go through the System DS
N
wizard (to the last page of the wizard) and click the "Test connection"
button in order for the dBase program to access the ODBC database connection
.
It seems as if the ODBC System DSN is dead without clicking the "Test
Connection" button.
Questions:
1. Is it a requirement to hit the Test Network Connection button on the
last page of the wizard. I thought that this was only for troubleshooting?
2. It appears that this "Test Connection" button in the wizard posts a
registry key to allow the ODBC SYstem DSN (it has created) to be used. Wher
e
abouts is this registry key?
3. Is there a Group Policy way of doing this? Chances are we may change
settings in the future and may want a server-side script running to update
any changes to clients automatically.
Please help.
THanks,
SkcI am not usre why this is happening, but I can tell you that the Test
Connection button does not write a registry entry anywhere. It is just used
for testing the connection. Possibly teh script leaves something out that
is necessary and going through the wizard completes the process.
It is possible that an alias to the SQL Server is geing created when the
wizard is accessed. There is a cliconfg tuiltiy that you can use to verify
this.
Run the script on a client machine and then run cliconfg from Start - Run.
Check the alias tab to see if there is an alias to this SQL Server. If not,
then run the Wizard and go through the steps. After it completes go back to
cliconfg and see if there is an alias. In many case the cliconfg utility
will create an alias or a SQL Server when a DSN has been created.
Rand
This posting is provided "as is" with no warranties and confers no rights.

ODBC Linked Server & DSN

Hi,
Short version of question:
For linked servers to ODBC DSN data sources, does the DSN have to be setup
on the same windows server as the sql server 2005 instance? Or is only
requirment that the DSN is setup from the workstaing that is luanching SSMS?
Longer Background for question:
I'm attempting to setup a linked server in SQL Server 2005 to an ODBC
datasource which is Centura SQLbase database.
On my workstation, I have a DSN setup with the odbc drivers to connect to
the SQLbase db. The driver was "Centura SQLBase 3.60 32-bit Driver -NT &
Win95"
I can successfully import that tables from SQLBase using Access.
I'm using the SQL Server Managment Studio from my desktop to connect to the
SQL 2005 Server on a Windows 2003 Server.
When testing the Linked server by using a query, I use the following syntax
in a query in SSMS:
SELECT LastName, FirstName FROM LINK2SQLBASE.COMPANYDB.dbo.tblEmployee
I receive an Error:
*OLE DB provider "MSDASQL" for linked server... returned message
"[Microsoft][ODBC Driver Manager] Data source name not found and no
default
driver specified".
*Msg 7303, Level 16, State 1, Line 1
*Cannot initialize the data source object of OLE DB provider "MSDASQL" for
linked server...
Again, i'm using the SSMS from my workstation that has the DSN setup and
works fine when importing from access. I do NOT have the DSN or drivers on
the actual windwows 2003 Server where the SQL Sever 2005 instance is on.
Is that my promblem? Do I need the DSN on the actual windows 2003 server, or
should I be albe to use the DSN from my workstation?
Thanks in advanced!On Fri, 12 Jan 2007 14:11:04 -0800,
labsRcoolcommunitynospan@.discussions.microsoft.com wrote:
You will need to setup the driver and DSN on the SQL Server machine.
When you issue a query to a linked server, the client machine only knows
that it is talking to a SQL Server. The SQL Server then makes the request
to the remote data source. So the SQL Server has to have all the required
drivers, DSNs and privileges required to access the remote data source.
Darren Gosbell
SQL Server MVP

> Hi,
> Short version of question:
> For linked servers to ODBC DSN data sources, does the DSN have to be
setup
> on the same windows server as the sql server 2005 instance? Or is only
> requirment that the DSN is setup from the workstaing that is luanching
SSMS?
>
> Longer Background for question:
> I'm attempting to setup a linked server in SQL Server 2005 to an ODBC
> datasource which is Centura SQLbase database.
> On my workstation, I have a DSN setup with the odbc drivers to connect to
> the SQLbase db. The driver was "Centura SQLBase 3.60 32-bit Driver -NT &
> Win95"
> I can successfully import that tables from SQLBase using Access.
> I'm using the SQL Server Managment Studio from my desktop to connect to
the
> SQL 2005 Server on a Windows 2003 Server.
> When testing the Linked server by using a query, I use the following
syntax
> in a query in SSMS:
> SELECT LastName, FirstName FROM LINK2SQLBASE.COMPANYDB.dbo.tblEmployee
> I receive an Error:
> *OLE DB provider "MSDASQL" for linked server... returned message
> "[Microsoft][ODBC Driver Manager] Data source name not found and no[/vbcol
]
default[vbcol=seagreen]
> driver specified".
> *Msg 7303, Level 16, State 1, Line 1
> *Cannot initialize the data source object of OLE DB provider "MSDASQL"
for
> linked server...
> Again, i'm using the SSMS from my workstation that has the DSN setup and
> works fine when importing from access. I do NOT have the DSN or drivers
on
> the actual windwows 2003 Server where the SQL Sever 2005 instance is on.
> Is that my promblem? Do I need the DSN on the actual windows 2003 server,
or
> should I be albe to use the DSN from my workstation?
> Thanks in advanced!