Re: Domain user in SysAdmin Role (SQL Server on Windows Vista)

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@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?

.

Relevant Pages

  • Re: Domain user in SysAdmin Role (SQL Server on Windows Vista)
    ... Windows Vista for SQL Server 2005: ... In my case the user account to add in sysadmin role is under a domain. ... I try add that but the SQL Server ... JOHN in the machine. ...
    (microsoft.public.sqlserver.security)
  • Re: Nearest Common Ancestor Report (XDb1s $1000 Challenge)
    ... but even MORE generic than the XDb1 implementation, ... disadvantage that 'john', 'John' and 'JOHN' are treated as three distinct ... Since this is the default collation, I assume that your database will use ... I have SQL Server on my desktop; ...
    (comp.object)
  • Re: View Type of Protocol
    ... Thanks a lot for the feedback John. ... information about the type of authentication being used. ... some reason Kerberos is not available. ... they are not authenticated and the SQL Server login fails. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Restricting Access priviledge on SQL2000
    ... You must have made the "Application-Administrators" members of the sysadmin role in SQL Server. ... Take them out of the sysadmin role, add them as users in the correct database, then make them members of the db_owner role in that database. ...
    (microsoft.public.sqlserver.security)
  • Re: update index in background not running.
    ... John, ... event log that SQL Server 2000 FT Indexing success & failures are recorded. ... exec sp_defaultdb N'NT Authority\System', N'master' ...
    (microsoft.public.sqlserver.fulltext)
Quantcast