SSIS In Clustering

Feb 4, 2008

Hi All,


I am going to install SQL Server 2005 in Clustering Env.( Active-Passive). As I know, Integration Services in not cluster aware, how should I deal with SSIS service.
Currently, we have some SSIS packages which run nightly. For most of them, package source is configured as €œFile System€? and for other package source is configured as €œSQL Server€?.
(1) So, I wanted to know, should I install SSIS service separately on passive node as we install client tools separately on Passive node.

(2) Should I make SSIS service as Cluster aware by following these steps. http://sqljunkies.com/WebLog/knight_reign/archive/2005/07/06/16015.aspx

(3) What will be effects if we configure (or) not configure SSIS to run as Cluster aware service.
Please give some ideas.
Thanks.

View 2 Replies


ADVERTISEMENT

SSIS Clustering Doubts

Jan 15, 2007

I have a SQL cluster 2005 with 2 nodes. I involved a ETL (DTS) on SSIS.

I used OLEDB to get a connection ORACLE and INFORMIX.

I used a user and password to authenticate.

When I publish the package, to the Integration Services.

I publish it to the MSDB so in case that we have a failover that the package is the same.

However in case of switching server (failover) the package that I published on NODE 1 does not run on NODE 2.

And it fail:

OnError,EDVSQLCLUSTER02,DOMAIN-LISBOA
olo,Insert pt_fornsap,{F06434D9-431B-48B7-A3E6-F17E04A29488},{4FF70682-705E-4410-885F-36F25BC1EC8C},22-09-2006 2:00:01,22-09-2006 2:00:01,-1071636471,0x,An OLE DB error has occurred. Error code: 0x80040E14.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Statement(s) could not be prepared.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Invalid object name 'pt_lfa1'.".

Could you help me

Thanks for advance

AG



View 1 Replies View Related

Clustering Install ( SSRS ,SSIS, Notification Services)

Apr 25, 2008

Quick question :


We are installing 2 instances of sql server in cluster env.


When intalling "Default" instance, I m getting Notification services, Integration, reporting services for default instance.


My question is : When we intall second named instance on cluster, will named instance share Notification services, Integration, reporting services with default instace.


So if above is yes, do I have to install Notification services, Integration, reporting services on C: drive of cluster nodes, so that it is shared by all the instances on the cluster nodes.


Please give some description on this.


Thanks

View 1 Replies View Related

Transfer A Database From Non-clustering To Clustering Env.

Nov 13, 2007

We have 2 env. : Testing and Production, both are running Windows 2003 Enterprise Server with SQL Server 2005. The difference is Testing is NOT running Windows cluster but Production do so, what is the best way to transfer a database from testing to production?

We have another systems that both testing and production are running on NON-cluster and we use backup/restore to transfer the database, can it apply in this case.

And I found that there are a tools called DTC, which can transfer all DB objects from one DB to another, is it a best way to transfer between non-cluster and cluster env.?

View 2 Replies View Related

Clustering

Dec 4, 2000

What is clustering?Why is it done?
Any suggestion appreciated.
Cheers!

View 4 Replies View Related

SQL 7 Clustering

Sep 14, 1999

I need to cluster two NT Enterrpise Servers with SQL 7 running on them. I have been looking all over the Net for info but not much luck. I need to have some specifics. Can you help me with some good sites or books or both? I have tried Microsoft and they had some info but not much.

Please help!

thanks

View 3 Replies View Related

SQL Clustering-NT Vs W2K?

Nov 20, 2001

We are in the process of consolidating all our SQL6.5 and SQL7 databases to a single SQL 7 server - once completed we want to setup a 2 node SQL7/2000 cluster on either NT4 Enterprise or W2k Advanced Server. I would therefore appreciate any advice in choosing between the two platforms based on cost, ease of setup & configuration and ongoing reliabilty & uptime etc - we currently have no NT4 Enterprise Servers so would have to purchase these licenses anyway. Correct me if I am wrong but I also understand that setting up a cluster on NT4 Enterprise is considerabely more complicated and time consuming than on W2K Advanced Server? Any advice would be greatly appreciated..

regards
Marcfw

View 1 Replies View Related

SQl Clustering

Oct 13, 2005

I have a job interview and I need to know what type of questions can be asked about working in a cluster environment, I don't have much experience in clustering, can someone please give me an idea?

Thanks in advance!!

View 5 Replies View Related

Clustering

Mar 19, 2001

Can I implement failover clustering between SQL Server 2000 & SQL Server 7.0? Or do they both need to be the same version of SQL Server.

View 3 Replies View Related

Clustering

Feb 14, 2005

I have a question relating more to documentation and support. I'm trying to find documentation on clustering.

I remember quite some time ago I found a white paper that literally walked you through every step involved in setting up a SQL Server failover cluster. I had also found a white paper that walked you through setting up an Active/Active cluster.

I've been going through Microsoft's site, but all I've found are little bits and pieces.

If anyone can point me in the right direction, or even provide a link, etc. as to where to find some good solid documentation, that would be awesome.

Thanks!!

Anthony

View 2 Replies View Related

Clustering

Sep 21, 2005

If i have an activepassive cluster for SQL Server, under what circumstances would it prompt to automatic changeover to the passive cluster ? Failure of the SQL Server, or let's say 1 user database out of 25 becomes suspect?

View 1 Replies View Related

Clustering

Sep 21, 2007

Is this possible with Express Edition.

We have two servers both running SQL 2005 express. Is there anyway that any changes on one could be replicated on the other?

Thanks

View 17 Replies View Related

Clustering SQL

Jun 6, 2007

HiI would like to know if it's possible to make a basic SQL cluster withwindows 2003 server and SQL 2000 standard edtition. It has to be abasic cluster, I dont need it to be very quick, I can have minutes ofservers down and it's ok.In case the answer is Yes, can you recommend some links to build itup, please?Thanks in advance!!Ignacio

View 2 Replies View Related

Clustering

Jan 7, 2008

what is clustering tell me in detail

View 4 Replies View Related

SQL N + 1 Clustering

Mar 4, 2008



We currently have a cluster configuration that is running as failover with one shared SAN storage solution. Two servers running Windows Server 2003 Enterprise and SQL 2005 Enterprise. We have two nodes right now running in failover and we will be purchasing a third.

Everything is working now, but we would like to move to an N+1 configuration with two active nodes hosting a separate SQL instance each with one failover node. I've seen N+1 mentioned on about a dozen Microsoft websites, but I cant find any documentation on how to setup or configure this clustering method. Has anyone ever set up a configuration like this or seen any documentation on how to do it? Is it possible to run failover with three nodes, two of them being active?

Any insight would be greatly appreciated.

View 5 Replies View Related

Clustering

Jul 20, 2006

Hi,



Where can I post issues with SQL 2005 clustering. Is there any prereq that needs to be followed before installing SQL 2005 on a windows cluster?



Thanks

View 14 Replies View Related

Clustering Vs. Log Shipping

Dec 4, 2006

Hi All,
Is anyone can tell me the difference between log shipping and clustering? I look at it and I think that this is the same thing as they use two different servers.
TIA

View 5 Replies View Related

Clustering Questions

Jul 24, 2000

Does anyone know the answers to either of these, given that we are talking about an active/passive cluster using MSCS, and we use Groupwise for mail (don't ask!)?

1) How do I configure Agent Mail on the cluster under this setup?

2) How do I set up linked servers from this setup to other (non-clustered) SQL servers - I can set up the cluster virtual server as a linked server from the others OK, but the other way around doesn't work - perhaps not surprisingly, but is there a way around it?

Thanks

Martin

View 1 Replies View Related

Clustering Sql7

Aug 11, 2000

I need some documentation on how to trouble shoot clustering SQL7EE. I have setup the cluster and looks like it is working but I missed somthing. When I test a failover by pulling the Network cable to the main network not the heartbeat network both boxes lock up. I can failover by powering down one box and using the MSCluster Admin. I am using NT40 6a on Dell PowerEdge 2400 and PowerValut 211s

View 3 Replies View Related

Clustering With NT/SQL Server

May 1, 2000

Is any doing any using Microsoft's Clustering technology as a failover
system with NT/SQL Server ?

View 1 Replies View Related

Clustering With NT/SQL Server

May 1, 2000

Those of you who are using MS Clustering, what are some advantages vs. a third party product such as "Double-Take" ? If you have used "Doube-Take" I would be extremely interested in your thought of the product.

Is it relatively easy to setup and configure with and environment
that's using all the standard products of BACKOFFICE (SQL Server 7.0 Standard Edition, NT 4.0 Standard Edition etc...)

Any hints, tips, etc... would be also GREATLY appreciated.

Thanks in advance.

View 2 Replies View Related

SQL Server Clustering

Jan 28, 2000

I have a question about database clustering. I am loking for the solution for the databse scalability, performance and zero downtime especially for MS SQL Server. As my understanding (correct if I am wrong), only Oracle provides 2 DB Servers (parallel server) or NT clustering for two sql servers. The drawback for these solution is only one server is working and another one is standing by. It is not efficent (which only 50%). Is any way that I could built the DB server farm which every DB server is working, if one failed, throw it away, rest of them still working; if I need more power, just add another db server box.How to solve the data sync problem ? Replication is not good for more than 4 or 5 db servers in the farm. Disk mirror is not good since if the server is down, there is no way to access the disks. DO you have any good idea ?

View 2 Replies View Related

SQLSERVER Clustering

Jan 24, 2001

Hi Guys,

I am installing sqlserver 7.0 in cluster server.
When I start with Installing the MSDTC and give the IP Address
of the Virtual server, It is giving message:

IP Address is in use.

I couldn't able to continue the installation further

Kindly advice me asap.

Thanks in advance,
Anu

View 5 Replies View Related

Clustering SQL Questions

Sep 7, 1999

2 Clustering Questions for you.

1. If I cluster 2 SQL servers in an active/active configuration and want to have a seperate disk array to house the data, do I need to have 2 disk arrays, one per server, or can I have one disk array?

2. When installing an application's database on the first(primary) sql server in an active/active configuration, do I need to install it on the second(secondary) server also? The second server will pick up the processes if the first fails.

View 2 Replies View Related

Clustering SQL Server 7.0

Aug 24, 2000

Hello,

How do i can configure sql server Cluster in mode Failover Active-Active?
Is possible?

Please help me

Thanks

View 2 Replies View Related

Requirements For Clustering

Jun 17, 2005

For SQL 2000, what are the licensing requirements for a clustered environment? I thought you needed datacenter for the OS, is there a clustered version of sql server, or do you need 2 copies of enterprise edition. Also, if you cluster can you license sql cals for clients, or do you have to do by processor?

View 4 Replies View Related

SQL 2000 Clustering

Mar 12, 2002

We are going to implement a SQL 2000 cluster in an active/passive setup. We are going to use multiple instances. What I am confused about is the naming of the virtual server and instances. In the microsoft documentation it states that all instance/virtual names must be unique across all nodes in the cluster. But the client always specifies the same virtual server name when connecting so how can the names be unique across all nodes??

I would have thought that if there was an instance created called inst1 on node A then during the installation that instance name would be replicated to the failover node B. When installing another instance on Node A do you have to specify a different virtual server and instance name on the failover node B??

Please help!!!!!!!

View 4 Replies View Related

MS Clustering(Urgent)

May 29, 2002

Hello,

I've clustering set up for my production server, My question is when Active sever goes down the Passive server comes up. But what happens when one database gets corrupted does the clustering take place or I've to work with restore.

Thanks for your help

Rea

View 1 Replies View Related

SQL 2000 Clustering

Jul 26, 2001

Should SQL Server 2000 (Enterprise edition) running on a Win2K Advanced Server (Active / Passive) cluster fail-over seamlessly?

We have been assured by our suppliers that current client connections (ODBC using TCP/IP) cannot be maintained during a fail-over. The result is that during a fail-over the client applications crash and users have to restart.

Do we have to modify the client application so that during a fail-over it will attempt to re-establish a connection?

Pointers to any resources for SQL 2000 clustering would be gratefully received (especially any which support the view that fail-over should be seamless).

Many Thanks

Mark

View 3 Replies View Related

SQL Server Clustering

Nov 8, 2006

In a clustered sql server environment having two Nodes, configured as Active/Active or Active/Passive, do I need to create the databases on both the Nodes?
I am not too sure about how to create databases in the clustered environment. Can somebody help..

View 1 Replies View Related

Is SQL 2000 Clustering Cr*p????

Jan 11, 2004

Howdy,

I have had questions from management about whether SQL 2000 clustering on windows 2000 is any good.

We are looking at spending *quite* a bit of money to implement it, but I want a "from the trenches" opinion of what its like , from the people that actually use it & look after it.

e.g.

DOES IT WORK LIKE IT SHOULD????????
Is it reliable?
Is it resource hungry?
Can I trust it to do what its supposed to do?

All repsonses very welcome. No response too small.

Thanks for your help.

Cheers,

SG.

View 14 Replies View Related

Clustering Is Possible With WindowsXp?

Apr 1, 2008

Dear all,
i've read in a article that clustering and it states that clustering is possible with windows 2003 server only. is it not possible to create cluster (i'm planning for fail over clustering)? if so, is there any software for that?


and one more thing is there any free downloads for eBooks of sql server?


thank you very much

Vinod
Even you learn 1%, Learn it with 100% confidence.

View 1 Replies View Related

Reads, Clustering, Etc

May 1, 2008

server: QAT on clustering server ----> 23 seconds
----------------------------------------------------
SS 2000 developer edition SP4
win NT 5.2 (3790) SP4
MeM 7935 MB
processors 4
root directory C:program files...
use a fixed memeroy size 640 MB

reserve physical memory for sql server
minimum query memory 1024 kb

use all available processors
minimum query plan threshold for considering 5

PROFILER READS = 5234




server: MILLER ----> 3 seconds
----------------------------------------------------
SS 2000 developer edition no service pack
win NT 5.2 (3790) SP4
MeM 2047 MB
processors 4
root directory f:MSSQL$INAQAT

dynamically configure sql server memory

use all available processors
minimum query plan threshold for considering 5
PROFILER READS = 598





----------------------------------------------------
Making story short. I got an application that hits only 1 database called RECORDS. I'm getting different duration when running an application. 23 and 3 seconds.
Same database, same objects and same application.
SERVER QAT is our staging server, means lots of databases
SERVER MILLER is just a server i just assembled, means just one database (RECORDS).

Not sure if it's because it's a clustering server that is causing the issue nor the reads. If its the reads, what is causing it? Do you think is the how the memory is configured?. Will the experts pls stand up?

View 20 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved