I have a SQL Server 2008 database server that was set up by another
individual several months. My windows user account that I log into the
server is listed in the Administrator group. When I try to view the SQL
Server 2008 errorlog I receive the error listed below.

Cannot show requested dialog (sqlMgmt)

xp_regread() returned error 5,'Access is denied.'

Please help me resolve this issue.

Thanks,

Seems like the SQL Server service account don't have appropriate
permission on whatever it tries to do against the registry (you can
trace the xp_regread call from SSMS using Profiler). My first thing to
do would be to verify/set/set-and-reset the service account using "SQL
Server Configuration Manager".

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Joe K." <JoeK (AT) discussions (DOT) microsoft.com> wrote

Joe
Do you use Vista OS?


"Joe K." <JoeK (AT) discussions (DOT) microsoft.com> wrote