SQL login problems....
Note: CloudPanel uses SQL authentication mode only during the install but you can modify the config afterwards if you are familiar with SQL connection strings to use Windows Authentication. If you change to Windows Authentication it will use the account you specified for the application pool. During the install you must have SQL authentication enabled and working properly. Using the “sa” account is not required and you only need to use an account that has the DB creator role. It is actually best practice to disable the “sa” account.
If you are having issues with getting CloudPanel to authenticate with SQL then we suggest you use SQL Management Studio and test connecting to the same server name and instance that you specified in the CloudPanel install and using the same SQL credentials.
I have configured user with "dbcreator" and "SQL Server and Windows authentication mode". I can login with SQL Management Studio with that user and create a database.
I still get SQL error when trying to install CP 🙁
What to do ?
Is CloudPanel on a different server? When you test are you logging into SQL Management Studio that is on the same SQL server? The SQL connection that the installer uses isn't any different than ODBC, so it could be you are testing SQL Management Studio locally but if you had SQL Management Studio installed on another server and tried to connect, it wouldn't work.
It's on same server. I have installed SQL Express + Management tools....
Does CP itself create database or do I have to create it before installation (I have tried both) ?
SQL Server security settings....
When entering same settings like for CP only "Windows NT integrated security" works.
OK, I think I got it..... (Not easy when you're not used to SQL).
Created a user in SQL Management Studio.
Can I change back to original user I want to use ?
When I submit changes....
Access to the path 'C:\Program Files (x86)\Know More IT\CloudPanel\Config\settings.xml' is denied.
When you're not familiar with SQL the documentaion is very sparse....
>When you installed CloudPanel did you enter a name for the application pool (I.E. CloudPanel) or did you select the Default application pool?
I chose "Default Application Pool".....
Should I re-install ?