Support Forums

SQL login problems….
 
Notifications
Clear all

SQL login problems….

20 Posts
2 Users
0 Likes
54.5 K Views
0
Topic starter

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 ?

 

10 Answers
0

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.

 

0
Topic starter

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) ?

Jacob Dixon 2017-11-27 08:09

Check sql server configuration utility and make sure TCP/IP is enabled. It sounds to me that sql isn’t accepting remote connections. What you can do to verify is download one of the many SQL connection tester tools out there and test connecting with that. If the installer can’t connect then those other tools wouldn’t be able to either.

0
Topic starter

SQL Server security settings….

0
Topic starter

I followed this:  https://blogs.msdn.microsoft.com/steverac/2010/12/13/test-remote-sql-connectivity-easily/

When entering same settings like for CP only “Windows NT integrated security” works.

Jacob Dixon 2017-11-27 08:21

No, the installer only accepts sql authentication methods and not Windows. Please send screenshots of what you are entering 

Jacob Dixon 2017-11-27 08:58

Wait, so it sounds like when you tested that way you can’t get SQL authentication to work, right? If you want me to do a quick remote session with you in about an hour, then I can. Just let me know.

0
Topic starter

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 ?

0
Topic starter

http://localhost/CloudPanel/admin/settings

When I submit changes….

Error!
Access to the path ‘C:\Program Files (x86)\Know More IT\CloudPanel\Config\settings.xml’ is denied.

jjonsson Topic starter 2017-11-27 10:05

What user am I logged in as ?

Am I correct that it’s related to the SQL user ?

What to do ?

Jacob Dixon 2017-11-27 10:06

When you installed CloudPanel did you enter a name for the application pool (I.E. CloudPanel) or did you select the Default application pool?

0
Topic starter

When you’re not familiar with SQL the documentaion is very sparse….

 

0
Topic starter

>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”…..

Jacob Dixon 2017-11-27 10:17

Please go in IIS, select application pools, create a new application pool called whatever you would like, then set the ApplicationIdentity to a domain user with rights to Exchange. Set that virtual directory to use that new application pool.

Or you can simply uninstall, reinstall with a new database but enter a name so the installer will create a new application pool automatically for you.

0
Topic starter

Should I re-install ?

 

Jacob Dixon 2017-11-27 10:19

Yeah I would and enter a name for the application pool so it will create a new application pool. I would enter a new name for the database so it will create a new database for you.

0
Topic starter

> then set the ApplicationIdentity to a domain user with rights to Exchange.

How ???

It’s easy to add new Application Pool. But how do I change user ?

Jacob Dixon 2017-11-27 10:22

I would just reinstall CloudPanel if you can and enter a new database name so it will create a new database for you and enter something like CloudPanel for the application pool during the install.

jjonsson Topic starter 2017-11-27 10:25

Ok, I try re-install….

But what about SQL user ?
I feel it’s not correct. When installing SQL Express it’s recommended not to use “SQL server and Windows Authentication Mode”.
Can I change back afterwards and how ?

Jacob Dixon 2017-11-27 10:44

The installer requires SQL authentication, so you have to enable that. Many people use SQL authentication but the problem with SQL authentication is the password is stored in plain text in the configuration file. If someone could access your plain text file on the server, then they could access the database. But honestly if someone can access your server then you have bigger problems.

Share: