cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 13
Report Inappropriate Content
Message 1 of 8

Side by side databases?

Jump to solution
  • Server01 currently runs ePO 4.5 and has the SQL 2005 Express version running on it, with the EPO4 database.

  • We would like to migrate the database to Server02 with a full copy of SQL 2005 running on it.

  • Unfourtunately, no one seems to know the sa password on Server01 to access the SQL 2005 Express database

Is it possible to add Server02 server to the ePO registered servers and write to both databases, eventually removing Server01 from ePO?

1 Solution

Accepted Solutions
Highlighted
Level 13
Report Inappropriate Content
Message 8 of 8

Re: Side by side databases?

Jump to solution

I got approval for a new server out of nowhere! So we are going to do the Tranfer Systems method.

Thanks everybody!

View solution in original post

7 Replies
Highlighted

Re: Side by side databases?

Jump to solution

Not likely. ePO only allows you to configure one set of database information (including instance name, username, and password).

Are you using SQL-only authentication? Or would a Windows admin on the SQL Express box be able to create a different account with appropiate accress?

--Joel

Highlighted
Level 13
Report Inappropriate Content
Message 3 of 8

Re: Side by side databases?

Jump to solution

SQL only auth

Highlighted
Level 13
Report Inappropriate Content
Message 4 of 8

Re: Side by side databases?

Jump to solution

If we pointed it to a new database on Server02, would the ePO server just write new info to it?

Would the only downside be we would have no previous info?

Re: Side by side databases?

Jump to solution

ePO will only create the database tables, triggers and so on during installation.

I suppose you could install a new ePO server using the new database server. And then add the new server to the old one as a Registered Server. This would allow you to select the systems using the old ePO console and select "Move System" to migrate them over. There are some other, less elegant way to redirect Agents to a new server also.

You could also export, and then import your policies, tags, system tree and so on. But there would be quite a bit of configuration mirroring that would still be done by hand.

Not to mention, that doesn't help you with your old data...

In short, it's not really the end of the road, but it won't be the easiest thing either.

--Joel

Highlighted

Re: Side by side databases?

Jump to solution

Upgrade your SQL express to full installation. Backup and restore and point ePO to new DB and server.

Highlighted

Re: Side by side databases?

Jump to solution

See:

http://msdn.microsoft.com/en-US/library/ms345154(v=SQL.90).aspx

The SA login is a special login in SQL Server, and is a member of the system administrator (sysadmin) role. It is used predominantly in configurations that use the SQL authentication mode, and is not used in Windows authentication mode. SQL requires a strong SA password for security reasons, and during GUI installs and silent SQL authentication mode installs, the user must provide a strong SA password. However, for silent Windows authentication installs, the SA password is not a requirement. The reason is that when using Windows authentication mode, the silent SQL Server Express setup provides a random strong SA password if the password is not specified by the user. The setup also disables the SA account in this case, so that you must explicitly enable SA at a later stage using T-SQL if you wish to use it. This is done so that the ISVs do not have to provide the password when using Windows authentication, so that the mass deployment scenarios are not blocked. In future releases, this functionality may be extended to GUI Windows-based installs also.

You can easily change this by installing SSMS-EE (Sql Server Management Studio Express Edition) or through T-sql statement as stated. SSMS-EE is a free download from Microsoft and is quite handy in it's own right.

Rgds,

Rob.

Highlighted
Level 13
Report Inappropriate Content
Message 8 of 8

Re: Side by side databases?

Jump to solution

I got approval for a new server out of nowhere! So we are going to do the Tranfer Systems method.

Thanks everybody!

View solution in original post

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community