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

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

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:
- Re: Migrating the WSUS database from a Windows Internal Database instance to a SQL Server 2005 instance on a remote server
  - From: Sue Hoegemeier

Prev by Date: What type of certificate?
Next by Date: Re: Migrating the WSUS database from a Windows Internal Database instance to a SQL Server 2005 instance on a remote server
Previous by thread: What type of certificate?
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):
- Date
- Thread

Relevant Pages

Re: List availalbe SQL Servers?
... and definitely with 2008 in future) to be able to create and connect to a new database using a selectable database instance. ... This document specifies the SQL Server Resolution Protocol, ...
(borland.public.delphi.database.ado)
RE: VS2005 DB Tools cant set Identity prop for Primary Key columns?
... I tried your steps with a SQL server 2005 database instance, ... such a table and save it, I can expand the Identity Specification and set ...
(microsoft.public.vsnet.ide)
Re: multiple instances behind a firewall
... the other database instance, but how would I create a SQL Server registration ... "Wayne Snyder" wrote: ... > Wayne Snyder, MCDBA, SQL Server MVP ... My firewall software designates an instance on one ...
(microsoft.public.sqlserver.server)
SQL Server 2005 Installation Procedures wSQL Server 2000
... I have a SQL Server 2000 database instance that was set up with the Standard ... install a new SQL Server 2005 no-default instance on the server. ...
(microsoft.public.sqlserver.server)
Re: Reinstall of SMS 2003 has no Status Messages
... The site server machine account cannot authenticate with the SQL server. ...
(microsoft.public.sms.setup)