Error loading metadata into ProfileStage from SQLServer 2000

[gomez]

Hi All:
I 'm trying to import metadata of SQL Server tables onto ProfileStage
I get the following error

Code: Select all

------------------ 2/6 15:43:50 -- ELAPSED: 0.078 sec cpu ------------------
Opening data source w/Data Source Name (DSN) 'XXXX'
for database ''
as user 'YY' in DB server ''.
Using 'ODBC' to connect to a  data source.

------------------ 2/6 15:43:50 -- ELAPSED: 0.078 sec cpu ------------------
AppLib::GetSrcDbConnection: AppLib::GetSrcDbConnection: Failed to open DB connection due to:
CoreOdbc::_ExecOpenDbSql_ODBC: Error in opening database connection to 'XXXX'.
Connection string is 'dbi:ODBC:XXXX'.
User name is 'YY'.

------- DBI Result Information -------
	SQL  State  :  '28000'
	Error Number:  '-1'
	-- Error  text --
	[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'domain\YY$'. (SQL-28000)(DBD: db_login/SQLConnect err=-1)


------------------ 2/6 15:43:50 -- ELAPSED: 0.078 sec cpu ------------------
User Error:
Unable to connect to database using DSN/service 'XXXX'.  Review connection information and correct if needed. Connection error: CoreOdbc::_ExecOpenDbSql_ODBC: Error in opening database connection to 'XXXX'.
Connection string is 'dbi:ODBC:XXXX'.
User name is 'YY'.

------- DBI Result Information -------
	SQL  State  :  '28000'
	Error Number:  '-1'
	-- Error  text --
	[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Domain\YY$'. (SQL-28000)(DBD: db_login/SQLConnect err=-1)


------------------ 2/6 15:43:50 -- ELAPSED: 0.078 sec cpu ------------------
Warnings encountered: 0
User error encountered.

I have Analysis Server,Client and MessageSwitch installed on my desktop and SQL Server instance is on a remote machine.
Used Ascential SQL Wire Protocol to create the DSN
I tested the DSN connection by connecting to the same database successfully from DataStage Designer.

PSDB repository is on my local machine, I'm able to successfully connect to this.

I'm not sure what I'm missing in importing metadata from remote server
Appreciate any help on this!
Thanks

[ray.wurlod]

The message is "login failed". This means that connection was made to SQL Server, but your authentication information (user ID and password) were not valid. I don't see any mention of a password in the connection string.