Solved

Derby to MS SQL server Database migration for IBM director

Posted on 2011-09-10
3
428 Views
Last Modified: 2012-05-12
Hi gurus

I have a couple of quick questions. I am trying to migrate an internal derby database to an external MSSQL 2005 database for ISD 6.2. It is for a customer and the customer has already created the database for the migration. I have the database owner permissions for the particular database instance and made me the owner of the database. But when I run the "cfgdbcmd.cmd -rspfile responsefile" it is asking me for the db admin password and my owner password does not work. I was just wondering if I need to be a database admin to be able to do this. Also another question, if there are more than one director server for the environment (for example one for each geographical domain) then does each IBM director server need one dedicated db instance or can all of them use one?

Thanks in advance.
0
Comment
Question by:sinfuldips
  • 2
3 Comments
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 36519194
Since you have not received any help yet, see if this aids you. Per IBM Director 6.2.x documentation if you want to use Windows authentication you need to have the IBM director service run as the Windows administrator account that has rights in SQL Server.

http://publib.boulder.ibm.com/infocenter/director/v6r2x/index.jsp?topic=%2Fcom.ibm.director.install.helps.doc%2Ffqm0_t_preparing_remote_sql_server.html

This one talks about using integrated security also:
http://publib.boulder.ibm.com/infocenter/director/v6r2x/index.jsp?topic=%2Fcom.ibm.director.cli.helps.doc%2Ffqm0_r_cli_cfgdbcmd.html

Hope that helps,
Kevin
0
 

Author Closing Comment

by:sinfuldips
ID: 36679261
thanks a lot, I did figure out a way around this.
Thanks again, much appreciated.
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 36707482
@sinfuldips: was the way around this in my comment? If not, please post your workaround. It is probably best that is accepted as the answer also. I appreciate the points, but would rather see the PAQ contain a working solution if my post is not one. If it helped you in some way, but all means please include it in assist points. Anyway, if you would not mind, please post that as I am curious and it would be very helpful to future readers. You can then ask a Moderator to re-open this so you can accept the correct post.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

786 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