Smart Connector installation problem

[ttelesz]

I installed SQL Express 2019 and SmartConnector 2.4.38.
But the Smart Connector service is not working.
"The Smart Connector service on Local Computer started and then stopped. Some service stop automatically if they are not in use by other services or programs"
Microsoft SQL Server management studio shows that I only have the SecurityExpert database.

Why is there no new SmartSonnector database instance?

I'm attaching the log file.

Tomasz

[Erwin-vd-Zwart · Accepted solution]

Looks like there is no connection to the SQL DB possible, could it be that you made a mistake when running the setup? Did you select the correct DB type and credentials for this DB instance? What settings did you use? SQL Express with Windows Implicit or SA or? 

I would try with the credentials you also use for SSMS

[ttelesz]

I select SQL Express DB type and Widows Implicit credentials.
My Windows user has dbcreator permissions. I added them using SQL Server management studio and SecurityExpert DB.

[Erwin-vd-Zwart]

Are you running the SQL Express on the same server as SC framework or on a remote server?

[ttelesz]

It's the same server.

[SteveGregory]

Did you try running the installer by right clicking and 'run as administrator'?

[ttelesz]

Yes, i'm running the installer by 'run as administrator'.

[SteveGregory]

It certainly sounds like a SQL access issue. Can you use SQL authentication instead of windows implicit?

[ttelesz]

I agree. It seems to me to be an SQL problem.
Now I'm using SQL authentication instead of windows implicit but it still doesn't work.
I'm attaching the log file.

[IbrahimOmara]

HI 

i face same problem any one solve this problem before

[ttelesz]

I made a system backup before installing SQL.

I restored that backup and then reinstalled everything.

This solved my problem.

[IbrahimOmara]

what is the system that you did the backup for??

[Andi_789]

Hi,
I Have the same problem. I have installed the MS SQL Express 2022 and try to get the Smart Connector working. But it seems that the SQL servers denies the log in.... I have tried differenet sing in options, but it doesn´t work. Have anyone ideas?

[MaximeLaudren]

Hi,

If you can provide the log file it would help to validate that the issue is located between SC and SQL.

Check in: C:\ProgramData\SmartConnector\Logs and provide last log file.

If the SQL server is running on the same machine, and you have selected windows implicit, check that the user running the SC have access to the smartconnector database.

If running on another server, same checks to be performed, but validate that the domain is matching between the 2 machines.

Max

[Andi_789]

Hi,
thanks, now the connection between SQL Server and SmartConnector is running and the DB is created. But now I have the next problem, the WebSite from the SmartConnector is not reachable. I hope this is not a problem of our SE machines....

[MaximeLaudren]

Hi,

Could be possible.

in the application tray, find the Trellix then quick settings / Enable Firewall Timed Group.

That should unlock access to local app, if it was firewall issue.

Otherwise, provide the logs, and it may show something else.

Max

[Andi_789]

Hi Max,

the Firewall seems not to be the problem. I´m still not able to open the Webpage from the SmartConnector. See the log file.

Many thanks in advance!

[Andi_789]

Hi,
now it´s running. It was a acces right setting necessary in the SQL Server for the Local System Account. Thank´s Erwin!!

[MaximeLaudren]

Great 🙂

Can you please not the corresponding message as Solution.

Thanks!

[Andi_789]

  

[MaximeLaudren]

thanks for the update.

I set Erwin post as solution as he pointed in the direction to look at.
If there is something else. let us know.