MyBB Community Forums
Cannot connect to database. :( - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: Installation and Upgrades Support (https://community.mybb.com/forum-182.html)
+--- Thread: Cannot connect to database. :( (/thread-219318.html)

Pages: 1 2


Cannot connect to database. :( - JesusChrist - 2018-08-18

Hello. I am trying to connect to my SQL 2017 database, but it doesn't seem to connect.
The ID/PW is correct. Not sure what I am doing wrong.
A solution will be much appreciated!

[Image: y9eLczSIQJ6-gwQjrKNBcA.png]



RE: Cannot connect to database. :( - WallBB - 2018-08-18

Few things I feel might be havin issues here :-
Is the password correct(Make sure no spaces are there) ?
Is the user having permissions to modify database ?
This is the most basic issue in case of database connection.


RE: Cannot connect to database. :( - JesusChrist - 2018-08-18

Yeah, correct PW and account is the standard SA server admin with all the permissions.


RE: Cannot connect to database. :( - Wires - 2018-08-18

Instead of localhost try using the IP.


RE: Cannot connect to database. :( - Serpius - 2018-08-18

(2018-08-18, 02:46 AM)JesusChrist Wrote:
Hello. I am trying to connect to my SQL 2017 database, but it doesn't seem to connect.
The ID/PW is correct. Not sure what I am doing wrong.
A solution will be much appreciated!

-- SNIP --

Did you double check the database prefix?

I noticed that it's showing mybb_, but does the forum database have the same prefix?

If not, then you need to change the mybb_ prefix to match whatever it's in the forum database.

If it is the same, then you need to double check the config.php file to make sure it matches whatever prefix you have in the forums database.

Look at the screenshot. (you can disregard about changing the original admin folder name in the screenshot)

[Image: 0a27e30238d5da54bca47a03956a1073.png]


RE: Cannot connect to database. :( - JesusChrist - 2018-08-18

Wire, Serpius, ill try those solutions now.

- btw this is the SQL im using. is this fine?

https://www.microsoft.com/en-us/download/details.aspx?id=55994

This is the forums database - its new and clean

[Image: i124kaIOSE2Q_XtzN-aByw.png]

I've tried mybb_123 as the Table Prefix, still cannot connect.

I'm thinking mybb requires a different SQL?

[Image: FqluE0PHTJ2tI3DZvojdog.png]


RE: Cannot connect to database. :( - Euan T - 2018-08-18

MyBB 1.8 doesn't support Microsoft SQL server. We support MySQL, PostgreSQL and SQLite.


RE: Cannot connect to database. :( - JesusChrist - 2018-08-19

(2018-08-18, 03:50 PM)Euan T Wrote: MyBB 1.8 doesn't support Microsoft SQL server. We support MySQL, PostgreSQL and SQLite.

Thank you! What version of SQL would you prefer most?


RE: Cannot connect to database. :( - Wires - 2018-08-19

See here. The recommended version of MySQL you can run is 8.0.


RE: Cannot connect to database. :( - Serpius - 2018-08-19

(2018-08-19, 01:48 PM)JesusChrist Wrote:
(2018-08-18, 03:50 PM)Euan T Wrote: MyBB 1.8 doesn't support Microsoft SQL server. We support MySQL, PostgreSQL and SQLite.

Thank you! What version of SQL would you prefer most?

[Image: 509da155420aa39788d29aed759df6f3.png]