Re: Migrating the WSUS database from a Windows Internal Database instance to a SQL Server 2005 instance on a remote server
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Mon, 23 Jul 2007 19:07:55 -0600
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
.
- Follow-Ups:
- References:
- Prev by Date: Migrating the WSUS database from a Windows Internal Database instance to a SQL Server 2005 instance on a remote server
- Next by Date: Re: Remote Scripting and Firewall Ports
- Previous by thread: Migrating the WSUS database from a Windows Internal Database instance to a SQL Server 2005 instance on a remote server
- Next by thread: Re: Migrating the WSUS database from a Windows Internal Database instance to a SQL Server 2005 instance on a remote server
- Index(es):
Relevant Pages
|
