Re: Migrating the WSUS database from a Windows Internal Database instance to a SQL Server 2005 instance on a remote server

Oops my bad indeed no brackets. now i do and i get this message. both
sql as the comuter i want added are in the same domain and i can ping
the computer from the sql computer.

Msg 15401, Level 16, State 1, Line 1
Windows NT user or group 'domain\server' not found. Check the name
again.

On Wed, 25 Jul 2007 22:35:49 +0000 (UTC), Erland Sommarskog
<esquel@xxxxxxxxxxxxx> wrote:

MartinH (nick@xxxxxxxxxxxxxx) writes:
thx for your response. i tried adding the login with SQL.
it returns an error.

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '\'.

Could you please include the exact command that gave you the error?

If I am to guess, my guess is that failed to include the brackets,
and typed

CREATE LOGIN domain\server FROM WINDOWS

rather than

CREATE LOGIN [domain\server] FROM WINDOWS


.

Relevant Pages

  • Re: Renamed Windows login not found in SQL Server 2000
    ... It's almost like SQL tuck some knowledge away in an area ... of memory that only gets released on Windows stop. ... > I am running SQL Server 2000 SP2 with Windows ... > login gets corrupted) I am unable to add the new login to ...
    (microsoft.public.sqlserver.security)
  • Re: Keeping User From Deleting Table Records
    ... authentication and authenticate with Windows. ... Is this Windows "read" permission ... Windows or is this SQL-assigned read permission done through SQL ... SQL login, and grant only read permissions to that user. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Authentication with multiple roles is only for small apps?
    ... The above statement is true but isn't limited only to Windows logins: ... authentication) and using an application Windows account for SQL Server ... on the middle tier if it uses the same login for all connections. ...
    (microsoft.public.sqlserver.security)
  • WebAdmin tool keeps loosing connection
    ... We installed SQL Webadmin ... databases using Enterprise manager and everything was working fine. ... setup two security logins for each database: Windows Authenticated ... for login via web broswer and another SQL Authenticated. ...
    (microsoft.public.sqlserver.connect)
  • Re: Application password
    ... That is correct -- and with SQL logins, there is no way to enforce ... lock down Windows). ... There biggest effort so far is replacing the sa login ... >hold of that single password there entirely security scheme is broken. ...
    (microsoft.public.sqlserver.security)