Solved

Migrating Altiris Deployment server database to another SQL server

Posted on 2010-08-26
4
2,020 Views
Last Modified: 2012-08-13
Hello,
I am trying to Migrate Altiris Deployment server (SQL) database to another SQL server.
Does anyone have experience of doing this as I can't even see an option to change where Altiris gets the data from?
We are using Altiris Deployment Server version 6.9 Sp 4
If anyone has any experience of this please let me know.
Thanks, Ryan.
0
Comment
Question by:MSSC_support
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 

Author Comment

by:MSSC_support
ID: 33529279
The database currently sits on a SQL 2005 database on the same server as Altiris DS.
We have actually already taken a copy of the database & imported it into a new SQL 2008 server - However our problem is with Deployment Server itself - we don't know how to tell the program to point elsewhere to pick up it's database?


0
 
LVL 15

Accepted Solution

by:
MohammedU earned 500 total points
ID: 33537240
In your Altiris programm you should have an option to change the datasource.
If you can't figure it out, try renaming the old server with suffix _old and new server to the same name as old server.
Old Server:
Rename the server and change the ip address some thing else...flush the dns and reboot...
New Server:
Rename the server and change the ip address as same as old one then reboot...you should be back in business..
0
 

Author Closing Comment

by:MSSC_support
ID: 33732421
Good and useful
0
 

Expert Comment

by:dtran67
ID: 34301837
I am having the same issue.  In our case, the current SQL server is different from our deployment server.  We want to move to a new SQL server.  I am not able to find anywhere in Altiris to change the datasource.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSMS Imprt data from Excel 7 37
Need to trim my database size 9 48
SQL DATE Past due to current wek 4 20
SQL query 45 30
Email signature management is something that is often overlooked in many organizations or is simply not implemented effectively. Let's take a look at what methods are available for managing this important piece of corporate branding.
There's a better way to communicate time sensitive or critical info.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question