Re: Windows Vista Enterprise and SQL Server 2005 Agent

Hello Greg,

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. When this system is on, you have rights as much as a normal user has unless you claim for it (by right clicking and running as administrator...)

You can turn this on or off from Control Panel\User Accounts. However before configuring this option I suggest you to have more information about it. For this purpose, you can benefit from the following links:

http://www.microsoft.com/windows/windows-vista/features/user-account-control.aspx

http://technet2.microsoft.com/windowsserver2008/en/library/0d75f774-8514-4c9e-ac08-4c21f5c6c2d91033.mspx?mfr=true

--
Ekrem Önsoy



"Greg Setnes" <gjsetnes@xxxxxxx> wrote in message news:ED95A5E4-4B35-4622-A179-91D47AB6D053@xxxxxxxxxxxxxxxx
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: 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)
  • SQL Server 2005 setup
    ... 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. ... "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. ... A few minures earlier I made the user login a member of the SQL Server SysAdmin role on this machine. ...
    (microsoft.public.sqlserver.setup)
  • Re: administrative privileges
    ... You must logon as an administrator in order to elevate your user account to ... Access database to sql server 2005, or create a new database in sql server ...
    (microsoft.public.windowsxp.newusers)
  • Re: Full Text catalog not working
    ... Looking for a SQL Server replication book? ... cannot be administered under the present user account. ... I am administrator, and as far as i can see both SQL and MS Search are ...
    (microsoft.public.sqlserver.fulltext)
  • 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)