Hi everyone,
I have problem installing MS-SQL 2000 enterprise on Windows Server 2003 Ent.
cluster. The message I'm getting is "Setup failed to perform required
operations on the cluster nodes." The only thing "cluster.log" says in
regards of the MS-SQL is that "the virtual SQL server name can't be found.
Now, that's not the first time I'm doing this installation. Often I got in
the same problem, but by relaxing the local Policy (we are running very
restrictive GPO) usually resolved the problem. Therefore, I thing the problem
comes from the GPO restrictions. Also, I'm using the same domain account
used to install MSCS and I had no issues there.
My question is, what's the best way to approach this problem and what are
the MS-SQL requirements (in terms account permissions)?
The install account must be an admin on all nodes.
The MS task scheduler must be enabled on all nodes. <-- this is likely the
problem.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"kkantchev@.hotmail.com" <kkantchevhotmailcom@.discussions.microsoft.com>
wrote in message news:370B4F33-07E5-43A2-B4F3-4D0F485809AC@.microsoft.com...
> Hi everyone,
> I have problem installing MS-SQL 2000 enterprise on Windows Server 2003
> Ent.
> cluster. The message I'm getting is "Setup failed to perform required
> operations on the cluster nodes." The only thing "cluster.log" says in
> regards of the MS-SQL is that "the virtual SQL server name can't be found.
> Now, that's not the first time I'm doing this installation. Often I got in
> the same problem, but by relaxing the local Policy (we are running very
> restrictive GPO) usually resolved the problem. Therefore, I thing the
> problem
> comes from the GPO restrictions. Also, I'm using the same domain account
> used to install MSCS and I had no issues there.
> My question is, what's the best way to approach this problem and what are
> the MS-SQL requirements (in terms account permissions)?
|||Are you, or the cluster service account, also a Domain Admin? If not, then
you will need to have your Domain Admins create Domain Local Groups before
the installation.
Check out the installation logs; they contain the point of failure and
specifics about why it failed.
http://support.microsoft.com/kb/910228/en-us
http://msdn2.microsoft.com/en-us/library/ms143702.aspx
Good luck.
Sincerely,
Anthony Thomas
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OsZVE65SHHA.2256@.TK2MSFTNGP02.phx.gbl...
> The install account must be an admin on all nodes.
> The MS task scheduler must be enabled on all nodes. <-- this is likely
the
> problem.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "kkantchev@.hotmail.com" <kkantchevhotmailcom@.discussions.microsoft.com>
> wrote in message
news:370B4F33-07E5-43A2-B4F3-4D0F485809AC@.microsoft.com...[vbcol=seagreen]
found.[vbcol=seagreen]
in[vbcol=seagreen]
account[vbcol=seagreen]
are
>
sql
Showing posts with label ent. Show all posts
Showing posts with label ent. Show all posts
Friday, March 30, 2012
Friday, March 23, 2012
msmqtask.dll
I tried to install the ENT edition of 2005, the release version. I continue to get an error stating the the install was unable to build the type lib for Microsoft.SqlServer.MsmqTask.dll.
I tried multiple uninstalls scenaios, including cleaning the registry, cleaning the file system, using the cleanup tool from the CTP, and I uninstalled MSMQ.
I can not seem to find my way out of this bag. The net result is that I can not import an existing Database. At least that's the first problem I found.
LT
This is an issue when Microsoft.SqlServer.MSMQTask is left behind in COM+ catalog. You can workaround it by:
1. Open Administrative Tools\Component Services
2. Go to Component Services\Computers\My Computer\COM+ Applications
3. Delete Microsoft.SqlServer.MSMQTask
|||
And what if you get this error and the Microsoft.SqlServer.MSMQTask is not there?
I clicked on ignore eventually, but this should not be ok.
|||The error also happens due to invalid or not enough rights in all the HKCR\Microsoft.SqlServer.Dts.Tasks. ... keys. The administrator group has only read access. Setting all keys of this group to full access solves this problemmsmqtask.dll
I tried to install the ENT edition of 2005, the release version. I continue to get an error stating the the install was unable to build the type lib for Microsoft.SqlServer.MsmqTask.dll.
I tried multiple uninstalls scenaios, including cleaning the registry, cleaning the file system, using the cleanup tool from the CTP, and I uninstalled MSMQ.
I can not seem to find my way out of this bag. The net result is that I can not import an existing Database. At least that's the first problem I found.
LT
This is an issue when Microsoft.SqlServer.MSMQTask is left behind in COM+ catalog. You can workaround it by:
1. Open Administrative Tools\Component Services
2. Go to Component Services\Computers\My Computer\COM+ Applications
3. Delete Microsoft.SqlServer.MSMQTask
|||
And what if you get this error and the Microsoft.SqlServer.MSMQTask is not there?
I clicked on ignore eventually, but this should not be ok.
|||The error also happens due to invalid or not enough rights in all the HKCR\Microsoft.SqlServer.Dts.Tasks. ... keys. The administrator group has only read access. Setting all keys of this group to full access solves this problemmsmqtask.dll
I tried to install the ENT edition of 2005, the release version. I continue to get an error stating the the install was unable to build the type lib for Microsoft.SqlServer.MsmqTask.dll.
MessageQueueTask
MessageQueueTask.ServerCompMQTask
There might be a few others becuase I gave permissions to a few before I starts running REGMON.
I tried multiple uninstalls scenaios, including cleaning the registry, cleaning the file system, using the cleanup tool from the CTP, and I uninstalled MSMQ.
I can not seem to find my way out of this bag. The net result is that I can not import an existing Database. At least that's the first problem I found.
LT
This is an issue when Microsoft.SqlServer.MSMQTask is left behind in COM+ catalog. You can workaround it by:
1. Open Administrative Tools\Component Services
2. Go to Component Services\Computers\My Computer\COM+ Applications
3. Delete Microsoft.SqlServer.MSMQTask
|||
And what if you get this error and the Microsoft.SqlServer.MSMQTask is not there?
I clicked on ignore eventually, but this should not be ok.
|||The error also happens due to invalid or not enough rights in all the HKCR\Microsoft.SqlServer.Dts.Tasks. ... keys. The administrator group has only read access. Setting all keys of this group to full access solves this problem|||I found some access denied keys, HKCR\Microsoft.SqlServer.DTS.TAks.MessageQueueTask.DataFileMessage keys....MessageQueueTask
MessageQueueTask.ServerCompMQTask
There might be a few others becuase I gave permissions to a few before I starts running REGMON.
Monday, February 20, 2012
MSDTC - configure after the cluster install?
Hi,
Here is our newly built cluster configuration:
2 node
Active/Passive
Windows 2003 Ent.
SQL 2000 SP4
D:\ for SQL Data
E:\ for SQL Logs
2 cluster groups:
Cluster group
SQL group
SQL is running great, failover between nodes works good. However, during
the cluster install and the SQL install, we didnt configure a cluster
resource for the MS DTC. Our apps team needs to be able to run DTS packages
on this cluster. Now, I found this document
(http://www.sql-server-performance.com/rn_sql_server_clustering_2000_to_2005.asp)
that states the MS DTC must be configured ahead of the SQL install in a
cluster (page 3 of this document). So a few questions here:
1. Can MS DTC be configured in a cluster "after the fact"?
I am looking at this MS article that makes me think it can:
http://support.microsoft.com/?id=301600
2. Assuming it can be done, I am told the DTS packages are not many and not
large. We dont have the physical disk resources for MS DTC to have its own
physical disk. Should we put the MS DTC resource in the SQL Group and use
the D:\ drive?
3. IF (a big if) I could get the physical disk just for MS DTC, what would
be the recommended RAID level and disk size?
Thanks in advance to everyone...I am a server/SAN admin, not really a SQL
admin so any help is much appreciated.
JJP
>1. Can MS DTC be configured in a cluster "after the fact"?
Yes, should not be a problem. I have had to do this after an oops.
>2. Assuming it can be done, I am told the DTS packages are not many and not
>large. We dont have the physical disk resources for MS DTC to have its own
>physical disk. Should we put the MS DTC resource in the SQL Group and use
>the D:\ drive?
I know MSFT reccomends the DTC to receive its own disk and network name. In
most clusters I have successfully installed and worked with I have put MSDTC
on the cluster group itself and used the Quorum drive with success. I don't
know how that effects supportability but we had no issues as a result of
that configuration.
>3.) ..Disk size..
The MSDTC space requirements in my experience have not been very large. That
is why the Quorum drive worked. We were using linked servers to Oracle and
using distributed transactions and the space was not an issue. We only had a
few GB of space involved.
"JJP" <anonymous@.microsoft.com> wrote in message
news:udGwDx8oHHA.3772@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Here is our newly built cluster configuration:
> 2 node
> Active/Passive
> Windows 2003 Ent.
> SQL 2000 SP4
> D:\ for SQL Data
> E:\ for SQL Logs
> 2 cluster groups:
> Cluster group
> SQL group
> SQL is running great, failover between nodes works good. However, during
> the cluster install and the SQL install, we didnt configure a cluster
> resource for the MS DTC. Our apps team needs to be able to run DTS
> packages on this cluster. Now, I found this document
> (http://www.sql-server-performance.com/rn_sql_server_clustering_2000_to_2005.asp)
> that states the MS DTC must be configured ahead of the SQL install in a
> cluster (page 3 of this document). So a few questions here:
> 1. Can MS DTC be configured in a cluster "after the fact"?
> I am looking at this MS article that makes me think it can:
> http://support.microsoft.com/?id=301600
> 2. Assuming it can be done, I am told the DTS packages are not many and
> not large. We dont have the physical disk resources for MS DTC to have
> its own physical disk. Should we put the MS DTC resource in the SQL Group
> and use the D:\ drive?
> 3. IF (a big if) I could get the physical disk just for MS DTC, what would
> be the recommended RAID level and disk size?
> Thanks in advance to everyone...I am a server/SAN admin, not really a SQL
> admin so any help is much appreciated.
> JJP
>
|||>>3.) ..Disk size..
>We only had a few GB of space involved.
Mike,
Sound like you have many GB quorum drive and only few GB is used, right?
Scary…
OK
"Mike Walsh" wrote:
> Yes, should not be a problem. I have had to do this after an oops.
>
> I know MSFT reccomends the DTC to receive its own disk and network name. In
> most clusters I have successfully installed and worked with I have put MSDTC
> on the cluster group itself and used the Quorum drive with success. I don't
> know how that effects supportability but we had no issues as a result of
> that configuration.
>
> The MSDTC space requirements in my experience have not been very large. That
> is why the Quorum drive worked. We were using linked servers to Oracle and
> using distributed transactions and the space was not an issue. We only had a
> few GB of space involved.
>
>
>
>
>
> "JJP" <anonymous@.microsoft.com> wrote in message
> news:udGwDx8oHHA.3772@.TK2MSFTNGP03.phx.gbl...
>
>
|||> Mike,
> Sound like you have many GB quorum drive and only few GB is used, right?
> Scary.
> OK
I have a small quorom drive (only a 1 or 2gb) and hardly any space is being
used.
Why is this scary? The quorum drive is not a space hungry drive and it is
used simply as a space for cluster "communications" and health checks...
"OK" <OK@.discussions.microsoft.com> wrote in message
news:34F59400-A315-499D-90F1-81E19126DA40@.microsoft.com...[vbcol=seagreen]
> Mike,
> Sound like you have many GB quorum drive and only few GB is used, right?
> Scary.
> OK
>
> "Mike Walsh" wrote:
|||Scary would be “having multi-gigabytes quorum drive, with only few gigabytes
used for MSDTC transactions”! ;-)
"Mike Walsh" wrote:
> I have a small quorom drive (only a 1 or 2gb) and hardly any space is being
> used.
> Why is this scary? The quorum drive is not a space hungry drive and it is
> used simply as a space for cluster "communications" and health checks...
> "OK" <OK@.discussions.microsoft.com> wrote in message
> news:34F59400-A315-499D-90F1-81E19126DA40@.microsoft.com...
>
>
Here is our newly built cluster configuration:
2 node
Active/Passive
Windows 2003 Ent.
SQL 2000 SP4
D:\ for SQL Data
E:\ for SQL Logs
2 cluster groups:
Cluster group
SQL group
SQL is running great, failover between nodes works good. However, during
the cluster install and the SQL install, we didnt configure a cluster
resource for the MS DTC. Our apps team needs to be able to run DTS packages
on this cluster. Now, I found this document
(http://www.sql-server-performance.com/rn_sql_server_clustering_2000_to_2005.asp)
that states the MS DTC must be configured ahead of the SQL install in a
cluster (page 3 of this document). So a few questions here:
1. Can MS DTC be configured in a cluster "after the fact"?
I am looking at this MS article that makes me think it can:
http://support.microsoft.com/?id=301600
2. Assuming it can be done, I am told the DTS packages are not many and not
large. We dont have the physical disk resources for MS DTC to have its own
physical disk. Should we put the MS DTC resource in the SQL Group and use
the D:\ drive?
3. IF (a big if) I could get the physical disk just for MS DTC, what would
be the recommended RAID level and disk size?
Thanks in advance to everyone...I am a server/SAN admin, not really a SQL
admin so any help is much appreciated.
JJP
>1. Can MS DTC be configured in a cluster "after the fact"?
Yes, should not be a problem. I have had to do this after an oops.
>2. Assuming it can be done, I am told the DTS packages are not many and not
>large. We dont have the physical disk resources for MS DTC to have its own
>physical disk. Should we put the MS DTC resource in the SQL Group and use
>the D:\ drive?
I know MSFT reccomends the DTC to receive its own disk and network name. In
most clusters I have successfully installed and worked with I have put MSDTC
on the cluster group itself and used the Quorum drive with success. I don't
know how that effects supportability but we had no issues as a result of
that configuration.
>3.) ..Disk size..
The MSDTC space requirements in my experience have not been very large. That
is why the Quorum drive worked. We were using linked servers to Oracle and
using distributed transactions and the space was not an issue. We only had a
few GB of space involved.
"JJP" <anonymous@.microsoft.com> wrote in message
news:udGwDx8oHHA.3772@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Here is our newly built cluster configuration:
> 2 node
> Active/Passive
> Windows 2003 Ent.
> SQL 2000 SP4
> D:\ for SQL Data
> E:\ for SQL Logs
> 2 cluster groups:
> Cluster group
> SQL group
> SQL is running great, failover between nodes works good. However, during
> the cluster install and the SQL install, we didnt configure a cluster
> resource for the MS DTC. Our apps team needs to be able to run DTS
> packages on this cluster. Now, I found this document
> (http://www.sql-server-performance.com/rn_sql_server_clustering_2000_to_2005.asp)
> that states the MS DTC must be configured ahead of the SQL install in a
> cluster (page 3 of this document). So a few questions here:
> 1. Can MS DTC be configured in a cluster "after the fact"?
> I am looking at this MS article that makes me think it can:
> http://support.microsoft.com/?id=301600
> 2. Assuming it can be done, I am told the DTS packages are not many and
> not large. We dont have the physical disk resources for MS DTC to have
> its own physical disk. Should we put the MS DTC resource in the SQL Group
> and use the D:\ drive?
> 3. IF (a big if) I could get the physical disk just for MS DTC, what would
> be the recommended RAID level and disk size?
> Thanks in advance to everyone...I am a server/SAN admin, not really a SQL
> admin so any help is much appreciated.
> JJP
>
|||>>3.) ..Disk size..
>We only had a few GB of space involved.
Mike,
Sound like you have many GB quorum drive and only few GB is used, right?
Scary…
OK
"Mike Walsh" wrote:
> Yes, should not be a problem. I have had to do this after an oops.
>
> I know MSFT reccomends the DTC to receive its own disk and network name. In
> most clusters I have successfully installed and worked with I have put MSDTC
> on the cluster group itself and used the Quorum drive with success. I don't
> know how that effects supportability but we had no issues as a result of
> that configuration.
>
> The MSDTC space requirements in my experience have not been very large. That
> is why the Quorum drive worked. We were using linked servers to Oracle and
> using distributed transactions and the space was not an issue. We only had a
> few GB of space involved.
>
>
>
>
>
> "JJP" <anonymous@.microsoft.com> wrote in message
> news:udGwDx8oHHA.3772@.TK2MSFTNGP03.phx.gbl...
>
>
|||> Mike,
> Sound like you have many GB quorum drive and only few GB is used, right?
> Scary.
> OK
I have a small quorom drive (only a 1 or 2gb) and hardly any space is being
used.
Why is this scary? The quorum drive is not a space hungry drive and it is
used simply as a space for cluster "communications" and health checks...
"OK" <OK@.discussions.microsoft.com> wrote in message
news:34F59400-A315-499D-90F1-81E19126DA40@.microsoft.com...[vbcol=seagreen]
> Mike,
> Sound like you have many GB quorum drive and only few GB is used, right?
> Scary.
> OK
>
> "Mike Walsh" wrote:
|||Scary would be “having multi-gigabytes quorum drive, with only few gigabytes
used for MSDTC transactions”! ;-)
"Mike Walsh" wrote:
> I have a small quorom drive (only a 1 or 2gb) and hardly any space is being
> used.
> Why is this scary? The quorum drive is not a space hungry drive and it is
> used simply as a space for cluster "communications" and health checks...
> "OK" <OK@.discussions.microsoft.com> wrote in message
> news:34F59400-A315-499D-90F1-81E19126DA40@.microsoft.com...
>
>
Subscribe to:
Posts (Atom)