Re: Domain user in SysAdmin Role (SQL Server on Windows Vista)
- From: "Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 4 Dec 2006 06:43:42 -0600
How add a domain user in the sysadmin role of SQL Server 2005?
To add to Uri's response, you might also need to add the login before adding the login to the sysadmin server role:
CREATE LOGIN [ACOCACH\JOHN]
FROM WINDOWS;
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Max André Bündchen" <nospam@xxxxxxxxxxxxx> wrote in message news:FCB171E9-5EDD-4EA5-8467-4B07A507A298@xxxxxxxxxxxxxxxx
I installed Windows Vista from MSDN and SQL Server 2005 plus SP1. The SP2 is in CTP stage so I would don't install it for now.
Following this instructions I try solve the authenticate problem in Windows Vista for SQL Server 2005: http://www.microsoft.com/sql/howtobuy/windowsvistasupport.mspx
In my case the user account to add in sysadmin role is under a domain. The domain is ACOCACH and the user is JOHN. I try add that but the SQL Server 2005 don't find the ACOCACH\JOHN nor JOHN.ACOCACH even when I'm log in as JOHN in the machine (JOHN is admin of the machine). When I browsing the only local machine users are aviable for add as a sysadmin.
How add a domain user in the sysadmin role of SQL Server 2005?
.
- References:
- Domain user in SysAdmin Role (SQL Server on Windows Vista)
- From: Max André Bündchen
- Domain user in SysAdmin Role (SQL Server on Windows Vista)
- Prev by Date: Re: Domain user in SysAdmin Role (SQL Server on Windows Vista)
- Next by Date: Re: how to decrypt an encrypted stored proc in 2005
- Previous by thread: Re: Domain user in SysAdmin Role (SQL Server on Windows Vista)
- Next by thread: Re: Domain user in SysAdmin Role (SQL Server on Windows Vista)
- Index(es):
Relevant Pages
|
