Problem installing ...
 
Notifications
Clear all

Problem installing solidcp (sql server error)

2 Posts
2 Users
0 Likes
3,278 Views
Posts: 4
Topic starter
(@barma)
New Member
Joined: 7 years ago

Hello, im trying to install solidcp following your 5minutes video (excellent) in Windows Server 2016 standard the problem i have is on SolidCP Installer (setup wizard) in Database Settings.

With SQL Server 2016 Express:

Sql Server: localhostsqlexpress

Authentication: Windows Authentication

I got "Please Switch SQL Server authentication to mixed SQL Server and Windows Authentication mode."

With SQL Server 2016:

Sql Server: localhost

Authentication: Windows Authentication

I got the same error....

There is no mixed option in authentication, i installed sql server 2016 in basic mode, sql server is running

How can i fix this?

1 Reply
Posts: 1456
Admin
(@trobinson)
Noble Member
Joined: 8 years ago

Hello,

 

If you have SQL Server Management Studio installed you will need to go to the properties of the server -> Security -> Server Authentication: SQL Server and Windows.

 

If you do not have the management studio you can either install it or recreate the SQL Server instance and select the SQL Server and Windows authentication.

 

Kind Regards,

 

Trevor Robinson

Reply
Share: