SQL Server 2005 setup

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello,

While attempting to setting up a new user account on a laptop on which SQL Server 2005 Developer edition is installed I receve an error in SQL Server 2005 Surface Area Configuration. I started surface area configuration with 'run as administrator' and appropriately logged in with an administrative account. When attempting to start the Analysis Services service I receive the following message:

"The service did not respond to the start or control request in a timely fashion, you need administrator priviledges to be able to start/stop this service. (SQLSAC)"

Why do I get this error and how do I remedy it?

Additionally:
A few minures earlier I made the user login a member of the SQL Server SysAdmin role on this machine. I also made the user login a member of the Analysis Services Administrators role on this machine. When I attempt to open SQL Server 2005 Surface Area Configuration with the user login that does not work.

Please help me know what I am missing.

Thanks,
Douglas

.

Relevant Pages

  • Re: SQL Server user account
    ... After reading the online docs about what permissions are required for the user account, I decided it might be easier to uninstall/reinstall SQL Server. ... LocalSystem is almost as bad as Administrator when the machine is a DC. ... SQL Server doesn't generally require any special privileges - so any user account you choose to use for the SQL service account does not need to be an administrator. ...
    (microsoft.public.windows.server.sbs)
  • Re: Permission question - another one
    ... I would have thought that Administrator ... Are you asking why is it connecting to SQL Server? ... > and I gave BUILTIN/Administrator this database as its default database. ...
    (microsoft.public.sqlserver.programming)
  • Re: Windows Vista Enterprise and SQL Server 2005 Agent
    ... This has nothing to do with SQL Server and this is an expected behaviour of Windows Vista operating systems. ... Cause of those popups and normal-user-like acting is some new security system called User Account Control. ... It all seems to be related to security things, even though I am an administrator. ...
    (microsoft.public.sqlserver.security)
  • Re: Fresh installation and no access
    ... You're not getting access because you're not an administrator when you log ... In previous OS's you had administrator permissions on the database ... You must create a login (to allow connect to SQL Server) then a user to be ...
    (microsoft.public.sqlserver.security)
  • Re: Permission question - another one
    ... SQL Server looks at when you try to connect using Windows Authentication. ... >>> Does your Windows Login TRAVAC/tfs belong to the local Administrators ... >> Are you talking about on Raptor? ... > I am assuming local administrator is in local users and groups from ...
    (microsoft.public.sqlserver.programming)