I noticed the following after changing the password for the SQL 2005 Service
Accounts.

– I could not longer edit or create Maintenance Plans.
– error returned 0x80004005 (Client unable to establish connection)
In the SQL error log I found
Server Microsoft SQL Server 2005 – 9.00.1399.06 (X64)
Oct 14 2005 00:35:21
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
.
.
Server FallBack certificate initialization failed with error code: 1.
Server Warning:Encryption is not available, could not find a valid
certificate to load.
.
.
Logon The prelogin packet used to open the connection is structurally
invalid; the connection has been closed. Please contact the vendor of the
client library. [CLIENT: ]
Logon Error: 17828, Severity: 20, State: 3.

*** Note that SQL is running on
Windows Server 2003 R2 Standard x64 edition Service Pack 1

It is also a domain controller.

Any ideas?

Thanks


06-07-06 12:21 AM

Hi,

I was having this exact same problem, here is what resolved this issue
for me:

1. Go to C:\Documents and Settings\”sql startup account”\Application
Data\Microsoft\Crypto\RSA\S-1-5-21……
(where “sql startup account” should be the name of your startup account
for sql server”)

2 Backup and then delete any files in the S-1-5-21etcetc folder. (but
don’t delete the folder)

3. Restart SQL Server.

HTH.


06-08-06 12:21 AM

Yes that did it!
Thank You Very Much