DTS - ActiveXScripting Not Working on 64bit AMD Cluster on SQL Server 2005 SP2

I have a problem with DTS - ActiveXScripting that it cannot initialize the script engine, I have the backward compatibility stuff installed, even tried a repair but still does not work.

Many thanks for any help you can provide on this problem.

Paul

Error Information below:

Date 17/04/2007 13:07:32
Log Job History (Test ActiveX Script)

Step ID 1
Server GBCONV1A002V03
Job Name Test ActiveX Script
Step Name Step 1: Exec TestActiveX script
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: WW004\ConSrvSQLAgentA002. ...TSStep_DTSActiveScriptTask_1 DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220487 (800403F9) Error string: ActiveX Scripting was not able to initialize the script execution engine. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 Error Detail Records: Error: -2147220487 (800403F9); Provider Error: 0 (0) Error string: ActiveX Scripting was not able to initialize the script execution engine. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 Error: -2147220440 (80040428); Provider Error: 0 (0) Error string: Package failed because Step 'DTSStep_DTSActiveScriptTask_1' failed. Error source: Microsoft Data Transformation Services (DTS) Package Help file: ... Process Exit Code 1. The step failed.

Try asking in the DTS usenet group.

http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg

DTCPing works, but distributed transaction cannot be started

Hi!
I'm getting an error when trying to start simple distributed
transaction.
Configuration is Win2k3/SQL2K <-> Win2k3 Cluster / SQL2K
[OLE/DB provider returned message: New transaction cannot enlist in the
specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].
DTCPing works in both directions, but there is one strange thing in log
on cluster server:
Cluster Environment detected
03-06, 06:52:43.296-->Invalid IP Address:207.x.x.253
(Mask:255.255.255.248) (38)
MSDTC Virtual Name:DTC1, IP:
When used internal an IP address, there is no such message.
Here is a full log of DTC ping on a cluster:
Platform:Windows 2003
cluster environment detected:
Windows 2003,sp1 environment is detected:
Reading MSDTC settings from cluster registry:
NetworkDtcAccess :true
NetworkDtcAccessAdmin :true
NetworkDtcAccessClients :true
NetworkDtcAccessTransactions:true
NetworkDtcAccessTip :false
XaTransactions :true
TurnOffRpcSecurity :true
NetworkDtcAccessOutbound :true
NetworkDtcAccessInbound :true
FallbackToUnsecureRPCIfNecessary:false
AllowOnlySecureRpcCalls :false
AccountName :NT AUTHORITY\NetworkService
IP Configure Information
Host Name . . . . . . . . . : HOSTA1
DNS Servers . . . . . . . . : 192.168.0.8
192.168.0.7
207.x.x.250
63.x.x.5
Node Type . . . . . . . . . :
NetBIOS Scope ID. . . . . . :
IP Routing Enabled. . . . . : no
WINS Proxy Enabled. . . . . : no
NetBIOS Resolution Uses DNS : no
Ethernet adapter {BBA542FC-1328-4246-A31B-16379406424B}:
Description . . . . . . . . : BASP Virtual Adapter
Physical Address. . . . . . : 00-10-18-14-4C-4E
DHCP Enabled. . . . . . . . : no
IP Address. . . . . . . . . : 192.168.0.103
Subnet Mask . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . : 192.168.0.101
Subnet Mask . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . : 192.168.0.100
Subnet Mask . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . : 192.168.0.105
Subnet Mask . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . : 192.168.0.107
Subnet Mask . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . : 192.168.0.8
Subnet Mask . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . :
DHCP Server . . . . . . . . : 255.255.255.255
Primary WINS Server . . . . : 0.0.0.0
Secondary WINS Server . . . : 0.0.0.0
Lease Obtained. . . . . . . : Thu Jan 01 00:00:00 1970
Lease Expires . . . . . . . : Thu Jan 01 00:00:00 1970
Ethernet adapter {52ED9D48-488E-4265-AC55-3CE5BBFDBF23}:
Description . . . . . . . . : Broadcom NetXtreme Gigabit
Ethernet
Physical Address. . . . . . : 00-14-22-73-F9-C9
DHCP Enabled. . . . . . . . : no
IP Address. . . . . . . . . : 207.x.x.253
Subnet Mask . . . . . . . . : 255.255.255.248
IP Address. . . . . . . . . : 207.x.x.251
Subnet Mask . . . . . . . . : 255.255.255.248
IP Address. . . . . . . . . : 207.x.x.250
Subnet Mask . . . . . . . . : 255.255.255.248
Default Gateway . . . . . . : 207.x.x.249
DHCP Server . . . . . . . . : 255.255.255.255
Primary WINS Server . . . . : 0.0.0.0
Secondary WINS Server . . . : 0.0.0.0
Lease Obtained. . . . . . . : Thu Jan 01 00:00:00 1970
Lease Expires . . . . . . . : Thu Jan 01 00:00:00 1970
++++++++++++lmhosts.sam++++++++++++
++++++++++++hosts ++++++++++++
127.0.0.1 localhost
193.x.x.147 HOSTB1
Cluster Environment detected
03-06, 06:52:43.296-->Invalid IP Address:207.x.x.253
(Mask:255.255.255.248) (38)
MSDTC Virtual Name:DTC1, IP:
++++++++++++++++++++++++++++++++++++++++++++++
DTCping 1.9 Report for
++++++++++++++++++++++++++++++++++++++++++++++
Firewall Port Settings:
Port:5000-5200
RPC server is ready
03-06, 06:52:51.078-->RPC server: received following information:
Network Name: HOSTA1
Source Port: 5069
Partner LOG: HOSTB15232.log
Partner CID: CA74E8B7-5274-40DF-97F0-CCF7B89895A9
++++++++++++Start Reverse Bind Test+++++++++++++
Received Bind call from HOSTB1
Network Name: HOSTA1
Source Port: 5069
Hosting Machine:
03-06, 06:52:51.296-->Trying to Reverse Bind to HOSTB1...
Test Guid:CA74E8B7-5274-40DF-97F0-CCF7B89895A9
Name Resolution:
HOSTB1-->193.x.x.147-->HOSTB1
Reverse Binding success: -->HOSTB1
++++++++++++Reverse Bind Test ENDED++++++++++
03-06, 06:52:52.296-->Called POKE from Partner:HOSTB1
Network Name: HOSTA1
Source Port: 5069
Hosting Machine:
++++++++++++Validating Remote Computer Name++++++++++++
03-06, 06:52:55.140-->Start DTC connection test
Name Resolution:
HOSTB1-->193.x.x.147-->HOSTB1
03-06, 06:52:55.156-->Start RPC test (-->HOSTB1)
RPC test is successful
Partner's CID:CA74E8B7-5274-40DF-97F0-CCF7B89895A9
++++++++++++RPC test completed+++++++++++++++
++++++++++++Start DTC Binding Test +++++++++++++
Trying Bind to HOSTB1
03-06, 06:52:55.296--> Initiating DTC Binding Test...
Test Guid:66C8FDED-CEC3-4C56-A4F6-F6EA236DAD5F
Received reverse bind call from HOSTB1
Network Name: HOSTA1
Source Port: 5069
Hosting Machine:
Binding success: -->HOSTB1
++++++++++++DTC Binding Test END+++++++++++++
Anyone can help me?
|||See if this helps.
HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows Server
2003
http://support.microsoft.com/kb/555017/en-us
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<maqdev@.gmail.com> wrote in message
news:1141651435.453798.152890@.u72g2000cwu.googlegr oups.com...
> Hi!
> I'm getting an error when trying to start simple distributed
> transaction.
> Configuration is Win2k3/SQL2K <-> Win2k3 Cluster / SQL2K
> ----
> [OLE/DB provider returned message: New transaction cannot enlist in the
> specified transaction coordinator. ]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
> ITransactionJoin::JoinTransaction returned 0x8004d00a].
> ----
> DTCPing works in both directions, but there is one strange thing in log
> on cluster server:
> ----
> Cluster Environment detected
> 03-06, 06:52:43.296-->Invalid IP Address:207.x.x.253
> (Mask:255.255.255.248) (38)
> MSDTC Virtual Name:DTC1, IP:
> ----
> When used internal an IP address, there is no such message.
> Here is a full log of DTC ping on a cluster:
> ----
> Platform:Windows 2003
> cluster environment detected:
> Windows 2003,sp1 environment is detected:
> Reading MSDTC settings from cluster registry:
> NetworkDtcAccess :true
> NetworkDtcAccessAdmin :true
> NetworkDtcAccessClients :true
> NetworkDtcAccessTransactions:true
> NetworkDtcAccessTip :false
> XaTransactions :true
> TurnOffRpcSecurity :true
> NetworkDtcAccessOutbound :true
> NetworkDtcAccessInbound :true
> FallbackToUnsecureRPCIfNecessary:false
> AllowOnlySecureRpcCalls :false
> AccountName :NT AUTHORITY\NetworkService
> IP Configure Information
> Host Name . . . . . . . . . : HOSTA1
> DNS Servers . . . . . . . . : 192.168.0.8
> 192.168.0.7
> 207.x.x.250
> 63.x.x.5
> Node Type . . . . . . . . . :
> NetBIOS Scope ID. . . . . . :
> IP Routing Enabled. . . . . : no
> WINS Proxy Enabled. . . . . : no
> NetBIOS Resolution Uses DNS : no
>
> Ethernet adapter {BBA542FC-1328-4246-A31B-16379406424B}:
> Description . . . . . . . . : BASP Virtual Adapter
> Physical Address. . . . . . : 00-10-18-14-4C-4E
> DHCP Enabled. . . . . . . . : no
> IP Address. . . . . . . . . : 192.168.0.103
> Subnet Mask . . . . . . . . : 255.255.255.0
> IP Address. . . . . . . . . : 192.168.0.101
> Subnet Mask . . . . . . . . : 255.255.255.0
> IP Address. . . . . . . . . : 192.168.0.100
> Subnet Mask . . . . . . . . : 255.255.255.0
> IP Address. . . . . . . . . : 192.168.0.105
> Subnet Mask . . . . . . . . : 255.255.255.0
> IP Address. . . . . . . . . : 192.168.0.107
> Subnet Mask . . . . . . . . : 255.255.255.0
> IP Address. . . . . . . . . : 192.168.0.8
> Subnet Mask . . . . . . . . : 255.255.255.0
> Default Gateway . . . . . . :
> DHCP Server . . . . . . . . : 255.255.255.255
> Primary WINS Server . . . . : 0.0.0.0
> Secondary WINS Server . . . : 0.0.0.0
> Lease Obtained. . . . . . . : Thu Jan 01 00:00:00 1970
> Lease Expires . . . . . . . : Thu Jan 01 00:00:00 1970
> Ethernet adapter {52ED9D48-488E-4265-AC55-3CE5BBFDBF23}:
> Description . . . . . . . . : Broadcom NetXtreme Gigabit
> Ethernet
> Physical Address. . . . . . : 00-14-22-73-F9-C9
> DHCP Enabled. . . . . . . . : no
> IP Address. . . . . . . . . : 207.x.x.253
> Subnet Mask . . . . . . . . : 255.255.255.248
> IP Address. . . . . . . . . : 207.x.x.251
> Subnet Mask . . . . . . . . : 255.255.255.248
> IP Address. . . . . . . . . : 207.x.x.250
> Subnet Mask . . . . . . . . : 255.255.255.248
> Default Gateway . . . . . . : 207.x.x.249
> DHCP Server . . . . . . . . : 255.255.255.255
> Primary WINS Server . . . . : 0.0.0.0
> Secondary WINS Server . . . : 0.0.0.0
> Lease Obtained. . . . . . . : Thu Jan 01 00:00:00 1970
> Lease Expires . . . . . . . : Thu Jan 01 00:00:00 1970
>
> ++++++++++++lmhosts.sam++++++++++++
>
> ++++++++++++hosts ++++++++++++
> 127.0.0.1 localhost
> 193.x.x.147 HOSTB1
>
> Cluster Environment detected
> 03-06, 06:52:43.296-->Invalid IP Address:207.x.x.253
> (Mask:255.255.255.248) (38)
> MSDTC Virtual Name:DTC1, IP:
> ++++++++++++++++++++++++++++++++++++++++++++++
> DTCping 1.9 Report for
> ++++++++++++++++++++++++++++++++++++++++++++++
> Firewall Port Settings:
> Port:5000-5200
> RPC server is ready
> 03-06, 06:52:51.078-->RPC server: received following information:
> Network Name: HOSTA1
> Source Port: 5069
> Partner LOG: HOSTB15232.log
> Partner CID: CA74E8B7-5274-40DF-97F0-CCF7B89895A9
> ++++++++++++Start Reverse Bind Test+++++++++++++
> Received Bind call from HOSTB1
> Network Name: HOSTA1
> Source Port: 5069
> Hosting Machine:
> 03-06, 06:52:51.296-->Trying to Reverse Bind to HOSTB1...
> Test Guid:CA74E8B7-5274-40DF-97F0-CCF7B89895A9
> Name Resolution:
> HOSTB1-->193.x.x.147-->HOSTB1
> Reverse Binding success: -->HOSTB1
> ++++++++++++Reverse Bind Test ENDED++++++++++
> 03-06, 06:52:52.296-->Called POKE from Partner:HOSTB1
> Network Name: HOSTA1
> Source Port: 5069
> Hosting Machine:
> ++++++++++++Validating Remote Computer Name++++++++++++
> 03-06, 06:52:55.140-->Start DTC connection test
> Name Resolution:
> HOSTB1-->193.x.x.147-->HOSTB1
> 03-06, 06:52:55.156-->Start RPC test (-->HOSTB1)
> RPC test is successful
> Partner's CID:CA74E8B7-5274-40DF-97F0-CCF7B89895A9
> ++++++++++++RPC test completed+++++++++++++++
> ++++++++++++Start DTC Binding Test +++++++++++++
> Trying Bind to HOSTB1
> 03-06, 06:52:55.296--> Initiating DTC Binding Test...
> Test Guid:66C8FDED-CEC3-4C56-A4F6-F6EA236DAD5F
> Received reverse bind call from HOSTB1
> Network Name: HOSTA1
> Source Port: 5069
> Hosting Machine:
> Binding success: -->HOSTB1
> ++++++++++++DTC Binding Test END+++++++++++++
>

DTC on ACTIVE ACTIVE cluster - urgent

Greetings, we have 4 node cluster setup. 3 nodes are active and one is
passive. As I understood, MS DTC will run only one node and hence will be
available to the SQL instances running on that node. Can I run DTC on
multiple nodes in a cluster?
I have created one DTC resource prior to the SQL install. I can not add
addional DTC resource. Our apps need to have DTC on most of the instances
which we can not put them on one node. Any suggestions?
Thanks in advance.
The single DTC instance will support all SQL instances in the cluster,
regardless of their current host node. You do not need a unique DTC
instance for each SQL instance.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mintz" <Mintz@.discussions.microsoft.com> wrote in message
news:8DBA18AB-FA21-474D-B630-78F0CA8B910D@.microsoft.com...
> Greetings, we have 4 node cluster setup. 3 nodes are active and one is
> passive. As I understood, MS DTC will run only one node and hence will be
> available to the SQL instances running on that node. Can I run DTC on
> multiple nodes in a cluster?
> I have created one DTC resource prior to the SQL install. I can not add
> addional DTC resource. Our apps need to have DTC on most of the instances
> which we can not put them on one node. Any suggestions?
> Thanks in advance.
|||I agree with Geoff but the key to DTC working properly is to enable DTC for
network access. You can do this from Control panel/Add remove programs/add
remove components/Application Server. You have to do this on all nodes in
your cluster.
Also refer to the following articles
http://support.microsoft.com/default...b;en-us;301600
http://support.microsoft.com/default.aspx?kbid=817064
"Geoff N. Hiten" wrote:

> The single DTC instance will support all SQL instances in the cluster,
> regardless of their current host node. You do not need a unique DTC
> instance for each SQL instance.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Mintz" <Mintz@.discussions.microsoft.com> wrote in message
> news:8DBA18AB-FA21-474D-B630-78F0CA8B910D@.microsoft.com...
>
>
|||i stuck at step 4. so my questions are
1. do i need an separate IP address? can i use the ip in cluster group
2. for physical disk, do i have to create another physical disk which
is shared by both nodes? can i use drive "Q:\"?
right now i did not follow the doc and created MSDTC in cluster group
using ip, physical disk and network name in that group (created
automatically). only one node can see msdtc which is not what i
expect.
thanks,
jj
"Rony Thomas" <rony_p_thomas@.hotmail.com> wrote in message news:<4C07737F-248A-42DE-87DA-F1D1590C44E8@.microsoft.com>...[vbcol=seagreen]
> I agree with Geoff but the key to DTC working properly is to enable DTC for
> network access. You can do this from Control panel/Add remove programs/add
> remove components/Application Server. You have to do this on all nodes in
> your cluster.
> Also refer to the following articles
> http://support.microsoft.com/default...b;en-us;301600
> http://support.microsoft.com/default.aspx?kbid=817064
>
> "Geoff N. Hiten" wrote:
|||try creating another group with resources for DTC and make sure you enable
network access
"jj" wrote:

> i stuck at step 4. so my questions are
> 1. do i need an separate IP address? can i use the ip in cluster group
> 2. for physical disk, do i have to create another physical disk which
> is shared by both nodes? can i use drive "Q:\"?
> right now i did not follow the doc and created MSDTC in cluster group
> using ip, physical disk and network name in that group (created
> automatically). only one node can see msdtc which is not what i
> expect.
> thanks,
> jj
> "Rony Thomas" <rony_p_thomas@.hotmail.com> wrote in message news:<4C07737F-248A-42DE-87DA-F1D1590C44E8@.microsoft.com>...
>

DTC in multiple instance cluster

WE have a 2 node win 2k3 x64 cluster (also x86 clusters with same problem)
with 2 instanses of SQL 2005 x64 and the MSDTC resource in the admin.
cluster group (quorum group).
This is a active/passive cluster, all 3 groups/vir. servers on same node.
The problem appears when one of the SQL servers fail over to the other node.
Then the MSDTC transactions fail on this sql server.
Result = we have to manually fail over the MSDTC resource/group also.
I have read about a DTC proxy but how do I get this to work ?
Bj?rn
Some say that this shouldn't happen, but we experienced this often as well.
The fix is to place the MS DTC in its own cluster resource group, which will
require another set of dedicated IP Addresses, physical disk, and network
name resources.
http://support.microsoft.com/kb/301600/en-us
Sincerely,
Anthony Thomas

"Bjrn" <Bjrn@.discussions.microsoft.com> wrote in message
news:251D1C52-C076-40A0-BE2B-2B5EF4031146@.microsoft.com...
> WE have a 2 node win 2k3 x64 cluster (also x86 clusters with same problem)
> with 2 instanses of SQL 2005 x64 and the MSDTC resource in the admin.
> cluster group (quorum group).
> This is a active/passive cluster, all 3 groups/vir. servers on same node.
> The problem appears when one of the SQL servers fail over to the other
node.
> Then the MSDTC transactions fail on this sql server.
> Result = we have to manually fail over the MSDTC resource/group also.
> I have read about a DTC proxy but how do I get this to work ?
> Bjrn
>

DTC & SQL Server in cluster

Hi friends,
One simple and maybe silly question. Is DTC cluster resource a necessary
prerequisite for SQL Server to operate in cluster environment? If so, why?
And it'd be great if anyone can direct me to any resource about DTC
internals. Not just setup & configuration but how it works on low level.
Thanks in advance.
Falconer
Hi
"Falconer" wrote:

> Hi friends,
> One simple and maybe silly question. Is DTC cluster resource a necessary
> prerequisite for SQL Server to operate in cluster environment? If so, why?
> And it'd be great if anyone can direct me to any resource about DTC
> internals. Not just setup & configuration but how it works on low level.
> Thanks in advance.
> Falconer
If you are using distributed transactions on the virtual server you are
required to install a clustered resource.
http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best links
seem to be at
http://msdn2.microsoft.com/en-us/library/ms687102.aspx
John
|||Thanks a lot John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:5011A242-9AAD-4663-B1B5-2DF8EC6C5F84@.microsoft.com...
> Hi
> "Falconer" wrote:
>
> If you are using distributed transactions on the virtual server you are
> required to install a clustered resource.
> http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best
> links
> seem to be at
> http://msdn2.microsoft.com/en-us/library/ms687102.aspx
> John

DTC & SQL Server in cluster

Hi friends,
One simple and maybe silly question. Is DTC cluster resource a necessary
prerequisite for SQL Server to operate in cluster environment? If so, why?
And it'd be great if anyone can direct me to any resource about DTC
internals. Not just setup & configuration but how it works on low level.
Thanks in advance.
FalconerHi
"Falconer" wrote:
> Hi friends,
> One simple and maybe silly question. Is DTC cluster resource a necessary
> prerequisite for SQL Server to operate in cluster environment? If so, why?
> And it'd be great if anyone can direct me to any resource about DTC
> internals. Not just setup & configuration but how it works on low level.
> Thanks in advance.
> Falconer
If you are using distributed transactions on the virtual server you are
required to install a clustered resource.
http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best links
seem to be at
http://msdn2.microsoft.com/en-us/library/ms687102.aspx
John|||Thanks a lot John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:5011A242-9AAD-4663-B1B5-2DF8EC6C5F84@.microsoft.com...
> Hi
> "Falconer" wrote:
>> Hi friends,
>> One simple and maybe silly question. Is DTC cluster resource a necessary
>> prerequisite for SQL Server to operate in cluster environment? If so,
>> why?
>> And it'd be great if anyone can direct me to any resource about DTC
>> internals. Not just setup & configuration but how it works on low level.
>> Thanks in advance.
>> Falconer
> If you are using distributed transactions on the virtual server you are
> required to install a clustered resource.
> http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best
> links
> seem to be at
> http://msdn2.microsoft.com/en-us/library/ms687102.aspx
> John

DTC & SQL Server in cluster

Hi friends,
One simple and maybe silly question. Is DTC cluster resource a necessary
prerequisite for SQL Server to operate in cluster environment? If so, why?
And it'd be great if anyone can direct me to any resource about DTC
internals. Not just setup & configuration but how it works on low level.
Thanks in advance.
FalconerHi
"Falconer" wrote:

> Hi friends,
> One simple and maybe silly question. Is DTC cluster resource a necessary
> prerequisite for SQL Server to operate in cluster environment? If so, why?
> And it'd be great if anyone can direct me to any resource about DTC
> internals. Not just setup & configuration but how it works on low level.
> Thanks in advance.
> Falconer
If you are using distributed transactions on the virtual server you are
required to install a clustered resource.
http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best link
s
seem to be at
http://msdn2.microsoft.com/en-us/library/ms687102.aspx
John|||Thanks a lot John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:5011A242-9AAD-4663-B1B5-2DF8EC6C5F84@.microsoft.com...
> Hi
> "Falconer" wrote:
>
> If you are using distributed transactions on the virtual server you are
> required to install a clustered resource.
> http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best
> links
> seem to be at
> http://msdn2.microsoft.com/en-us/library/ms687102.aspx
> John

DSNLess connection with Failover to a SQL Server 2005 cluster

Hi,

We have configured two SQL Server 2005 in a cluster (without Witness).

We have severals ASP (using ADO) that are connecting to SQL Server 2005 with SQL Native Client in a DSNLess connection String :

driver={SQL Native Client}; server=MAIN\MAIN; Failover Partner=BCKUP\BCKUP; uid=log;pwd=pwd;database=MyBase

When using this connection string, the connection to MAIN is alrigth, but when we simulate a unavailability situation on "MyBase" or on the entire MAIN instance, the new connection are joining the MAIN and not the BCKUP SQL Server.

We tryed several Connection Strings including Failover_Partner, Initliag Catalog instead of database... but no one succed in joining the BCKUP SQL Server.

I precise that the DNS on the PC that connect to SQL server is configured and both MAIN and BCKUP are resolved in command line or in explorer.

Is there an other driver that must be used, or is there an other parameter to set in the connection string ?

Regards.

When you configure Mirroring without a witness, failover is not automatic. You must manually failover the database - you do this via alter database or using the button provided in the database mirroring properties.

Matt Hollingsworth

Sr. Program Manager

Microsoft SQL Server

DSNLess connection with Failover on SQL Server 2005 Cluster ?

Hi,

We have configured two SQL Server 2005 in a cluster (without Witness).

We have severals ASP (using ADO) that are connecting to SQL Server 2005 with SQL Native Client in a DSNLess connection String :

driver={SQL Native Client}; server=MAIN\MAIN; Failover Partner=BCKUP\BCKUP; uid=log;pwd=pwd;database=MyBase

When using this connection string, the connection to MAIN is alrigth, but when we simulate a unavailability situation on "MyBase" or on the entire MAIN instance, the new connection are joining the MAIN and not the BCKUP SQL Server.

We tryed several Connection Strings including Failover_Partner, Initliag Catalog instead of database... but no one succed in joining the BCKUP SQL Server.

I precise that the DNS on the PC that connect to SQL server is configured and both MAIN and BCKUP are resolved in command line or in explorer.

Is there an other driver that must be used, or is there an other parameter to set in the connection string ?

Regards.

Failover Partner is used in the case of database mirroring, not for the case of cluster. Check here: http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

Cluster is transparent to client, i.e., client should be able to connect to the server without knowing the server is a cluster or not. In cluster case, use "server=your_virtual_server_name" in the connection string. Please check my blog at http://blogs.msdn.com/sql_protocols/archive/2005/12/05/500013.aspx and let us know if you have further problem.