Windows Vista Enterprise and SQL Server 2005 Agent

I am new to Windows Vista and have installed SQL Server 2005 on my machine. One thing I have noticed is getting prompted all the time to do things I used to be able to do without being prompt. It all seems to be related to security things, even though I am an administrator.

Anyway, to get to my questionn. I loaded SQL Server Management Studio the other day and decided to start the SQL Agent service. It would not start because it said Access Denied. Now, if my user account is an administrator, I don't see how this can be. Anyway, I have noticed on if I right-click on the icon to run Management Studio i have the option to "Run as Administrator". I notice if I choose this option I can start Agent.

I've also noticed the same thing with Visual Studio.Net 2008. If I load like I normally do, I cannot save any of my files to the inetpub\wwwroot folder. But, if I right click on the VS 2008 icon and run as Administrator, i can save my files.

Why do I have to do this. I'd setup my user account as administrator and shouldn't have to specifically run the applications with a different option selected.

Why does the software behave this way, and how can I stop this from happening?

.

Relevant Pages

  • Re: shortcut to Run As Administrator
    ... What I currently do is right-click on the program name and choose "Run as Administrator", but if there is a way to create such an icon on my desktop, that would be a great time-saver. ... If you are looking to avoid the continue prompt, ...
    (microsoft.public.windows.vista.file_management)
  • 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: Eventvwr.msc doesnt open
    ... It does require me to enter the Administrator password after I click Event Viewer. ... I get the same prompt if I right-click and choose Run as Administrator. ... Search the internet with error code matching, ...
    (microsoft.public.windows.vista.general)
  • Re: Linked Table Password
    ... Prompt When Opening Linked Table" - ... recreating the links to the SQL Server ... > relationships again after the automated process. ... These connections can be DSN or DSN-less connections, ...
    (microsoft.public.access.security)
  • Re: UAC Questions
    ... At the User Account Control dialog box for the Microsoft Management ... the No Prompt setting is NOT recommended. ... elevation would permit UAC applications to launch administrator applications ... Behavior of the elevation prompt for standard users setting. ...
    (microsoft.public.windows.vista.general)