PHpBB, SQL problems.

[pillage2001]

I'm trying to run PhpBB2 on my computer which has the Win XP Pro OS and installed with MS SQL 2000. Thing is, when I installed SQL2000, it did not let me install the 2000 server but just the normal application installation. I tried installing PhpBB2 but upon clicking the installation button, a Critical Error comes up and says that I cannot create a database.

I'm really dumbfounded and don't know what else should I do. Should I just install it straight on a win2k Server machine which I'm suppose to run it on instead of trying to run it on my pc cause the SQL2000 installation went fux0rz?

 

[AFB]

Can you create a DB manualy ?

 

[Firus]

You can install the tools for SQL2000 on winXP but, the database engine from SQL Server 2000 Enterprise Edition or Standard Edition cannot be installed on Windows XP. You can however install MSDE on windows XP and use SQL Enterprise manager with that.

 

[GilletteCat]

Originally posted by: Firus
You can however install MSDE on windows XP and use SQL Enterprise manager with that.

I think thst is what he did.
The issue, I think, is that CREATE DATABASE and DROP DATABASE are only allowed for sa (or if setup based on windows and AD - for domain admins and enterprise admins and such)
I doubt that the installer for the phpBB has been setup to run under sa profile.

 

[Cerebus451]

The problem is that you do not have an SQL Server running. Only the Personal Edition of SQL Server will allow you to install the database server on a non-server OS, and XP is not a server OS. The applications that you installed are the enterprise manager programs that will allow you to talk to another SQL Server. You will either need to get a copy of the Personal Edition to actually install a database server on your XP platform, or install your database on a server OS and connect to that.