Link to home
Start Free TrialLog in
Avatar of LEONEL ROCHA
LEONEL ROCHAFlag for Uruguay

asked on

sql server 2008 express server authentication mode

I got the following error when I tried to modify Server Authentication mode to SQL Server and Windows Authentication mode:

xp_regread() returned error 5, 'Access is denied.' (Microsoft SQL Server, Error: 220001)

Any suggestions?
Avatar of Jean-Bernard VERNEJOUX
Jean-Bernard VERNEJOUX
Flag of France image

Is your account member of the SYSADMIN role ?

Is your accound member of Windows Local administrators group ?
Avatar of LEONEL ROCHA

ASKER

My OS is Windows 7 Home Premium and my account type is Administrator
FYI: I can`t set SYSADMIN role to my account. Also I can`t create any database
ASKER CERTIFIED SOLUTION
Avatar of Jean-Bernard VERNEJOUX
Jean-Bernard VERNEJOUX
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
UAC is disabled. Sorry for the delay in my response.  Finally I uninstalled 2008 Express and installed 2005 express and I solved my problem.

So I'll accept your last comment as a solution in order to reward your effort

Thanks!