Phpbb installation7/7/2023 ![]() ![]() Open the “Add Roles and Features” wizard.Tick the new database and then tick the “db_owner” role.Set the “Default Database” to the new database created.Untick the “Enforce password policy” option.Select the “SQL Server authentication” option and enter the password to use.Enter the name to use for your phpBB connection (e.g.Expand the Security node, right click and select “New Login”.Enter the name for the new database (e.g.Right-click the Database node and select “New Database”.phpBB won’t use Windows Authentication, although Windows Auth can be enabled for other systems that also connect to the SQL server. Open the security page and check that “SQL Server and Windows Authentication mode” is selected.Right click the database server and select Properties.Make sure SQL has SQL authentication enabled.Install SQL, either on the same server or a remote server.I am not explaining how to make this accessible from the internet (yet) so you will need to know how to publish the website through router etc. This is a very simple and *BASIC* installation. I found too many issues with the additional pre-requisites it needed to install and also had problems with it wanting to use MySQL instead of MSSQL. Notice that while I am using the Web Platform to install PHP, I do not use it to install the phpBB forum software. I’ve been “upgrading” over the years and have completely forgotten all the tweaks I needed to make it work, so that as well as dealing with any new “features” of the latest MS software is why I’m writing this entry. ![]() This time around I’m starting a completely fresh install on Windows Server 2012, with IIS 8, and MSSQL 2012. It’s a community that favours Linux/Apache/MySQL, so getting assistance for Windows/IIS/MSSQL is pretty tough. When they released V3 there was a much improved situation with documentation and guides, but it was still a tough thing to get right. Much trial and error resulted in the first forums with V2. My Adventures with PHPBB running on an all Microsoft platform began many years ago. MSSQL user can’t connect until password change.WSUS SUP causes high CPU and clients fail updates scan.ConfigMgr Client missing Health Eval Task.Microsoft Windows Servicing Stack Updates (SSU) – A Rant. ![]()
0 Comments
Leave a Reply. |