Error loading metadata into ProfileStage from SQLServer 2000
Posted: Tue Feb 06, 2007 6:16 pm
Hi All:
I 'm trying to import metadata of SQL Server tables onto ProfileStage
I get the following error
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
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.
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