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



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


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.