Application Center Administration - Authentication error

Author

Authentication error

captainjims

2006-08-03, 7:22 pm

I've got a 3 node cluster built on Windows 2003 Web Edition with SP1. I've
installed the hotfix 891330 (file versions are correct).

When I try to check App Center events I get the error "failed to
authenticate, or connect to, SQL server (0xc0140060)" for the last two nodes
(primary node doesn't seem to have this problem).

I've made sure the ACL_servername account has "logon as a batch job" rights.

The SQLAgent$MSAC service isn't started on the two nodes that are reporting
the error - I can start it manually, but it shuts down immediately stating
that it will shut down automatically if there is no work to do.

Any ideas on what could be causing this?

George Cheng [MSFT]

2006-08-03, 7:22 pm

You might check the size of the databases and make sure its not near 2
gigs. Also you may set the following

HKLM\SOFTWARE\Microsoft\Microsoft SQL
Server\MSAC\MSSQLServer\SuperSocketNetLi
b
Certificate = 0 (REG_SZ)

309398 SQL Server 2000 installation or local connections fail with "SSL
http://support.microsoft.com/?id=309398

Thank You

George Cheng

Application Center2000/Index Server/Commerce Server Support

Application Center 2000 SP2 and Windows 2003 SP1
891330 You may experience problems after you install Windows Server 2003
Service Pack 1 on a server that is running Application Center 2000

http://download.microsoft.com/downl...15-a4f3-7218096
89d65/HotfixQFE891330.exe

Note: This article has no warranties implicit or explicit.
All the content is given on the "as is" basis and the user
takes full responsibility for its use and assumption.
Microsoft Corporation Copyright 2005
All Rights Reserved

--------------------
| Thread-Topic: Authentication error
| thread-index: Aca3BEbnMTKo27mFQjqnhg7BYFZ98Q==
| X-WBNR-Posting-Host: 192.131.85.3
| From: =?Utf-8?B?Y2FwdGFpbmppbXM=?= <captainjims@discussions.microsoft.com>
| Subject: Authentication error
| Date: Thu, 3 Aug 2006 06:54:02 -0700
| Lines: 14
| Message-ID: <1EB9D129-C5F0-42F8-BD89-FEE6D6018259@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
| Newsgroups: microsoft.public.applicationcenter.admin
| Path: TK2MSFTNGXA01.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.applicationcenter.admin:6662
| NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
| X-Tomcat-NG: microsoft.public.applicationcenter.admin
|
| I've got a 3 node cluster built on Windows 2003 Web Edition with SP1.
I've
| installed the hotfix 891330 (file versions are correct).
|
| When I try to check App Center events I get the error "failed to
| authenticate, or connect to, SQL server (0xc0140060)" for the last two
nodes
| (primary node doesn't seem to have this problem).
|
| I've made sure the ACL_servername account has "logon as a batch job"
rights.
|
| The SQLAgent$MSAC service isn't started on the two nodes that are
reporting
| the error - I can start it manually, but it shuts down immediately
stating
| that it will shut down automatically if there is no work to do.
|
| Any ideas on what could be causing this?
|

captainjims

2006-08-04, 1:28 pm

George,

Are you saying I should add that string? Because I don't currently have a
"Certificate" string under that key.

The database isn't near 2GB so I'm good there.

Does it matter that I'm running Web Edition? I'm reading the readme file and
it seems there are a lot of quirks when dealing with Web Edition. I've
already edited the Administration site so it's not requiring SSL.

Thanks,

Jimmy

""George Cheng [MSFT]"" wrote:

> You might check the size of the databases and make sure its not near 2
> gigs. Also you may set the following
>
> HKLM\SOFTWARE\Microsoft\Microsoft SQL
> Server\MSAC\MSSQLServer\SuperSocketNetLi
b
> Certificate = 0 (REG_SZ)
>
> 309398 SQL Server 2000 installation or local connections fail with "SSL
> http://support.microsoft.com/?id=309398
>
> Thank You
>
> George Cheng
>
> Application Center2000/Index Server/Commerce Server Support
>
> Application Center 2000 SP2 and Windows 2003 SP1
> 891330 You may experience problems after you install Windows Server 2003
> Service Pack 1 on a server that is running Application Center 2000
>
> http://download.microsoft.com/downl...15-a4f3-7218096
> 89d65/HotfixQFE891330.exe
>
> Note: This article has no warranties implicit or explicit.
> All the content is given on the "as is" basis and the user
> takes full responsibility for its use and assumption.
> Microsoft Corporation Copyright 2005
> All Rights Reserved
>
> --------------------
> | Thread-Topic: Authentication error
> | thread-index: Aca3BEbnMTKo27mFQjqnhg7BYFZ98Q==
> | X-WBNR-Posting-Host: 192.131.85.3
> | From: =?Utf-8?B?Y2FwdGFpbmppbXM=?= <captainjims@discussions.microsoft.com>
> | Subject: Authentication error
> | Date: Thu, 3 Aug 2006 06:54:02 -0700
> | Lines: 14
> | Message-ID: <1EB9D129-C5F0-42F8-BD89-FEE6D6018259@microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
> | Newsgroups: microsoft.public.applicationcenter.admin
> | Path: TK2MSFTNGXA01.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.applicationcenter.admin:6662
> | NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> | X-Tomcat-NG: microsoft.public.applicationcenter.admin
> |
> | I've got a 3 node cluster built on Windows 2003 Web Edition with SP1.
> I've
> | installed the hotfix 891330 (file versions are correct).
> |
> | When I try to check App Center events I get the error "failed to
> | authenticate, or connect to, SQL server (0xc0140060)" for the last two
> nodes
> | (primary node doesn't seem to have this problem).
> |
> | I've made sure the ACL_servername account has "logon as a batch job"
> rights.
> |
> | The SQLAgent$MSAC service isn't started on the two nodes that are
> reporting
> | the error - I can start it manually, but it shuts down immediately
> stating
> | that it will shut down automatically if there is no work to do.
> |
> | Any ideas on what could be causing this?
> |
>
>

George Cheng [MSFT]

2006-08-07, 7:19 pm

captainjims

2006-08-07, 7:19 pm

Hi George,

I've added that string and rebooted both members and am still getting the
same error when accessing the events. My application log on the secondary
node is also flooded with App Center errors since it can't connect properly.

Is there anything else I could try?

Thanks,

Jimmy

""George Cheng [MSFT]"" wrote:

> Yes add that registry key and reboot. It shouldn't matter about web
> edition as long as all machines in the cluster are web edition.
>
> Thank You
>
> George Cheng
>
> Application Center2000/Index Server/Commerce Server Support
>
> Application Center 2000 SP2 and Windows 2003 SP1
> 891330 You may experience problems after you install Windows Server 2003
> Service Pack 1 on a server that is running Application Center 2000
>
> http://download.microsoft.com/downl...15-a4f3-7218096
> 89d65/HotfixQFE891330.exe
>
> Note: This article has no warranties implicit or explicit.
> All the content is given on the "as is" basis and the user
> takes full responsibility for its use and assumption.
> Microsoft Corporation Copyright 2005
> All Rights Reserved
>
> --------------------
> | Thread-Topic: Authentication error
> | thread-index: Aca34kHQMQyO1iqMQwuR07ZSHDCGEw==
> | X-WBNR-Posting-Host: 192.131.85.3
> | From: =?Utf-8?B?Y2FwdGFpbmppbXM=?= <captainjims@discussions.microsoft.com>
> | References: <1EB9D129-C5F0-42F8-BD89-FEE6D6018259@microsoft.com>
> <GYUaBwytGHA.3920@TK2MSFTNGXA01.phx.gbl>
> | Subject: RE: Authentication error
> | Date: Fri, 4 Aug 2006 09:23:02 -0700
> | Lines: 92
> | Message-ID: <01930EC1-1B12-465C-AC8E-F5AA6A850726@microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
> | Newsgroups: microsoft.public.applicationcenter.admin
> | Path: TK2MSFTNGXA01.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.applicationcenter.admin:6666
> | NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> | X-Tomcat-NG: microsoft.public.applicationcenter.admin
> |
> | George,
> |
> | Are you saying I should add that string? Because I don't currently have a
> | "Certificate" string under that key.
> |
> | The database isn't near 2GB so I'm good there.
> |
> | Does it matter that I'm running Web Edition? I'm reading the readme file
> and
> | it seems there are a lot of quirks when dealing with Web Edition. I've
> | already edited the Administration site so it's not requiring SSL.
> |
> | Thanks,
> |
> | Jimmy
> |
> | ""George Cheng [MSFT]"" wrote:
> |
> | > You might check the size of the databases and make sure its not near 2
> | > gigs. Also you may set the following
> | >
> | > HKLM\SOFTWARE\Microsoft\Microsoft SQL
> | > Server\MSAC\MSSQLServer\SuperSocketNetLi
b
> | > Certificate = 0 (REG_SZ)
> | >
> | > 309398 SQL Server 2000 installation or local connections fail with "SSL
> | > http://support.microsoft.com/?id=309398
> | >
> | > Thank You
> | >
> | > George Cheng
> | >
> | > Application Center2000/Index Server/Commerce Server Support
> | >
> | > Application Center 2000 SP2 and Windows 2003 SP1
> | > 891330 You may experience problems after you install Windows Server
> 2003
> | > Service Pack 1 on a server that is running Application Center 2000
> | >
> | >
> http://download.microsoft.com/downl...15-a4f3-7218096
> | > 89d65/HotfixQFE891330.exe
> | >
> | > Note: This article has no warranties implicit or explicit.
> | > All the content is given on the "as is" basis and the user
> | > takes full responsibility for its use and assumption.
> | > Microsoft Corporation Copyright 2005
> | > All Rights Reserved
> | >
> | > --------------------
> | > | Thread-Topic: Authentication error
> | > | thread-index: Aca3BEbnMTKo27mFQjqnhg7BYFZ98Q==
> | > | X-WBNR-Posting-Host: 192.131.85.3
> | > | From: =?Utf-8?B?Y2FwdGFpbmppbXM=?=
> <captainjims@discussions.microsoft.com>
> | > | Subject: Authentication error
> | > | Date: Thu, 3 Aug 2006 06:54:02 -0700
> | > | Lines: 14
> | > | Message-ID: <1EB9D129-C5F0-42F8-BD89-FEE6D6018259@microsoft.com>
> | > | MIME-Version: 1.0
> | > | Content-Type: text/plain;
> | > | charset="Utf-8"
> | > | Content-Transfer-Encoding: 7bit
> | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | Content-Class: urn:content-classes:message
> | > | Importance: normal
> | > | Priority: normal
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
> | > | Newsgroups: microsoft.public.applicationcenter.admin
> | > | Path: TK2MSFTNGXA01.phx.gbl
> | > | Xref: TK2MSFTNGXA01.phx.gbl
> microsoft.public.applicationcenter.admin:6662
> | > | NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> | > | X-Tomcat-NG: microsoft.public.applicationcenter.admin
> | > |
> | > | I've got a 3 node cluster built on Windows 2003 Web Edition with SP1.
> | > I've
> | > | installed the hotfix 891330 (file versions are correct).
> | > |
> | > | When I try to check App Center events I get the error "failed to
> | > | authenticate, or connect to, SQL server (0xc0140060)" for the last
> two
> | > nodes
> | > | (primary node doesn't seem to have this problem).
> | > |
> | > | I've made sure the ACL_servername account has "logon as a batch job"
> | > rights.
> | > |
> | > | The SQLAgent$MSAC service isn't started on the two nodes that are
> | > reporting
> | > | the error - I can start it manually, but it shuts down immediately
> | > stating
> | > | that it will shut down automatically if there is no work to do.
> | > |
> | > | Any ideas on what could be causing this?
> | > |
> | >
> | >
> |
>
>