Hi all, I had 2 questions regarding clusters:-
1. Is it possible to have an Active-Active configuration with 1 instance
running 2000 & 1 instance running 2005?
2. Is it recommended or required to have cluster servers part of an active
directory domain? Currently we have 2 servers that are part of our domain
and we are contemplating using them for a cluster. They meet all the
hardware & software requirements, but need to check on AD.
TIA!
Yes to both.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
<param@.community.nospam> wrote in message
news:OHeRQR$RGHA.440@.TK2MSFTNGP10.phx.gbl...
Hi all, I had 2 questions regarding clusters:-
1. Is it possible to have an Active-Active configuration with 1 instance
running 2000 & 1 instance running 2005?
2. Is it recommended or required to have cluster servers part of an active
directory domain? Currently we have 2 servers that are part of our domain
and we are contemplating using them for a cluster. They meet all the
hardware & software requirements, but need to check on AD.
TIA!
|||Yes to both. I have run side-by-side installations of 2000 and 2005 in both
clustered and non-clustered environments. Everything works, including both
sets of client tools.
As for #2, cluster nodes must be members of a domain, either NT4 or Active
Directory. They must be member servers, not domain controllers.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<param@.community.nospam> wrote in message
news:OHeRQR$RGHA.440@.TK2MSFTNGP10.phx.gbl...
> Hi all, I had 2 questions regarding clusters:-
> 1. Is it possible to have an Active-Active configuration with 1 instance
> running 2000 & 1 instance running 2005?
> 2. Is it recommended or required to have cluster servers part of an active
> directory domain? Currently we have 2 servers that are part of our domain
> and we are contemplating using them for a cluster. They meet all the
> hardware & software requirements, but need to check on AD.
> TIA!
>
|||So the consensus is that I would need the cluster servers to be member of a
domain... thanks
If I am new to setting up a cluster, is there a document/resource cheat
guide I can read to get up to speed?
TIA
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:eWMfUyESGHA.4920@.tk2msftngp13.phx.gbl...
> Yes to both. I have run side-by-side installations of 2000 and 2005 in
> both clustered and non-clustered environments. Everything works,
> including both sets of client tools.
> As for #2, cluster nodes must be members of a domain, either NT4 or
> Active Directory. They must be member servers, not domain controllers.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> <param@.community.nospam> wrote in message
> news:OHeRQR$RGHA.440@.TK2MSFTNGP10.phx.gbl...
>
Showing posts with label configuration. Show all posts
Showing posts with label configuration. Show all posts
Tuesday, March 27, 2012
cluster questions
Labels:
active-active,
cluster,
clusters-1,
configuration,
database,
instance,
instancerunning,
microsoft,
mysql,
oracle,
regarding,
server,
sql
Sunday, March 25, 2012
cluster installation.
Hi ,
I have cluster with 2 nodes (sql 2000 on win 2003 ) and i want to install
active/passive configuration .
for that configuration for my understanding i need named instanced let say
SQLPROD and my vitual server name
is SQLPROD so the name instance will be SQLPROD\SQLPROD this is all very
clear but i do not know
which ip address to specifiy in installation of the sql server when he ask
for ip for virtual sql server.
SQLPROD has an ip address
The IP addr will be what you assign it. You can't use an existing IP, don't
try using the Cluster's IP addr, the install won't let you. The IP addr you
assign must also be in the public address subnet for the cluster.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"w2system5" <none@.none.com> wrote in message
news:cpgtcb$cbg$1@.news2.netvision.net.il...
> Hi ,
> I have cluster with 2 nodes (sql 2000 on win 2003 ) and i want to install
> active/passive configuration .
> for that configuration for my understanding i need named instanced let say
> SQLPROD and my vitual server name
> is SQLPROD so the name instance will be SQLPROD\SQLPROD this is all very
> clear but i do not know
> which ip address to specifiy in installation of the sql server when he ask
> for ip for virtual sql server.
> SQLPROD has an ip address
>
|||It's asking for a new IP Address to use for SQL Server. In total you will
need four:
- Physical node A
- Physical node B
- Virtual Cluster
- Virtual SQL
"w2system5" <none@.none.com> wrote in message
news:cpgtcb$cbg$1@.news2.netvision.net.il...
> Hi ,
> I have cluster with 2 nodes (sql 2000 on win 2003 ) and i want to install
> active/passive configuration .
> for that configuration for my understanding i need named instanced let say
> SQLPROD and my vitual server name
> is SQLPROD so the name instance will be SQLPROD\SQLPROD this is all very
> clear but i do not know
> which ip address to specifiy in installation of the sql server when he ask
> for ip for virtual sql server.
> SQLPROD has an ip address
>
|||You will also need a heartbeat IP for each node. This IP can be
whatever you want.
For example:
192.168.1.1 - Node 1 Heartbeat
192.168.1.2 - Node 2 Heartbeat
Thanks,
Peter
On Thu, 13 Jan 2005 11:40:19 -0000, "Christian Bolton [MSFT]"
<christian.online@.microsoft.com> wrote:
>It's asking for a new IP Address to use for SQL Server. In total you will
>need four:
>- Physical node A
>- Physical node B
>- Virtual Cluster
>- Virtual SQL
>"w2system5" <none@.none.com> wrote in message
>news:cpgtcb$cbg$1@.news2.netvision.net.il...
>
I have cluster with 2 nodes (sql 2000 on win 2003 ) and i want to install
active/passive configuration .
for that configuration for my understanding i need named instanced let say
SQLPROD and my vitual server name
is SQLPROD so the name instance will be SQLPROD\SQLPROD this is all very
clear but i do not know
which ip address to specifiy in installation of the sql server when he ask
for ip for virtual sql server.
SQLPROD has an ip address
The IP addr will be what you assign it. You can't use an existing IP, don't
try using the Cluster's IP addr, the install won't let you. The IP addr you
assign must also be in the public address subnet for the cluster.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"w2system5" <none@.none.com> wrote in message
news:cpgtcb$cbg$1@.news2.netvision.net.il...
> Hi ,
> I have cluster with 2 nodes (sql 2000 on win 2003 ) and i want to install
> active/passive configuration .
> for that configuration for my understanding i need named instanced let say
> SQLPROD and my vitual server name
> is SQLPROD so the name instance will be SQLPROD\SQLPROD this is all very
> clear but i do not know
> which ip address to specifiy in installation of the sql server when he ask
> for ip for virtual sql server.
> SQLPROD has an ip address
>
|||It's asking for a new IP Address to use for SQL Server. In total you will
need four:
- Physical node A
- Physical node B
- Virtual Cluster
- Virtual SQL
"w2system5" <none@.none.com> wrote in message
news:cpgtcb$cbg$1@.news2.netvision.net.il...
> Hi ,
> I have cluster with 2 nodes (sql 2000 on win 2003 ) and i want to install
> active/passive configuration .
> for that configuration for my understanding i need named instanced let say
> SQLPROD and my vitual server name
> is SQLPROD so the name instance will be SQLPROD\SQLPROD this is all very
> clear but i do not know
> which ip address to specifiy in installation of the sql server when he ask
> for ip for virtual sql server.
> SQLPROD has an ip address
>
|||You will also need a heartbeat IP for each node. This IP can be
whatever you want.
For example:
192.168.1.1 - Node 1 Heartbeat
192.168.1.2 - Node 2 Heartbeat
Thanks,
Peter
On Thu, 13 Jan 2005 11:40:19 -0000, "Christian Bolton [MSFT]"
<christian.online@.microsoft.com> wrote:
>It's asking for a new IP Address to use for SQL Server. In total you will
>need four:
>- Physical node A
>- Physical node B
>- Virtual Cluster
>- Virtual SQL
>"w2system5" <none@.none.com> wrote in message
>news:cpgtcb$cbg$1@.news2.netvision.net.il...
>
Labels:
cluster,
configuration,
database,
installactive,
installation,
microsoft,
mysql,
nodes,
oracle,
passive,
server,
sql,
win
Tuesday, March 20, 2012
Cluster does not restart SQL group after network failure
All,
We have just rebuilt a SQL 7.0/NT cluster with Windows 2003/SQL2000 in an
active/passive configuration using 2 nodes. During the course of testing it
we had a general network failure in which the network was unavailable. The
virtual SQL and Windows IP address resources went down and did not come up
automatically once the network was available again. The nodes are configured
for automatic failback.
I can't imagine that in the 2 1/2 years the original cluster was running
that we never once had the network go down, but I do know that during that
time I never had a outage where I had to manually move the cluster group
(which causes the cluster to re-initialize both resources and brings
everything back to normal).
I'm thinking that maybe I'm missing a dependency somewhere or something's
changed between NT and 2003 that I'm not accounting for. Anyone seen this or
have any tips? Thanks in advance!
-Dan
Nope, that is pretty much expected behavior. The cluster manager will try
and restart the resources on each possible node until the retry count is
exhausted. Unfortunately, until the network resource is restored, no node
has the ability to run the SQL group. With the physical network port
offline, the IP address(es) will not come online. Nothing dependant on them
will come online, including the Network Name and the SQL Server. If the
network comes back before the retry timeout and count is exhausted, the
cluster will bring the system online. Otherwise it stays down.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:74592016-0B61-4834-8C28-1AD1B864B688@.microsoft.com...
> All,
> We have just rebuilt a SQL 7.0/NT cluster with Windows 2003/SQL2000 in
an
> active/passive configuration using 2 nodes. During the course of testing
it
> we had a general network failure in which the network was unavailable.
The
> virtual SQL and Windows IP address resources went down and did not come up
> automatically once the network was available again. The nodes are
configured
> for automatic failback.
> I can't imagine that in the 2 1/2 years the original cluster was running
> that we never once had the network go down, but I do know that during that
> time I never had a outage where I had to manually move the cluster group
> (which causes the cluster to re-initialize both resources and brings
> everything back to normal).
> I'm thinking that maybe I'm missing a dependency somewhere or something's
> changed between NT and 2003 that I'm not accounting for. Anyone seen this
or
> have any tips? Thanks in advance!
> -Dan
|||Geoff,
Thanks for the post! I guess I'll just have to make sure the retry &
timeout are set high.
"Geoff N. Hiten" wrote:
> Nope, that is pretty much expected behavior. The cluster manager will try
> and restart the resources on each possible node until the retry count is
> exhausted. Unfortunately, until the network resource is restored, no node
> has the ability to run the SQL group. With the physical network port
> offline, the IP address(es) will not come online. Nothing dependant on them
> will come online, including the Network Name and the SQL Server. If the
> network comes back before the retry timeout and count is exhausted, the
> cluster will bring the system online. Otherwise it stays down.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Dan" <Dan@.discussions.microsoft.com> wrote in message
> news:74592016-0B61-4834-8C28-1AD1B864B688@.microsoft.com...
> an
> it
> The
> configured
> or
>
>
|||Be careful adjusting those numbers. TOo high can cause just as many
problems as too low. Given the frequency of the network outage and the fact
that something like that will NEVER go unnoticed, I would not change
anything. The cluster failover is designed to reduce the typical 30-45
minute human reponse time for a down server. You shouldn't expect the
clustering software do deal with anything beyond that scope. Adjusting the
parameters to try and expand that coverage will only expose a gap somewhere
else. Just document a cluster check as part of your network failure
recovery procedure and you will be fine.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:34AB2749-41BF-4A68-8E55-04AEAAE75C38@.microsoft.com...[vbcol=seagreen]
> Geoff,
> Thanks for the post! I guess I'll just have to make sure the retry &
> timeout are set high.
> "Geoff N. Hiten" wrote:
try[vbcol=seagreen]
node[vbcol=seagreen]
them[vbcol=seagreen]
in[vbcol=seagreen]
testing[vbcol=seagreen]
come up[vbcol=seagreen]
running[vbcol=seagreen]
that[vbcol=seagreen]
group[vbcol=seagreen]
something's[vbcol=seagreen]
this[vbcol=seagreen]
We have just rebuilt a SQL 7.0/NT cluster with Windows 2003/SQL2000 in an
active/passive configuration using 2 nodes. During the course of testing it
we had a general network failure in which the network was unavailable. The
virtual SQL and Windows IP address resources went down and did not come up
automatically once the network was available again. The nodes are configured
for automatic failback.
I can't imagine that in the 2 1/2 years the original cluster was running
that we never once had the network go down, but I do know that during that
time I never had a outage where I had to manually move the cluster group
(which causes the cluster to re-initialize both resources and brings
everything back to normal).
I'm thinking that maybe I'm missing a dependency somewhere or something's
changed between NT and 2003 that I'm not accounting for. Anyone seen this or
have any tips? Thanks in advance!
-Dan
Nope, that is pretty much expected behavior. The cluster manager will try
and restart the resources on each possible node until the retry count is
exhausted. Unfortunately, until the network resource is restored, no node
has the ability to run the SQL group. With the physical network port
offline, the IP address(es) will not come online. Nothing dependant on them
will come online, including the Network Name and the SQL Server. If the
network comes back before the retry timeout and count is exhausted, the
cluster will bring the system online. Otherwise it stays down.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:74592016-0B61-4834-8C28-1AD1B864B688@.microsoft.com...
> All,
> We have just rebuilt a SQL 7.0/NT cluster with Windows 2003/SQL2000 in
an
> active/passive configuration using 2 nodes. During the course of testing
it
> we had a general network failure in which the network was unavailable.
The
> virtual SQL and Windows IP address resources went down and did not come up
> automatically once the network was available again. The nodes are
configured
> for automatic failback.
> I can't imagine that in the 2 1/2 years the original cluster was running
> that we never once had the network go down, but I do know that during that
> time I never had a outage where I had to manually move the cluster group
> (which causes the cluster to re-initialize both resources and brings
> everything back to normal).
> I'm thinking that maybe I'm missing a dependency somewhere or something's
> changed between NT and 2003 that I'm not accounting for. Anyone seen this
or
> have any tips? Thanks in advance!
> -Dan
|||Geoff,
Thanks for the post! I guess I'll just have to make sure the retry &
timeout are set high.
"Geoff N. Hiten" wrote:
> Nope, that is pretty much expected behavior. The cluster manager will try
> and restart the resources on each possible node until the retry count is
> exhausted. Unfortunately, until the network resource is restored, no node
> has the ability to run the SQL group. With the physical network port
> offline, the IP address(es) will not come online. Nothing dependant on them
> will come online, including the Network Name and the SQL Server. If the
> network comes back before the retry timeout and count is exhausted, the
> cluster will bring the system online. Otherwise it stays down.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Dan" <Dan@.discussions.microsoft.com> wrote in message
> news:74592016-0B61-4834-8C28-1AD1B864B688@.microsoft.com...
> an
> it
> The
> configured
> or
>
>
|||Be careful adjusting those numbers. TOo high can cause just as many
problems as too low. Given the frequency of the network outage and the fact
that something like that will NEVER go unnoticed, I would not change
anything. The cluster failover is designed to reduce the typical 30-45
minute human reponse time for a down server. You shouldn't expect the
clustering software do deal with anything beyond that scope. Adjusting the
parameters to try and expand that coverage will only expose a gap somewhere
else. Just document a cluster check as part of your network failure
recovery procedure and you will be fine.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:34AB2749-41BF-4A68-8E55-04AEAAE75C38@.microsoft.com...[vbcol=seagreen]
> Geoff,
> Thanks for the post! I guess I'll just have to make sure the retry &
> timeout are set high.
> "Geoff N. Hiten" wrote:
try[vbcol=seagreen]
node[vbcol=seagreen]
them[vbcol=seagreen]
in[vbcol=seagreen]
testing[vbcol=seagreen]
come up[vbcol=seagreen]
running[vbcol=seagreen]
that[vbcol=seagreen]
group[vbcol=seagreen]
something's[vbcol=seagreen]
this[vbcol=seagreen]
Thursday, March 8, 2012
CLR Configuration option problem
Hai,
I develope one application using .Net framework 2.0 and sql server
2005.Some time the following message displayed
Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
configuration option
how to redtify the error
Regards
T.A.Krishna
Hi
"Krishna" wrote:
> Hai,
> I develope one application using .Net framework 2.0 and sql server
> 2005.Some time the following message displayed
> Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
> configuration option
>
This error normally refers to the 'CLR Integration' setting, which you can
set by using the Surface Area Configuration (SAC) tool. If you choose to set
the option by feature then under Database Engine you can see 'CLR
Integration' and the Enable CLR Integration checked box should be checked.
> how to redtify the error
> Regards
> T.A.Krishna
John
|||Krishna wrote:
> Hai,
> I develope one application using .Net framework 2.0 and sql server
> 2005.Some time the following message displayed
> Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
> configuration option
CLR integration is disabled by default.
You must change the configuration option:
EXEC sp_configure 'clr enabled', 1;
RECONFIGURE;
Best regards,
Marcin Guzowski
http://guzowski.info
I develope one application using .Net framework 2.0 and sql server
2005.Some time the following message displayed
Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
configuration option
how to redtify the error
Regards
T.A.Krishna
Hi
"Krishna" wrote:
> Hai,
> I develope one application using .Net framework 2.0 and sql server
> 2005.Some time the following message displayed
> Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
> configuration option
>
This error normally refers to the 'CLR Integration' setting, which you can
set by using the Surface Area Configuration (SAC) tool. If you choose to set
the option by feature then under Database Engine you can see 'CLR
Integration' and the Enable CLR Integration checked box should be checked.
> how to redtify the error
> Regards
> T.A.Krishna
John
|||Krishna wrote:
> Hai,
> I develope one application using .Net framework 2.0 and sql server
> 2005.Some time the following message displayed
> Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
> configuration option
CLR integration is disabled by default.
You must change the configuration option:
EXEC sp_configure 'clr enabled', 1;
RECONFIGURE;
Best regards,
Marcin Guzowski
http://guzowski.info
Labels:
application,
clr,
code,
configuration,
database,
develope,
displayedexceution,
following,
framework,
hai,
message,
microsoft,
mysql,
net,
oracle,
server,
server2005,
sql,
time,
user
Wednesday, March 7, 2012
CLR Configuration option problem
Hai,
I develope one application using .Net framework 2.0 and sql server
2005.Some time the following message displayed
Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
configuration option
how to redtify the error
Regards
T.A.KrishnaHi
"Krishna" wrote:
> Hai,
> I develope one application using .Net framework 2.0 and sql server
> 2005.Some time the following message displayed
> Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
> configuration option
>
This error normally refers to the 'CLR Integration' setting, which you can
set by using the Surface Area Configuration (SAC) tool. If you choose to set
the option by feature then under Database Engine you can see 'CLR
Integration' and the Enable CLR Integration checked box should be checked.
> how to redtify the error
> Regards
> T.A.Krishna
John|||Krishna wrote:
> Hai,
> I develope one application using .Net framework 2.0 and sql server
> 2005.Some time the following message displayed
> Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
> configuration option
CLR integration is disabled by default.
You must change the configuration option:
EXEC sp_configure 'clr enabled', 1;
RECONFIGURE;
Best regards,
Marcin Guzowski
http://guzowski.info
I develope one application using .Net framework 2.0 and sql server
2005.Some time the following message displayed
Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
configuration option
how to redtify the error
Regards
T.A.KrishnaHi
"Krishna" wrote:
> Hai,
> I develope one application using .Net framework 2.0 and sql server
> 2005.Some time the following message displayed
> Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
> configuration option
>
This error normally refers to the 'CLR Integration' setting, which you can
set by using the Surface Area Configuration (SAC) tool. If you choose to set
the option by feature then under Database Engine you can see 'CLR
Integration' and the Enable CLR Integration checked box should be checked.
> how to redtify the error
> Regards
> T.A.Krishna
John|||Krishna wrote:
> Hai,
> I develope one application using .Net framework 2.0 and sql server
> 2005.Some time the following message displayed
> Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
> configuration option
CLR integration is disabled by default.
You must change the configuration option:
EXEC sp_configure 'clr enabled', 1;
RECONFIGURE;
Best regards,
Marcin Guzowski
http://guzowski.info
CLR Configuration option problem
Hai,
I develope one application using .Net framework 2.0 and sql server
2005.Some time the following message displayed
Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
configuration option
how to redtify the error
Regards
T.A.KrishnaHi
"Krishna" wrote:
> Hai,
> I develope one application using .Net framework 2.0 and sql server
> 2005.Some time the following message displayed
> Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
> configuration option
>
This error normally refers to the 'CLR Integration' setting, which you can
set by using the Surface Area Configuration (SAC) tool. If you choose to set
the option by feature then under Database Engine you can see 'CLR
Integration' and the Enable CLR Integration checked box should be checked.
> how to redtify the error
> Regards
> T.A.Krishna
John|||Krishna wrote:
> Hai,
> I develope one application using .Net framework 2.0 and sql server
> 2005.Some time the following message displayed
> Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
> configuration option
CLR integration is disabled by default.
You must change the configuration option:
EXEC sp_configure 'clr enabled', 1;
RECONFIGURE;
Best regards,
Marcin Guzowski
http://guzowski.info
I develope one application using .Net framework 2.0 and sql server
2005.Some time the following message displayed
Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
configuration option
how to redtify the error
Regards
T.A.KrishnaHi
"Krishna" wrote:
> Hai,
> I develope one application using .Net framework 2.0 and sql server
> 2005.Some time the following message displayed
> Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
> configuration option
>
This error normally refers to the 'CLR Integration' setting, which you can
set by using the Surface Area Configuration (SAC) tool. If you choose to set
the option by feature then under Database Engine you can see 'CLR
Integration' and the Enable CLR Integration checked box should be checked.
> how to redtify the error
> Regards
> T.A.Krishna
John|||Krishna wrote:
> Hai,
> I develope one application using .Net framework 2.0 and sql server
> 2005.Some time the following message displayed
> Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
> configuration option
CLR integration is disabled by default.
You must change the configuration option:
EXEC sp_configure 'clr enabled', 1;
RECONFIGURE;
Best regards,
Marcin Guzowski
http://guzowski.info
Labels:
application,
clr,
code,
configuration,
database,
develope,
displayedexceution,
following,
framework,
hai,
message,
microsoft,
mysql,
net,
oracle,
server,
server2005,
sql,
time,
user
Friday, February 24, 2012
Clients not installing
Getting this error...
SMS Client Configuration Manager cannot connect to the machine
"ComputerName". The operating system reported error 1314: A required
privilege is not held by the client.
Possible cause: The client is not accessible.
Solution: Verify that the client is connected to the network and that the
SMS Service account or (if specified) the SMS Client Remote Installation
account have the required privileges, as specified in the SMS documentation.
Does the account I specified in Connection Accounts need to have local admin
perms? How can I double check?
Jason
Crap wrong group...sorry.
"JasonMeyer" <jason.meyer@.nospam.isd623.org> wrote in message
news:euwoiFFPFHA.3072@.TK2MSFTNGP09.phx.gbl...
> Getting this error...
> SMS Client Configuration Manager cannot connect to the machine
> "ComputerName". The operating system reported error 1314: A required
> privilege is not held by the client.
> Possible cause: The client is not accessible.
> Solution: Verify that the client is connected to the network and that the
> SMS Service account or (if specified) the SMS Client Remote Installation
> account have the required privileges, as specified in the SMS
> documentation.
> Does the account I specified in Connection Accounts need to have local
> admin perms? How can I double check?
> Jason
>
SMS Client Configuration Manager cannot connect to the machine
"ComputerName". The operating system reported error 1314: A required
privilege is not held by the client.
Possible cause: The client is not accessible.
Solution: Verify that the client is connected to the network and that the
SMS Service account or (if specified) the SMS Client Remote Installation
account have the required privileges, as specified in the SMS documentation.
Does the account I specified in Connection Accounts need to have local admin
perms? How can I double check?
Jason
Crap wrong group...sorry.
"JasonMeyer" <jason.meyer@.nospam.isd623.org> wrote in message
news:euwoiFFPFHA.3072@.TK2MSFTNGP09.phx.gbl...
> Getting this error...
> SMS Client Configuration Manager cannot connect to the machine
> "ComputerName". The operating system reported error 1314: A required
> privilege is not held by the client.
> Possible cause: The client is not accessible.
> Solution: Verify that the client is connected to the network and that the
> SMS Service account or (if specified) the SMS Client Remote Installation
> account have the required privileges, as specified in the SMS
> documentation.
> Does the account I specified in Connection Accounts need to have local
> admin perms? How can I double check?
> Jason
>
Subscribe to:
Posts (Atom)