Question

Workflow server configuration with remote SQL Server

Workflow Version 10

Updated August 8, 2016

asked on July 26, 2016

Hello,

I have to configure a Laserfiche workflow server with remote SQL Server. At the end, I get an error because the workflow server can't "Testing database connection on SLAFI01:8085" but SLAFI01 is the workflow server's name not the SQL Server's name but I can't figure out how to solve this issue.

You'll find in attachments a screen shot for each steps of the configuration and the configuration's log.

installWF1.png (870.35 KB)

| Download

installWF2.png (537.11 KB)

| Download

installWF3.png (714.68 KB)

| Download

installWF4.png (484.92 KB)

| Download

installWF5.png (582.37 KB)

| Download

log WF - 2016-07-25_09-30-53.txt (13.11 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on July 26, 2016

Is SSQL04\AvtSQLs is a domain user? It looks to be a local Windows account on the remote server. Machine accounts can't connect remotely. You need to use either a domain account or a SQL Server account.

0 0

Replies

replied on July 29, 2016

Hello Miruna,

SSQL04\AvtSQLs is a domain user. Like I said in my previous post at the end of the log file there is an error message : "Testing database connection on SLAFI01:8085" but SLAFI01 is the workflow server's name not the SQL Server's name and I didn't use SLAFI01 at any step so I don't know from where it comes but I think this is what makes the error happen.

Any idea on how to change that ?

0 0

replied on July 29, 2016

So SSQL04 is the name of the domain, not the name of the SQL Server machine?

0 0

replied on August 8, 2016

No, you were right. The customer told me that it was a domain user but it wasn't. Since he tried with a real domain user the installation went fine.

Thank you Miruna,

Best Regards.

0 0

You are not allowed to follow up in this post.

Question

Question

Workflow server configuration with remote SQL Server

Answer

Replies

Sign in to reply to this post.