I noticed the following after changing the password for the SQL 2005 Service
– 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.
06-07-06 12:21 AM
I was having this exact same problem, here is what resolved this issue
1. Go to C:\Documents and Settings\”sql startup account”\Application
(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.
06-08-06 12:21 AM
Yes that did it!
Thank You Very Much