Author Topic: SOLVED: Having trouble connecting to SQL Server 2017...  (Read 1145 times)

Offline SolidSonicTH

  • Jr. Member
  • **
  • Posts: 10
SOLVED: Having trouble connecting to SQL Server 2017...
« on: December 16, 2018, 12:14:28 PM »
I can't seem to get Roundcube to pass the username and password successfully during setup.

Is there something that needs to be configured on the SQL Server first before attempting this (like needing to open a port or something along those lines)?

I'll provide screenshots if needed.
« Last Edit: January 29, 2019, 10:16:27 PM by SolidSonicTH »

Offline rm13

  • Full Member
  • ***
  • Posts: 129
Re: Having trouble connecting to SQL Server 2017...
« Reply #1 on: December 18, 2018, 06:08:59 PM »
If this SQL server is on a separate box then yes, you may need to open a port. You could check with a sql command line client from where you are installing Roundcube.

Offline SolidSonicTH

  • Jr. Member
  • **
  • Posts: 10
Re: Having trouble connecting to SQL Server 2017...
« Reply #2 on: December 18, 2018, 07:24:03 PM »
No, it’s in the same server as the database, that’s what’s perplexing me.

Offline rm13

  • Full Member
  • ***
  • Posts: 129
Re: Having trouble connecting to SQL Server 2017...
« Reply #3 on: December 21, 2018, 10:02:44 AM »
So are you able to create the initial database?
https://github.com/roundcube/roundcubemail/wiki/Installation#database-configuration

Any other database functional? For Linux something like this
Code: [Select]
sudo lsof -i :mysql to be sure mariadb is listening.

Offline SolidSonicTH

  • Jr. Member
  • **
  • Posts: 10
Re: Having trouble connecting to SQL Server 2017...
« Reply #4 on: December 26, 2018, 10:56:54 AM »
I manually built the database instead of letting Roundcube do it.

Here's the specific errors I'm seeing (the top one is the most pressing but any advice on the other two would be helpful as well).



I might have set up my database user improperly so I'll go elsewhere for advice if that is the case.

Offline JohnDoh

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2,187
Re: Having trouble connecting to SQL Server 2017...
« Reply #5 on: December 27, 2018, 07:49:48 AM »
I see you database server reports "login failed" are you use you typed the creds correctly in the config file?
Roundcube Plugins: Contextmenu, SpamAssassin Prefs, and more…

Offline SolidSonicTH

  • Jr. Member
  • **
  • Posts: 10
Re: Having trouble connecting to SQL Server 2017...
« Reply #6 on: December 27, 2018, 08:16:26 AM »
I gave it the credentials I thought I had set up for that purpose.

I created the account both in Windows and then later in SQL Server itself and neither version seems to take it.

Does it need some kind of domain identifier to make it a valid login from Roundcube?

Offline rm13

  • Full Member
  • ***
  • Posts: 129
Re: Having trouble connecting to SQL Server 2017...
« Reply #7 on: December 27, 2018, 03:47:10 PM »
I'm not very familiar with MS SQL, but I think the Windows login vs SQL login will depend on how you configured your MS SQL. It could be the same or different... You should probably make it a SQL only account that has no rights on the OS for better security.

Make sure the Roundcube login works as expected from the SQL Server Management first.

Offline SolidSonicTH

  • Jr. Member
  • **
  • Posts: 10
Re: SOLVED: Having trouble connecting to SQL Server 2017...
« Reply #8 on: January 29, 2019, 10:19:35 PM »
I just wanted to let everyone know who helped that we are good to go.

The trick was in fact just having an SQL-only name. After that things started falling into place (I also had to delegate it the owner of the Roundcube database).

So it's running. Need to figure out how to secure it (right now it's using HTTP port 80) but otherwise it's good to go.

The only other issue I'm having is missing MIME files.