Re: Move SMS 2003 to another server

Steve Thompson wrote:
"Lisa@" <Lisa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message

Server Compnents.

How can this be?

Hi Lisa,

SMS requires an SQL Server database, it really does not have to be local to the SMS install, I made that recommendation because of ease of SMS installation, troubleshooting and support. Microsoft recommends installing both SMS and SQL Server on a single device, except for the largest sites...

Steve


Hi all,

I am doing the same thing, migrating SMS2003 from old server to new one, but I also have to migrate SQL 2000 to SQL 2005.
I have some reports, queries, collections and packages defined, so can I do actual migration or not?? Can I use Admin FP for something?

My idea is to migrate database from old to new server, and then install new SMS 2003 on new server. Will I have the same collections, reports and stuff on new SMS this way or not??

Thanks in advance
.

Relevant Pages

  • Re: Failed to get a SQL Server connection
    ... SMS is installed on a Windows Server 2003 SP1, ... We already did SMS ... Possible cause: SQL Server problem. ... Verify that SMS can access the SMS site database. ...
    (microsoft.public.sms.setup)
  • Re: MP Control Manager detected MP is not responding to HTTP requests
    ... IIS lockdown isn't needed for Windows server 2003. ... Did you get an error status message in the SMS admin console for MP control ... The SQL server site system is turned off, ...
    (microsoft.public.sms.setup)
  • Does anyone know how to fix this??
    ... Basically sms secondary site reports me 3 kind of error.... ... This site's SMS Service account or the site server's machine ... http error is Internal Server Error. ... MP encountered an error when connecting to SQL Server. ...
    (microsoft.public.sms.setup)
  • Re: Move SMS Database to new SQL Server
    ... Because you aren't just backing up the database, you're doing a full SMS ... later and move database from a remote server back to the SMS site server.) ... >>> I have SMS running right now on its own SQL server. ...
    (microsoft.public.sms.setup)
  • Problems installing Security Scan and Office Scan
    ... I have been to the MS Managing SMS 2003 class. ... I have installed SMS 2003 on a Win2003 server and placed the database on one ... installed the SMS Provider on the SQL server. ... I initially had some problem getting the reports to install. ...
    (microsoft.public.sms.tools)
Loading