Changing the ACS Server

[MrEd]

OpsMgr 2007 R2

I need to change the server that is the ACS server because of the age of the
server.
I installed the ACS server on a server that was a management server. When I
started pointing the servers that we want to collect data no to the new
collection server I started getting this in the error log on the collection
server, and no data was being collected.
Event Type: Error
Event Source: AdtServer
Event Category: None
Event ID: 4618
Date: 7/23/2009
Time: 2:13:04 PM
User: N/A
Computer: PMGR2
Description:
Error occured on database connection:
Status: 0x0409C002
ODBC Error: 208
ODBC State: 42S02
Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'dtString_d5974275_c01a_4fee_ab7b_aab567e29a6c'.
Database: SqlWriter
Connection: dtString
Statement: spInsertString

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

--
Ed

[GD]

Hi

Have you done all the following steps:
http://technet.microsoft.com/en-us/library/cc540397.aspx

Cheers

Graham

"MrEd" <Mr...@discussions.microsoft.com> wrote in message
news:92A71178-DE90-4E0E...@microsoft.com...

[MrEd]

Again, I am not moving the database. I am changing the server that acts as
the ACS collector. And yes I did try all the steps in the Technet document.
--
Ed