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

hi sue,

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 '\'.


On Mon, 23 Jul 2007 19:07:55 -0600, Sue Hoegemeier
<Sue_H@xxxxxxxxxxxxx> wrote:

If you need to add a machine account, try adding the login
with SQL instead of the GUI:
CREATE LOGIN [YourDomain\ServerName$]
FROM WINDOWS
Keep in mind though that anything running under Network
Service on that other box has been granted a login so you
open up a security hole when doing this.

-Sue

On Mon, 23 Jul 2007 23:10:17 +0200, MartinH
<nick@xxxxxxxxxxxxxx> wrote:


Hey,

I am planning to migrate the WSUS database from a Windows Internal
Database instance to a SQL Server 2005 instance on a remote server.

http://technet2.microsoft.com/windowsserver/en/library/b4852133-5ed3-48d7-8a95-e7866e638c181033.mspx?mfr=true

The FE machine account should be listed as a login on the sql server
running on the BE machine. If it is not, it should be added. How do i
add a machine account to SQL server?

I suppose i would have to add DOMAIN\SERVERNAME to the securtity
logins but it wont let me.

Help is appreciated.

TIA Martin


.

Relevant Pages

  • Re: dsn-less connection
    ... It worked pretty much as I was hoping in prompting the user for a SQL ... Server login and was able to remove the specific dsn that's in the odbc ... straight to the SQL Server login prompt? ... with the login prompt but the Use Trusted Connection is checked on. ...
    (microsoft.public.access.security)
  • Re: Migrating the WSUS database from a Windows Internal Database instance to a SQL Server 2005 insta
    ... If you need to add a machine account, try adding the login ... Database instance to a SQL Server 2005 instance on a remote server. ... The FE machine account should be listed as a login on the sql server ...
    (microsoft.public.sqlserver.security)
  • Re: Permission question - another one
    ... If I add an Sql Login it does add the TRAVAC\ in front of the names, ... seems to be users that were setup to use SQL Server Authentication. ... RAPTOR is the Server that has SQL Server running on it. ... > " I could think I am taking permissions away from someone, ...
    (microsoft.public.sqlserver.programming)
  • 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: SQL Server on XP Home Network
    ... The sa account is the system administrator "God" account witihin SQL ... This account is a SQL-Server login. ... You might be able to use Enterprise Manager to go in and create a new SQL ... Select the "SQL Server Authentication" ...
    (microsoft.public.sqlserver.setup)