Cannot install Sql 2005 SP2, Error: Your Account information Could not be verified

Hi all,

I am running a named instance of SQL Server 2005 Enterprise Edition, side by side with named instance of SQL Server 2000 in Windows Server 2003. When I start the installation. I am unable to proceed from authentication stage.

The error description for Database Services and Reporting Services under both sa and windows authentication mode is: Encryption not supported on client Sqlcmd error: Microsoft SQL Native client: Client Unable to establish connection

In Service Manager, all SQL Server 2005 services are running with Logon as Administrator, and I am also able to connect to SSAS, SSRS, SSIS via Management studio both via Windows authentication and sa account information.

Would you please inform if I have to change any security settings before SP2 installation here.

How to add myself a Sql Server Administrator. The link in Surface Area Configuration to Add new Administrator doesn't work.

Hi,

I tried repairing the Sql Server Native Client via Add/ Remove Programs. After successfully repairing, SP2 installation went fine.

Thanks

Subhash Subramanyam

|||

Hi,

I 'm having the same trouble. I've just tired to repair instalation of SQL NativeClient, but the resupl is still the same.

In part of instalation in verifing of accounts , there is status "Login failed".

I'm not able to solve this issue. Please , encounter somebody this trouble?

|||

Hi Barlo,

Are you using a local account (Windows authentication), If so then make sure you have NT Administrator privileges while installing. In my case I run all the services under local account. If you are doing the same, verify the type of account installed. Run Services.msc -> For all the Sql 2005 Services running -> properties -> log on with local account. Make sure that you are able to connect to all the services.

Still if you face error during authentication mode, Please look at the error instructions on the third column in the table on authentication modes for list of services, after it prompts the error. e.g: Table might show that Reporting Services and Database cannot connect, since native client failed..