MS SQL Server connection failure

[tzachk]

Hi Francesco,

I'm trying to connect to MS SQL DB and always get CONNECT_ERROR.
I've double checked the credentials and of course can manually connect to the DB.

Is there a plcae I can get the real connection error instead of the CONNECT_ERROR? as this will shed light on what is the problem.

Regards,
T.

[FrancescoT]

Dear Tzachk,

In addition to the error values returned by "MS SQL SERVER" command, when Abort Execution on Script Error is checked, and an error occurs during script execution (where database and server connections succeeded), this variable holds detailed error information as follows: The variable is split into two parts, delineated by the string literal DELINEATOR. The first part of the variable holds the exact textual error message. The second part of the variable holds the exact SQL script fragment where execution errors occured. You may parse the variable using the Parse String function to extract both fields and utilize them separately.

Hope this helps you.

Regards

[tzachk]

Hi Francesco,

When you say "this variable", which variable you refer to?

Regards,
T.

[FrancescoT]

Dear Tzack,

I mean the one you used with "Return result in variable" command field.

Regards

[tzachk]

Hi Francesco,

This variable just returns CONNECT_ERROR, not the actual issue of why it can't connect.
I'm logging the SQL server connections and I can't see any record that the installer is trying to connect to the server.

ideas?

Regards,
T.

[tzachk]

Hi Francesco,

I found the problem.
I'm trying to connect to the SQL server to see if a specific Database exists.
It seems that the MS SQL Server command returns CONNECT_ERROR even if it can connect to the server, but the database do not exist. According to the documentation is should return CONNECT_DATABASE_ERROR, and it is important that it shall return this error as I check it during the install.

Any idea on this?

Regards,
T.

[FrancescoT]

Dear Tzack,

if you can post a sample project that demostrate the issue I will try to verify it.

Regards

[tzachk]

Hi Francesco,

The sample project attached
Fix the credentials in the MS SQL server to match your DB server.
If you add a value for Database that does not exists field and try to connect you'll get CONNECT_ERROR, when you need to get CONNECT_DATABASE_ERROR. If you remove the Database value, you'll get SUCCESS (if the login credentials are correct that is).

Regards,
T.

[FrancescoT]

I will test it ASAP.

Regards

[tzachk]

i Francesco,

This issue is becoming urgent.
Can you please update me on the status.

Regards,
T.

[lbertoldi]

Same here, I get this error for no obvious reasons on different target machines.
Thanks

[FrancescoT]

Dear Users,

actually I can only confirm this behaviour.
I'm fowarding my test results to our dev team.

I will post further informations as soon as I receive an answer.

Regards

[tzachk]

Hi Francesco,

Any news?
Two weeks have passed since I published this issue.
Do I need (AGAIN!), to code a workaround for this issue?

Regards,
T.

[FrancescoT]

Dear Tzack,

The issue has been logged to our fixes list but actually, I can tell you when a fix will be available.

As possible workaround you could check via MS-SQL script if the passed database exist.

Regards