Operational metadata problem xmeta connection problem

boxtoby · Post by **boxtoby** » Wed Nov 05, 2014 11:10 am

Hi,

I am hoping that someone can help me out here with an xmeta connection problem.

When I run the script ./RunImportStart.sh I get the message:

./RunImportStart.sh
Xmeta Process Meta Data XML Import Version 1.0
11/5/14 4:56:59 PM GMT INFO(500): Starting Xmeta process meta data import.
Invalid username and/or password provided. Please check the values provided.Unexpected end of file from server
11/5/14 4:56:59 PM GMT ERROR(310): Xmeta user "xmeta" connection failed.

The xmeta database resides on an sql server database.

I can connect to the xmeta database with the xmeta user/password using MS SQL Server Management Studio.

I am sure the config file is correct!

The xmeta user has the role of "Operational Metadata Administrator"

DataStage jobs connect to other databases on that server via odbc, so we can see the server.

Any help would be appreciated.

Bob.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 05, 2014 3:34 pm

Might the xmeta owner user/password have been changed since it was set up in the runimport.cfg file?

Try resetting it there in any case (note that running any utility that uses the configuration file will once again encrypt the password).

boxtoby · Post by **boxtoby** » Thu Nov 06, 2014 7:27 am

Hi Ray,

I have been round that loop a few times but it didn't change anything, although it's the most obvious candidate.

Cheers,
Bob.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 06, 2014 3:50 pm

Does it require a specific machine\user identity for SQL Server?