Jump to the post that solved this thread.
Solved: 6 Years, 5 Months, 1 Week ago Cannot connect to database. :(
#1
Solved: 6 Years, 5 Months, 1 Week ago
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]
Reply
#2
Solved: 6 Years, 5 Months, 1 Week ago
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.
- MyBB Heart
Reply
#3
Solved: 6 Years, 5 Months, 1 Week ago
Yeah, correct PW and account is the standard SA server admin with all the permissions.
Reply
#4
Solved: 6 Years, 5 Months, 1 Week ago
Instead of localhost try using the IP.
Plugin Count: I lost count.
Public Plugins are available here.
Please do not PM me for support unless asked to.
Reply
#5
Solved: 6 Years, 5 Months, 1 Week ago
(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]
I'm Serpius and You're Not    ¯\_(ツ)_/¯
Reply
#6
Solved: 6 Years, 5 Months, 1 Week ago
Wire, Serpius, ill try those solutions now.

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

https://www.microsoft.com/en-us/download...x?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]
Reply
#7
Solved: 6 Years, 5 Months, 1 Week ago
MyBB 1.8 doesn't support Microsoft SQL server. We support MySQL, PostgreSQL and SQLite.
Reply
#8
Solved: 6 Years, 5 Months, 1 Week ago
(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?
Reply
#9
Solved: 6 Years, 5 Months, 1 Week ago
See here. The recommended version of MySQL you can run is 8.0.
Plugin Count: I lost count.
Public Plugins are available here.
Please do not PM me for support unless asked to.
Reply
#10
Solved: 6 Years, 5 Months, 1 Week ago
(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]
I'm Serpius and You're Not    ¯\_(ツ)_/¯
Reply
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 3 Guest(s)