Re: Windows Vista Enterprise and SQL Server 2005 Agent

And there is no reason to run Management Studio as an administrator. You just need to make sure that the login that you are using has it's own login in SQL Server, and that the login being used by the SQL Server Agent is a member of the SQL Server sysadmin fixed server role.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message news:DBF33B31-D848-4CFF-ACBD-4F5568EE7007@xxxxxxxxxxxxxxxx
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: MSSQL$SBSMONITORING Login to Disabled Account?
    ... SQL Server installed, I can't have the tools you were using, can I? ... I still don't know what that process is doing trying to login to the ... Administrator account and I don't understand why this login attempt is ...
    (microsoft.public.windows.server.sbs)
  • Re: Domain Admin login failure.
    ... specific login in SQL Server. ... Then it won't need it's admin privileges. ... Rick Byham, SQL Server Books Online ... administrator, it will let my domain admin account login. ...
    (microsoft.public.sqlserver.security)
  • Re: Builtin Administrators Group and SQL Agent Jobs
    ... >gave that login full access to all SQL DB's. ... >group and rights to all the SQL Server databases. ... >Administrator Server role explicitly. ... >account that is a member of the DBA group and this group ...
    (microsoft.public.sqlserver.security)
  • Re: Back up on remote computer.
    ... Do the Administrator account have the same password on the two machines? ... Tibor Karaszi, SQL Server MVP ... The error says that location of the (backup) file ... Create a login on the SQL host computer. ...
    (microsoft.public.sqlserver.server)
  • 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)