Very strange SQLServer Connect Failed: 28000

  • Posts: 40
  • Thank you received: 3

Very strange SQLServer Connect Failed: 28000 was created by Vassalli

Hi guy,
I'm experiencing a very strange SQLServer Connect Failed.
It's really strange because it happens in a loop.
The first time the loop is executed, there is nothing wrong and the SQL statement is processed, the second time it doesn't work.
You may see it in the picture below.


The error log states:
Failed To Connect SQLDriverConnect Failed: 28000 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.

You may check the log of the first step.
Moreover if the loop stops after a single step, the process is executed correctly.
Can you help me?
Pietro
5 months 2 days ago #21679
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 8507
  • Karma: 33
  • Thank you received: 570

Replied by admin on topic Very strange SQLServer Connect Failed: 28000

You might have a situation when the database password has the variable name inside

password = longcat1 and cat1 is variable name

So the first time it works fine but the second time cat1 is replaced with variable value therefore connection fails
Mike
ETL Architect
5 months 2 days ago #21680

Please Log in or Create an account to join the conversation.

  • Posts: 40
  • Thank you received: 3

Replied by Vassalli on topic Very strange SQLServer Connect Failed: 28000

Hi Mike,
thank you for your quick response. I've been looking around and I've found out viewing variables that there is a Variable 1 whose value is 2.
At the very first loop step there is a Variable called modupdate that has a value of 1 and it's the only one having this particular value.
The next step appears this one.
It's not declared anywhere: can you give me some hints?
Thank you very much once again,
Pietro
5 months 1 day ago #21683

Please Log in or Create an account to join the conversation.

  • Posts: 8507
  • Karma: 33
  • Thank you received: 570

Replied by admin on topic Very strange SQLServer Connect Failed: 28000

Maybe it is a global variable
www.etl-tools.com/wiki/aetle/options?s[]=global

Please post some screenshots it is very difficult to provide support by guessing
Mike
ETL Architect
5 months 1 day ago #21684

Please Log in or Create an account to join the conversation.

  • Posts: 40
  • Thank you received: 3

Replied by Vassalli on topic Very strange SQLServer Connect Failed: 28000

Thank you Mike,
here there are the screenshot of the package that I've created and of the objects inserted there.
Thank you! :)
5 months 1 day ago #21685

Please Log in or Create an account to join the conversation.

  • Posts: 8507
  • Karma: 33
  • Thank you received: 570

Replied by admin on topic Very strange SQLServer Connect Failed: 28000

Very important thing to understand that
variables are replaced with actual values before execution

Variable value maupudatecreata is 1
SQL is;
select 'maupudatecreata', email from table
Again: variables are replaced with actual values before execution
The actual SQL executed
select '1', email from table
now you have variable '1' and it has some value
SQL server password is abc1dff
1 is replaced with a value
your connection fails

Please reset variables before the loop
Mike
ETL Architect
The following user(s) said Thank You: Vassalli
5 months 1 day ago #21686
Attachments:

Please Log in or Create an account to join the conversation.

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies