Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Migrating Altiris Deployment server database to another SQL server

Posted on 2010-08-26
4
Medium Priority
?
2,081 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
  • 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 1500 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

Evaluating UTMs? Here's what you need to know!

Evaluating a UTM appliance and vendor can prove to be an overwhelming exercise.  How can you make sure that you're getting the security that your organization needs without breaking the bank? Check out our UTM Buyer's Guide for more information on what you should be looking for!

Question has a verified solution.

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

Article by: Shawn
IT teams define success as solving problems quickly. To enable ITSM modernization we have to think of adopting the tools and methods that will enable resolution of ITSM issues more quickly.
I’m willing to make a bet that your organization stores sensitive data in your Windows File Servers; files and folders that you really don’t want making it into the wrong hands.
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

569 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