Moved Data Store now can't start IMA

[fs483]

Hello,

I tried moving my data store of PS4 Advanced from Access to SQL2000 and failed miserably. I manually created a DB on my SQL server. Created a user as db_owner on the database. I then created a file dsn (which connects fien to my DB). Ran dsmaint /migrate ...., ran dsmaint /config, tried restarting IMA service but it won't start and shoots an error message from event viewer

Event Type: Error
Event Source: IMAService
Event Category: None
Event ID: 3609
Date: 17/01/2007
Time: 11:11:43 PM
User: N/A
Computer: CITRIX1
Description:
Failed to load plugin ImaPsSs.dll with error IMA_RESULT_ENTRY_NOT_FOUND

Event Type: Error
Event Source: IMAService
Event Category: None
Event ID: 3609
Date: 17/01/2007
Time: 11:11:43 PM
User: N/A
Computer: CITRIX1
Description:
Failed to load plugin ImaRuntimeSS.dll with error IMA_RESULT_ENTRY_NOT_FOUND

Event Type: Error
Event Source: IMAService
Event Category: None
Event ID: 3601
Date: 17/01/2007
Time: 11:11:43 PM
User: N/A
Computer: CITRIX1
Description:
Failed to load initial plugins with error IMA_RESULT_ENTRY_NOT_FOUND

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 17/01/2007
Time: 11:11:44 PM
User: N/A
Computer: CITRIX1
Description:
The Independent Management Architecture service terminated with service-specific error 2147483655 (0x80000007).

For more information, see Help and Support Center at

http://go.microsoft.com/fwlink/events.asp.

Here's my mf20.dsn
[ODBC]
DRIVER=SQL Server
UID=citrix
DATABASE=Citrix DataStore
WSID=citrix1
APP=Microsoft Data Access Components
SERVER=SQLSRV1\GREATPLAINS
Description=CitrixFarmname

Any ideas ? From what I read, it's supposed to be straight forward. It's far from it in my case.

 

[ascotta]

The 2147483655 error suggets a login error.

However there is a white paper on Citrix web site as to how to move a data store from Access to SQL, I have only done it the once, but it worked a charm. That was about 4 years ago though. Make sure your read it thouroughly and identify your scenario first before you step right in.

[blue] A perspective from the other side!![/blue]

Cheers
Scott

 

[fs483]

Found the problem. DSMAINT doesn't mind a DB with a space inside but IMA service doesn't like it. My DB was called Citrix DataStore. Flushed the DB and recreated a new DB CitrixDataStore. Worked a like a charm.