Jump to the post that solved this thread.
Solved: 2 Years, 8 Months, 2 Weeks ago Cannot connect to database. :(
#1
Solved: 2 Years, 8 Months, 2 Weeks 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: 2 Years, 8 Months, 2 Weeks 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.
Reply
#3
Solved: 2 Years, 8 Months, 2 Weeks ago
Yeah, correct PW and account is the standard SA server admin with all the permissions.
Reply
#4
Solved: 2 Years, 8 Months, 2 Weeks ago
Instead of localhost try using the IP.
Plugin Count: I lost count.
Public Plugins are available here.
Official GitHub.
Please do not PM me for support unless asked to.
Reply
#5
Solved: 2 Years, 8 Months, 2 Weeks 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    ¯\_(ツ)_/¯
Deaf Golf
Reply
#6
Solved: 2 Years, 8 Months, 2 Weeks 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: 2 Years, 8 Months, 2 Weeks ago
MyBB 1.8 doesn't support Microsoft SQL server. We support MySQL, PostgreSQL and SQLite.
Reply
#8
Solved: 2 Years, 8 Months, 2 Weeks 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: 2 Years, 8 Months, 2 Weeks ago
See here. The recommended version of MySQL you can run is 8.0.
Plugin Count: I lost count.
Public Plugins are available here.
Official GitHub.
Please do not PM me for support unless asked to.
Reply
#10
Solved: 2 Years, 8 Months, 2 Weeks 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    ¯\_(ツ)_/¯
Deaf Golf
Reply
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)