When running SQL2K5 on W2K3 and creating a sql server login w/ both
CHECK_EXPIRATION and CHECK_POLICY set to ON, which password plicy will take
effect if there is both a local policy on that server and a domain policy
affecting that server? Generally, domain policy will take precedence over a
local policy, but SQL2K5 does not address this detail and which will take
effect. I've hunted down lots of documentation, but none of it seems clear.
Thanks.SQL Server doesn't deal with this issue. It simply hits the security API.
The domain policy will override the local policy which is by design in
Windows. SQL Server simply abides by what Windows enforces.
Mike Hotek
MHS Enterprises, Inc
http://www.mssqlserver.com
"DisgruntledTechGuy" <DisgruntledTechGuy@.discussions.microsoft.com> wrote in
message news:12CC258C-C990-47C0-A36D-6EEC39E42A03@.microsoft.com...
> When running SQL2K5 on W2K3 and creating a sql server login w/ both
> CHECK_EXPIRATION and CHECK_POLICY set to ON, which password plicy will
> take
> effect if there is both a local policy on that server and a domain policy
> affecting that server? Generally, domain policy will take precedence over
> a
> local policy, but SQL2K5 does not address this detail and which will take
> effect. I've hunted down lots of documentation, but none of it seems
> clear.
> Thanks.|||Thanks Mike. That's what I figured, but documentation out there was ambiguo
us.
"Michael Hotek" wrote:
> SQL Server doesn't deal with this issue. It simply hits the security API.
> The domain policy will override the local policy which is by design in
> Windows. SQL Server simply abides by what Windows enforces.
> --
> Mike Hotek
> MHS Enterprises, Inc
> http://www.mssqlserver.com
>
> "DisgruntledTechGuy" <DisgruntledTechGuy@.discussions.microsoft.com> wrote
in
> message news:12CC258C-C990-47C0-A36D-6EEC39E42A03@.microsoft.com...
>
>sql
Showing posts with label w2k3. Show all posts
Showing posts with label w2k3. Show all posts
Wednesday, March 28, 2012
Tuesday, March 20, 2012
Post SP Install issue
We have a active/active W2K3 SQL cluster with 3 instances that was upgraded
to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
problems.
However, when applying the hotix only the first instance upgraded correctly.
The hotfix install for instances 2 and 3 indicated success but the version
for both still shows build 2139. Can't seem to get the install to work for
these instances. Any help would be appreciated.Hi
You may want to re-contact PSS for this as this is a PSS only hotfix!
John
"GManino" wrote:
> We have a active/active W2K3 SQL cluster with 3 instances that was upgraded
> to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> problems.
> However, when applying the hotix only the first instance upgraded correctly.
> The hotfix install for instances 2 and 3 indicated success but the version
> for both still shows build 2139. Can't seem to get the install to work for
> these instances. Any help would be appreciated.|||Hi
Your answer is Windows Task Scheduler.
See http://msmvps.com/epprecht/archive/2005/08/28/64380.aspx
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"GManino" <GManino@.discussions.microsoft.com> wrote in message
news:9BBD59DE-12E8-4A0C-AA9B-61B25D031BB3@.microsoft.com...
> We have a active/active W2K3 SQL cluster with 3 instances that was
> upgraded
> to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> problems.
> However, when applying the hotix only the first instance upgraded
> correctly.
> The hotfix install for instances 2 and 3 indicated success but the version
> for both still shows build 2139. Can't seem to get the install to work
> for
> these instances. Any help would be appreciated.|||Does anyone know if this will work for all types of corruption?
"John Bell" wrote:
> Hi
> You may want to re-contact PSS for this as this is a PSS only hotfix!
> John
> "GManino" wrote:
> > We have a active/active W2K3 SQL cluster with 3 instances that was upgraded
> > to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> > problems.
> >
> > However, when applying the hotix only the first instance upgraded correctly.
> > The hotfix install for instances 2 and 3 indicated success but the version
> > for both still shows build 2139. Can't seem to get the install to work for
> > these instances. Any help would be appreciated.
to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
problems.
However, when applying the hotix only the first instance upgraded correctly.
The hotfix install for instances 2 and 3 indicated success but the version
for both still shows build 2139. Can't seem to get the install to work for
these instances. Any help would be appreciated.Hi
You may want to re-contact PSS for this as this is a PSS only hotfix!
John
"GManino" wrote:
> We have a active/active W2K3 SQL cluster with 3 instances that was upgraded
> to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> problems.
> However, when applying the hotix only the first instance upgraded correctly.
> The hotfix install for instances 2 and 3 indicated success but the version
> for both still shows build 2139. Can't seem to get the install to work for
> these instances. Any help would be appreciated.|||Hi
Your answer is Windows Task Scheduler.
See http://msmvps.com/epprecht/archive/2005/08/28/64380.aspx
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"GManino" <GManino@.discussions.microsoft.com> wrote in message
news:9BBD59DE-12E8-4A0C-AA9B-61B25D031BB3@.microsoft.com...
> We have a active/active W2K3 SQL cluster with 3 instances that was
> upgraded
> to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> problems.
> However, when applying the hotix only the first instance upgraded
> correctly.
> The hotfix install for instances 2 and 3 indicated success but the version
> for both still shows build 2139. Can't seem to get the install to work
> for
> these instances. Any help would be appreciated.|||Does anyone know if this will work for all types of corruption?
"John Bell" wrote:
> Hi
> You may want to re-contact PSS for this as this is a PSS only hotfix!
> John
> "GManino" wrote:
> > We have a active/active W2K3 SQL cluster with 3 instances that was upgraded
> > to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> > problems.
> >
> > However, when applying the hotix only the first instance upgraded correctly.
> > The hotfix install for instances 2 and 3 indicated success but the version
> > for both still shows build 2139. Can't seem to get the install to work for
> > these instances. Any help would be appreciated.
Post SP Install issue
We have a active/active W2K3 SQL cluster with 3 instances that was upgraded
to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
problems.
However, when applying the hotix only the first instance upgraded correctly.
The hotfix install for instances 2 and 3 indicated success but the version
for both still shows build 2139. Can't seem to get the install to work for
these instances. Any help would be appreciated.
Hi
You may want to re-contact PSS for this as this is a PSS only hotfix!
John
"GManino" wrote:
> We have a active/active W2K3 SQL cluster with 3 instances that was upgraded
> to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> problems.
> However, when applying the hotix only the first instance upgraded correctly.
> The hotfix install for instances 2 and 3 indicated success but the version
> for both still shows build 2139. Can't seem to get the install to work for
> these instances. Any help would be appreciated.
|||Hi
Your answer is Windows Task Scheduler.
See http://msmvps.com/epprecht/archive/2.../28/64380.aspx
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"GManino" <GManino@.discussions.microsoft.com> wrote in message
news:9BBD59DE-12E8-4A0C-AA9B-61B25D031BB3@.microsoft.com...
> We have a active/active W2K3 SQL cluster with 3 instances that was
> upgraded
> to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> problems.
> However, when applying the hotix only the first instance upgraded
> correctly.
> The hotfix install for instances 2 and 3 indicated success but the version
> for both still shows build 2139. Can't seem to get the install to work
> for
> these instances. Any help would be appreciated.
|||Does anyone know if this will work for all types of corruption?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> You may want to re-contact PSS for this as this is a PSS only hotfix!
> John
> "GManino" wrote:
to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
problems.
However, when applying the hotix only the first instance upgraded correctly.
The hotfix install for instances 2 and 3 indicated success but the version
for both still shows build 2139. Can't seem to get the install to work for
these instances. Any help would be appreciated.
Hi
You may want to re-contact PSS for this as this is a PSS only hotfix!
John
"GManino" wrote:
> We have a active/active W2K3 SQL cluster with 3 instances that was upgraded
> to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> problems.
> However, when applying the hotix only the first instance upgraded correctly.
> The hotfix install for instances 2 and 3 indicated success but the version
> for both still shows build 2139. Can't seem to get the install to work for
> these instances. Any help would be appreciated.
|||Hi
Your answer is Windows Task Scheduler.
See http://msmvps.com/epprecht/archive/2.../28/64380.aspx
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"GManino" <GManino@.discussions.microsoft.com> wrote in message
news:9BBD59DE-12E8-4A0C-AA9B-61B25D031BB3@.microsoft.com...
> We have a active/active W2K3 SQL cluster with 3 instances that was
> upgraded
> to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> problems.
> However, when applying the hotix only the first instance upgraded
> correctly.
> The hotfix install for instances 2 and 3 indicated success but the version
> for both still shows build 2139. Can't seem to get the install to work
> for
> these instances. Any help would be appreciated.
|||Does anyone know if this will work for all types of corruption?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> You may want to re-contact PSS for this as this is a PSS only hotfix!
> John
> "GManino" wrote:
Post SP Install issue
We have a active/active W2K3 SQL cluster with 3 instances that was upgraded
to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
problems.
However, when applying the hotix only the first instance upgraded correctly.
The hotfix install for instances 2 and 3 indicated success but the version
for both still shows build 2139. Can't seem to get the install to work for
these instances. Any help would be appreciated.Hi
You may want to re-contact PSS for this as this is a PSS only hotfix!
John
"GManino" wrote:
> We have a active/active W2K3 SQL cluster with 3 instances that was upgrade
d
> to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> problems.
> However, when applying the hotix only the first instance upgraded correctl
y.
> The hotfix install for instances 2 and 3 indicated success but the versio
n
> for both still shows build 2139. Can't seem to get the install to work fo
r
> these instances. Any help would be appreciated.|||Hi
Your answer is Windows Task Scheduler.
See http://msmvps.com/epprecht/archive/...8/28/64380.aspx
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"GManino" <GManino@.discussions.microsoft.com> wrote in message
news:9BBD59DE-12E8-4A0C-AA9B-61B25D031BB3@.microsoft.com...
> We have a active/active W2K3 SQL cluster with 3 instances that was
> upgraded
> to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> problems.
> However, when applying the hotix only the first instance upgraded
> correctly.
> The hotfix install for instances 2 and 3 indicated success but the version
> for both still shows build 2139. Can't seem to get the install to work
> for
> these instances. Any help would be appreciated.|||Does anyone know if this will work for all types of corruption?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> You may want to re-contact PSS for this as this is a PSS only hotfix!
> John
> "GManino" wrote:
>
to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
problems.
However, when applying the hotix only the first instance upgraded correctly.
The hotfix install for instances 2 and 3 indicated success but the version
for both still shows build 2139. Can't seem to get the install to work for
these instances. Any help would be appreciated.Hi
You may want to re-contact PSS for this as this is a PSS only hotfix!
John
"GManino" wrote:
> We have a active/active W2K3 SQL cluster with 3 instances that was upgrade
d
> to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> problems.
> However, when applying the hotix only the first instance upgraded correctl
y.
> The hotfix install for instances 2 and 3 indicated success but the versio
n
> for both still shows build 2139. Can't seem to get the install to work fo
r
> these instances. Any help would be appreciated.|||Hi
Your answer is Windows Task Scheduler.
See http://msmvps.com/epprecht/archive/...8/28/64380.aspx
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"GManino" <GManino@.discussions.microsoft.com> wrote in message
news:9BBD59DE-12E8-4A0C-AA9B-61B25D031BB3@.microsoft.com...
> We have a active/active W2K3 SQL cluster with 3 instances that was
> upgraded
> to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> problems.
> However, when applying the hotix only the first instance upgraded
> correctly.
> The hotfix install for instances 2 and 3 indicated success but the version
> for both still shows build 2139. Can't seem to get the install to work
> for
> these instances. Any help would be appreciated.|||Does anyone know if this will work for all types of corruption?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> You may want to re-contact PSS for this as this is a PSS only hotfix!
> John
> "GManino" wrote:
>
Subscribe to:
Posts (Atom)