Configure SQL Serve...
 
Notifications
Clear all

Configure SQL Server 2017 Express as service

3 Posts
2 Users
0 Reactions
2,443 Views
Posts: 3
Topic starter
(@ssanfilippo)
New Member
Joined: 7 years ago

Hi at all,

I'm new in SolidCP and following the installation manual I had installed the standalone application.

My server is Windows Server 2016 Standard, SQL Server 2017 Express and MySql 8 Community as database, IIS 10. All work, portal manage all function, but when I must add the service for my database in System space, as serveradmin, I get error:

  • for MySQL cannot generate a secure key ... How I must generate it?
  • for SQL 2017 Express don't find the server, I had also enabled and started SQL Browser and SQL Agent, but nothing, same errors. I must configure a connection string?

Thanks,

Simone

2 Replies
Posts: 1967
Admin
(@m-tiggelaar)
Noble Member
Joined: 9 years ago

Hello,

From your description: If you go to Servers --> servername --> settings

Do you see any connection error or similar at the top?

For mysql always make sure you have the mysql asp.net connector installed (without it asp.net it self can't talk to mysql).

for SQL Express: I always configure it with user/password configured (it has to be a Sysadmin user/password with SQL login, not a windows login).

Regards,

Marco

Reply
Posts: 3
Topic starter
(@ssanfilippo)
New Member
Joined: 7 years ago

Hi, I resolve the problem, my SQL and MySql port was blocked from firewall, after unblock it, all ok.

Best regards,

Simone

Reply
Share: