MSI unable to start the SQL instance service

Hi,
I am deploying a SQL on a three node active cluster setup. Each node will
have a SQL instance running in the cluster virtual server context. This is
the baseline setup required for deploying application databases on the three
SQL instances. Application databases are deployed using an MSI which creates
the database, roles, accounts etc.
The problem that I am facing is that when the Application Database MSI
executes, it will first recycle the SQL instance service to ensure that it is
up and running. At that point it is successfully able to stop the service but
fails to start the service giving the below error:
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 11920
Date: 10/12/2006
Time: 2:50:05 PM
User: myDomain\sql_account
Computer: SQLSERVER01
Description:
Product: Application Database -- Error 1920. Service 'MSSQL$\VS01'
(MSSQL$\VS01) failed to start. Verify that you have sufficient privileges to
start system services.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
The SQL service account has all the permissions on the machine. It is a
domain admin account with local admin privileges. It also has SystemAdmin
role on the SQL instance.
Can anyone tell me if there are any permissions that are missed that could
cause the above error?
Is there a security setting that I can check to validate permissions?
Thanks,
Mehul
The SQL service exists on all three nodes, but is only supposed to run on
one node at a time and then only under the control and direction of the
Cluster Service. You do not have to cycle the service to determine if it is
running, you can use the cluster.exe application or the WMI application
interface to determine if aclustered instance is running.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mehul" <Mehul@.discussions.microsoft.com> wrote in message
news:6C83D7C2-0514-4195-A46E-FE6D9C0E8831@.microsoft.com...
> Hi,
> I am deploying a SQL on a three node active cluster setup. Each node will
> have a SQL instance running in the cluster virtual server context. This is
> the baseline setup required for deploying application databases on the
> three
> SQL instances. Application databases are deployed using an MSI which
> creates
> the database, roles, accounts etc.
> The problem that I am facing is that when the Application Database MSI
> executes, it will first recycle the SQL instance service to ensure that it
> is
> up and running. At that point it is successfully able to stop the service
> but
> fails to start the service giving the below error:
> Event Type: Error
> Event Source: MsiInstaller
> Event Category: None
> Event ID: 11920
> Date: 10/12/2006
> Time: 2:50:05 PM
> User: myDomain\sql_account
> Computer: SQLSERVER01
> Description:
> Product: Application Database -- Error 1920. Service 'MSSQL$\VS01'
> (MSSQL$\VS01) failed to start. Verify that you have sufficient privileges
> to
> start system services.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> The SQL service account has all the permissions on the machine. It is a
> domain admin account with local admin privileges. It also has SystemAdmin
> role on the SQL instance.
> Can anyone tell me if there are any permissions that are missed that could
> cause the above error?
> Is there a security setting that I can check to validate permissions?
> Thanks,
> Mehul
|||Geoff,
The configuration is an Active-Active-Active one. Hence the SQL service will
run on each node.
"Geoff N. Hiten" wrote:

> The SQL service exists on all three nodes, but is only supposed to run on
> one node at a time and then only under the control and direction of the
> Cluster Service. You do not have to cycle the service to determine if it is
> running, you can use the cluster.exe application or the WMI application
> interface to determine if aclustered instance is running.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Mehul" <Mehul@.discussions.microsoft.com> wrote in message
> news:6C83D7C2-0514-4195-A46E-FE6D9C0E8831@.microsoft.com...
>
>
|||Then you have three instances, which will show up as three different
services on each node. You still need to leave them under the control of
the cluster service.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mehul" <Mehul@.discussions.microsoft.com> wrote in message
news:3D1AD5FD-FB0A-4C46-A858-E8523BBB61A4@.microsoft.com...[vbcol=seagreen]
> Geoff,
> The configuration is an Active-Active-Active one. Hence the SQL service
> will
> run on each node.
> "Geoff N. Hiten" wrote:
|||Geoff,
Yes this is correct.
If the SQL instance services need to be restarted, what is the recommended
way?
"Geoff N. Hiten" wrote:

> Then you have three instances, which will show up as three different
> services on each node. You still need to leave them under the control of
> the cluster service.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Mehul" <Mehul@.discussions.microsoft.com> wrote in message
> news:3D1AD5FD-FB0A-4C46-A858-E8523BBB61A4@.microsoft.com...
>
>
|||Use the cluster.exe command-line utility to stop and restart instances from
within a script.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mehul" <Mehul@.discussions.microsoft.com> wrote in message
news:39DD3469-5CEE-49DC-9755-681B5701D0EF@.microsoft.com...[vbcol=seagreen]
> Geoff,
> Yes this is correct.
> If the SQL instance services need to be restarted, what is the recommended
> way?
> "Geoff N. Hiten" wrote:

MsDtsSrvr.ini.xml file configration

Hi All,

How to configure MsDtsSrvr.ini.xml file in a active\active cluster.

Regards, Balaji Thiruvenkataraju

Add the named instances in, as per your previous post which I answered would make sense. Why, are you having a problem?

MSDTC, Active Diretory, DAO, And Transactions

If this is in the wrong forum, my apologies.
Here is the situation. We have a .Net application that someconsultants developed several years ago. They made use of DAO fordatabase access, using some inbuilt classes like ContextUtil to get atransation environment.
Until last weekend, the envorinment was:
Web application on IIS5 / Windows 2000 Advanced Server
Database on SQL2000 on Windows 2000 Advanced Server
We switched over to a new database server environment - a cluster oftwo Windows 2003 servers wth SQL Server 2000. This requiredActive Directory to be set up on the two database server machines.
Everything worked but this particular application - where it goes toupdate the database. It appears (but since I haven't yet beenable to rebuild the .Net solution) that the error - "Object referencenot set to an instance of object." is in fact a spurious error causedwhen the transation tries to roll back.
I have spent about 10 hours on this, and have come to the conclusionthat the fact I have MSDTC involved on a database server that is in anAD domain, while the web server that is issuing the transaction isoutside that domain is the cause of the problem. Now, I don'twant to put AD on the IIS 5 web server - we are migrating this to a newWin2k3/IIS6 server in 5 or 6 weeks time.
Any suggestions? If I have to, I can move the database for thisparticular app back to the non-clustered Windows 2000 server (which isalso outside the AD domain).
Thanks for your indulgance.
Microsoft requirement and good practice is a database Server is just a member server, it should not have anything to do with AD users. If your application is using DAO(data Access object) which was obselete in 1998 you may need MSDTC, the error could be you have not properly configured distributed transaction in SQL Server. Run a search for distributed transaction in the BOL(books online). The advice keep your application from none database users and AD. Hope this helps.

MSDTC with Windows 2003 Server

I have installed SQL Server 2000 virtual server on my Windows 2003 Server
Active\Active Cluster. I have installed SQL Server 2000 SP3 but have not
added any databases. But I did not know about the MSDTC step.
What steps do I need to complete to add MSDTC since to the cluster and to
the database configuration?
Thanks,Must install Componant Services. Documentation included will have
information on a clustered vs non-clustered install.
"Joe K." wrote:

> I have installed SQL Server 2000 virtual server on my Windows 2003 Server
> Active\Active Cluster. I have installed SQL Server 2000 SP3 but have not
> added any databases. But I did not know about the MSDTC step.
> What steps do I need to complete to add MSDTC since to the cluster and to
> the database configuration?
> Thanks,

MSDTC with Windows 2003 Server

I have installed SQL Server 2000 virtual server on my Windows 2003 Server
Active\Active Cluster. I have installed SQL Server 2000 SP3 but have not
added any databases. But I did not know about the MSDTC step.
What steps do I need to complete to add MSDTC since to the cluster and to
the database configuration?
Thanks,
Must install Componant Services. Documentation included will have
information on a clustered vs non-clustered install.
"Joe K." wrote:

> I have installed SQL Server 2000 virtual server on my Windows 2003 Server
> Active\Active Cluster. I have installed SQL Server 2000 SP3 but have not
> added any databases. But I did not know about the MSDTC step.
> What steps do I need to complete to add MSDTC since to the cluster and to
> the database configuration?
> Thanks,

MSDTC with Windows 2003 Server

I have installed SQL Server 2000 virtual server on my Windows 2003 Server
Active\Active Cluster. I have installed SQL Server 2000 SP3 but have not
added any databases. But I did not know about the MSDTC step.
What steps do I need to complete to add MSDTC since to the cluster and to
the database configuration?
Thanks,Must install Componant Services. Documentation included will have
information on a clustered vs non-clustered install.
"Joe K." wrote:
> I have installed SQL Server 2000 virtual server on my Windows 2003 Server
> Active\Active Cluster. I have installed SQL Server 2000 SP3 but have not
> added any databases. But I did not know about the MSDTC step.
> What steps do I need to complete to add MSDTC since to the cluster and to
> the database configuration?
> Thanks,

MSDTC service not starting

I have to install MSDTC on an Active/Passive cluster. I got instructions
from microsoft's website on how to enable MSDTC:
http://support.microsoft.com/kb/817064/
but when I follow the instructions, the service never starts. Even when I
try to start the service manually I am unsuccessful.
P.S. The cluster is being prepared for use by SQL Server 2005, and the DB
files will be stored on a Dell CX300 (SAN)..
Any suggestions on what may have caused this.
OK I got the service to start, but only after killing the cluster (in cluster
admin). Now while this was great at the time, it does not make much sense.
The reason being that anytime the cluster is present after that, the MSDTC
service stops. The new issue I have is that while configuring the MSDTC, I
was unable to create the "Physical Disk" resource (for the MSDTC Group),
because the wizard is unable to see/recognise any drives at all !!. Now I
really need some suggestions...
Can anyone help? It wil be most appreciated.
"iqv1" wrote:

> I have to install MSDTC on an Active/Passive cluster. I got instructions
> from microsoft's website on how to enable MSDTC:
> http://support.microsoft.com/kb/817064/
> but when I follow the instructions, the service never starts. Even when I
> try to start the service manually I am unsuccessful.
> P.S. The cluster is being prepared for use by SQL Server 2005, and the DB
> files will be stored on a Dell CX300 (SAN)..
> Any suggestions on what may have caused this.
|||Thank you very much for your assistance Edwin...
"Edwin vMierlo [MVP]" wrote:

> First of all, you need to properly configure MSDTC in your cluster.
> Exact instructions here : http://support.microsoft.com/kb/301600
> You do not necessarily have to create a seperate group with a seperate disk
> resource, unless you expect heavy usage of the MSDTC.
> It is acceptable to put your MSDTC in the default cluster group, using the
> Quorum disk.
> If you have problems adding disk to your cluster, you might want to try this
> article : http://support.microsoft.com/kb/555312
> Rgds,
> Edwin.
>
> "iqv1" <iqv1@.discussions.microsoft.com> wrote in message
> news:C6706333-DB5E-42AE-9CE0-0999A127BDE8@.microsoft.com...
> cluster
> sense.
> I
> instructions
> I
> DB
>
>

MSDTC Security

What are the correct Active Directory priviledges that should be applied to
the service account that runs the MSDTC?
Thanks,NT AUTHORITY\NetworkService
is the correct startup account.
There are no specific Active Directory settings needed.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

MSDTC in Active/Active MSCS cluster

How do I install MSDTC in an active/active MSCS cluster environment?
If I run comclust.exe, I can only activate MSDTC on one of the nodes at a time.
I need DTC on both nodes.
(Opsys is W2K with SQL 2000)
//Mange :)DTC is a shared service and needs to run from a shared disk. It can't have multiple instances.|||What Do you mean with multiple instances? On the same disk?

There are 2 servers in the MSCS cluster.
On each physical server, there is a virtual SQL server that has it's own shared disk.

Is it possible to start DTC on both nodes at the same time in this
configuration?

Regards
Mange :)

MSDTC cluster service for SQL

Hello
I'm about to install a active/active sql cluster on
windows 2003 server. I've installed the cluster service
without any problems. My question is concerning the DTC
service on each node of the cluster. I've yet to configure
the MSDTC as a cluster resource, and I can't start the DTC
service on any of the nodes. Will the MSDTC cluster
resource work if the local DTC service can't be started?
Thanks, Parky
There is only one MSDTC resource for the whole cluster. DTC Service is manage
from Cluster Service.
You can find more information on MS KB article: 'How to configure Microsoft
Distributed Transaction Coordinator on a Windows Server 2003 cluster'
(http://support.microsoft.com/default...b;en-us;301600)
"anonymous@.discussions.microsoft.com" wrote:

> Hello
> I'm about to install a active/active sql cluster on
> windows 2003 server. I've installed the cluster service
> without any problems. My question is concerning the DTC
> service on each node of the cluster. I've yet to configure
> the MSDTC as a cluster resource, and I can't start the DTC
> service on any of the nodes. Will the MSDTC cluster
> resource work if the local DTC service can't be started?
> Thanks, Parky
>

MSDTC and Full Text Indexing

Happy Christmas everyone,
I have just visited an active/active win2K(sp2) and SQL 2000(sp3a) cluster
that is not too happy. The virtual servers will not fail over between the
nodes as the MSDTC will not restart if moved. Full text indexing exists
only in one virtual server and needs to be on both instances.
I suspect that comclust wasn't run at installation but has been subsequently
run on one node only. Is there a safe way of now recreating the MSDTC or
reinstalling somehow without reinstalling SQL?
Thanks in advance.
Tim
I never wish I was not what I was not when I didn't wish what I was not was
not what I am not.
Hi Tim!
Yes, you can remove and reinstall MSDTC 'underneath' SQL.
However, the health of this cluster sounds pretty suspect!
I would caution you to BACK EVERYTHING UP before you do anything to this
cluster.
:-)
All system db's...everything.
If it's not moving, back it up!
Ok, with that said, you can follow this KB article on moving and rebuilding
the MSDTC resource:
294209 How to rebuild or move MSDTC used with a SQL failover cluster
There is also this article:
Microsoft Distributed Transaction Coordinator (MSDTC) Recovery Techniques
in Windows 2000 Cluster Server (243204)
Which is not really SQL specific.
As for the FTSearch issue...that is a little more complicated.
Generally there are two reasons FTS doesn't work in a cluster.
1. Search setup was not successful
2. You have missing registry keys.
For number 1, you will need to do some detective work.
First collect the most recent sqlstp#.log from both nodes.
Look for the searchsetup.exe section.
Any errors? If there is an error number, go to a cmd prompt, type net
helpmsg <errornumber>
What's the error? This will be important. At that point you should engage
PSS to rebuild FTS, as it's tricky at best.
For number 2, follow this article to confirm you have the correct registry
entries for FTS:
http://support.microsoft.com/default...B;EN-US;810056
INF: You Must Use Resource-Specific Registry Keys for SQL Server Cluster
Resources (810056)
If missing, put them in there. If that doesn't fix it, again, call PSS,
you probably have more at play than just missing registry keys.
Hope your sickly cluster recovers!
Thanks!
Donna Lambert
SQL Server Product Support

MSDTC / sql2000 active/active

We need to create an active/active sql 2000 cluster on 2003 enterprise
server. Do I need multiple MSDTC or just one?
Windows 2000/2003 server clustering only allows for instance within a
cluster.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:C3B393B5-2BBA-46C5-8F4B-7942EBCD8E84@.microsoft.com...
> We need to create an active/active sql 2000 cluster on 2003 enterprise
> server. Do I need multiple MSDTC or just one?
|||Are you saying we cannot have an active/active cluster?
We're planning on having instance 1 on node 1, instance 2 on node 2.
burt_king@.yahoo.com
"Rodney R. Fournier [MVP]" wrote:

> Windows 2000/2003 server clustering only allows for instance within a
> cluster.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "burt_king" <burt_king@.yahoo.com> wrote in message
> news:C3B393B5-2BBA-46C5-8F4B-7942EBCD8E84@.microsoft.com...
>
>
|||No, I am saying you can only have 1 copy of MSDTC within a cluster (Longhorn
will change this...).
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:F232F32F-0DF9-477B-9BBA-113FC2F4FF46@.microsoft.com...[vbcol=seagreen]
> Are you saying we cannot have an active/active cluster?
> We're planning on having instance 1 on node 1, instance 2 on node 2.
> --
> burt_king@.yahoo.com
>
> "Rodney R. Fournier [MVP]" wrote:
|||> Are you saying we cannot have an active/active cluster?
You can have multiple SQL instances, but only one MSDTC.
Linchi
"burt_king" wrote:
[vbcol=seagreen]
> Are you saying we cannot have an active/active cluster?
> We're planning on having instance 1 on node 1, instance 2 on node 2.
> --
> burt_king@.yahoo.com
>
> "Rodney R. Fournier [MVP]" wrote:
|||Great. I assume it doesn't matter which node owns the MSDTC resource... is
that correct?
"Linchi Shea" wrote:
[vbcol=seagreen]
> You can have multiple SQL instances, but only one MSDTC.
> Linchi
> "burt_king" wrote:
|||In theory yes, but we have an application that requires MSDTC to start
before its resources start. You will need to with your applications.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:DEED957B-5413-4878-A163-E1BE2B20B442@.microsoft.com...[vbcol=seagreen]
> Great. I assume it doesn't matter which node owns the MSDTC resource...
> is
> that correct?
> "Linchi Shea" wrote:
|||Does SQL Server automagically configure itself to wait for MSDTC when doing
the clustered installs?
"Rodney R. Fournier [MVP]" wrote:

> In theory yes, but we have an application that requires MSDTC to start
> before its resources start. You will need to with your applications.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "burt_king" <burt_king@.yahoo.com> wrote in message
> news:DEED957B-5413-4878-A163-E1BE2B20B442@.microsoft.com...
>
>
|||Er, no - since mine are in different groups.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:95C0486B-FA13-4085-ADF4-81DF2301E393@.microsoft.com...[vbcol=seagreen]
> Does SQL Server automagically configure itself to wait for MSDTC when
> doing
> the clustered installs?
> --
> "Rodney R. Fournier [MVP]" wrote: