Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
groston
Yak Posting Veteran
61 Posts |
 Posted - 2005-06-03 : 12:26:18
|
| On a Windows 2003 Server machine running SQL Server 2000 SP3a.Problem: In Enterprise Manager, I right click on the local server and select properties. In the General tab, I check the box 'Autostart SQL Server Agent'. When I click OK, I get the following error: Error 2202: RegCreateKeyEx() returned error 5, 'Access is denied.'Notes: I am using remote desktop and am logged into the server as Administrator. SQL Server is configured to allow both SQL Server and Windows Authentication. The Startup service account is a non-priveleged user account whose only group membership is Users. Regarding Logins - both BUILTIN\Adminstrators and HOSTNAME\Administrator are assigned the role sysadmin.It is vitally important that I get this working as I need this to perform backups. Please help! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-03 : 13:46:59
|
quote:
The Startup service account is a non-priveleged user account whose only group membership is Users
The service accounts should be members of the local admin group.Tara |
 |
|
|
groston
Yak Posting Veteran
61 Posts |
Posted - 2005-06-03 : 13:49:42
|
| tduggan,Are you sure about that? I thought that good security practice demanded that it NOT be a member of the admin group. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-03 : 13:53:55
|
| That has always been the recommendation for SQL Server service accounts. In fact, it's required if you are going to setup SQL Mail.Have you tried changing the service properties from the Services applet instead of via Enterprise Manager. Does the Application Log give more information as to what the problem is?Tara |
|
|
|
|
|
|
Starting SQL Server Agent problem