| Author |
Domain user in SysAdmin Role (SQL Server on Windows Vista)
|
|
| Max André Bündchen 2006-12-04, 7:13 pm |
| 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/howtob...stasupport.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?
| |
| Uri Dimant 2006-12-04, 7:13 pm |
| Hi
EXEC sp_addsrvrolemember 'Domain\Account', 'sysadmin';
"Max André Bündchen" <nospam@microsoft.com> wrote in message
news:FCB171E9-5EDD-4EA5-8467- 4B07A507A298@microso
ft.com...
>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/howtob...stasupport.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?
| |
| Dan Guzman 2006-12-04, 7:13 pm |
| > 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@microsoft.com> wrote in message
news:FCB171E9-5EDD-4EA5-8467- 4B07A507A298@microso
ft.com...
>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/howtob...stasupport.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?
| |
| Max André Bündchen 2006-12-04, 7:13 pm |
| Thanks guys, it worked very well. Why this one doesn´t work in the wizard
but just in the query mode?
"Max André Bündchen" <nospam@microsoft.com> wrote in message
news:FCB171E9-5EDD-4EA5-8467- 4B07A507A298@microso
ft.com...
>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/howtob...stasupport.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?
| |
| Dan Guzman 2006-12-05, 12:12 am |
| > Thanks guys, it worked very well. Why this one doesn´t work in the wizard
> but just in the query mode?
You need to add the login before you can add the login to a server role.
You could also add the login using the domain GUI, although there might be
issues with doing that under Vista without SQL SP2. You might also need to
run SSMS as Administrator.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Max André Bündchen" <nospam@microsoft.com> wrote in message
news:AD5D5880-0D76-4044-A618- A40DA1DF4634@microso
ft.com...
> Thanks guys, it worked very well. Why this one doesn´t work in the wizard
> but just in the query mode?
>
> "Max André Bündchen" <nospam@microsoft.com> wrote in message
> news:FCB171E9-5EDD-4EA5-8467- 4B07A507A298@microso
ft.com...
>
|
|
|
|