Re: Domain Admin login failure.

Instead of relying on administrator permissions, add that login as a
specific login in SQL Server. Then it won't need it's admin privileges.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"TW" <TW@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:62E71E19-F8A1-4570-821D-D6AA73EC3598@xxxxxxxxxxxxxxxx
I think I found the issue! If I tell the management studio to run as
administrator, it will let my domain admin account login.

I'm assuming in order to get around this, one would have to disable UAC and
run everything elevated?

"TW" wrote:

I installed SQL Server 2005 RTM on Windows Server 2008. I immediately
rebooted the server and installed SQL 2005 Service Pack 2; I did not run the
Vista wizard at the end.

I am having an issue where I can log into the SQL server using the SA
password or the local administrator account, but get a login failure when
trying to logon using a domain admin account (domain admins is in the local
administrators group).

Any ideas?


.

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: Connextion Error After Installing SQL Server 2005 on Vista
    ... Your suggestion of right clicking and running as an admin worked perfectly. ... I right clicked the first login above and selected Properties. ... The solution is to explicitly grant Bob access to SQL Server. ... During the installation, I was prompted a couple of times to install a service pack for Visual Studio 2005, which is not currently installed. ...
    (microsoft.public.sqlserver.connect)
  • 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: Windows Vista Enterprise and SQL Server 2005 Agent
    ... 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. ... It all seems to be related to security things, even though I am an administrator. ... I loaded SQL Server Management Studio the other day and decided to start the SQL Agent service. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2005 login with Windows Authentication
    ... I obviously installed SQL Server using my Francois (admin) local user ... So having stated that I chose windows authentication as ... And the reason for this is that a Windows login also can have access ...
    (microsoft.public.sqlserver.security)