I'm trying to install phpBB, and all I need is a working SQL database w/ login etc. I have tried using mySQL and it wouldn't let me change the password (I guess this is a common issue) so now I'm trying MS SQL and even it's not working. Here is the phpBB login:
My username / password are below that. When I press 'Next Step' it gives me that error. I have Microsoft SQL Server 2005 Express installed, and when I run the SQL Server Configuration Manager, I set the Logon as: Local System (so I set my username/password to my servers login. Let me know if this is incorrect). Regardless, it should still connect and I'm curious to why it won't. I'm new to this somewhat, but I don't see a tool installed to edit/add databases, just the service itself. Any help?
By default SQL express accepts only shared-memory connections. (generally supported by other MSFT products and only works on the local machine) phpBB for obvious reasons connects via TCP/IP. To use it with SQL express you'll need to enable TCP/IP connectivity. Don't bother with Named Pipes, that's not needed. To enable TCP, follow these instructions:
http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx
Edit: ADD
Additionally you'll need to create a SQL account for phBB to use. Follow this guide to create an account:
http://msdn.microsoft.com/en-us/library/aa337562.aspx
and then grant the account access. The easiest way to test it out would be to grant your new user DBO access to the DB in question. Ratchet it down as needed after that. (if you care)
Note you may need to enable SQL auth as outlined in the first post here:
http://social.msdn.microsoft.com/Forums/eu/Vsexpressinstall/thread/aaf2f68c-4a40-44c8-b7ee-b2f5d94e23c3
Try a database name with no spaces. This is not asking for what kind of database you have. Each sql server instance can play host to multiple databases, and so it needs to know the name of the particular database within your sql server installation it should use. It's also unclear to me whether it wants to create this database or expects it to already exist. If it's looking for an existing database, you may need to use Sql Server Management Studio (or similar tool) to create it.
Try localhost\SQLEXPRESS or \SQLEXPRESS for the server hostname or DSN. Sql Server can install multiple instances to the same machine, and uses this convention to distinguish which instance you need. Express Edition often installs using the \SQLEXPRESS named instance by default.
You might have some luck populating your config.php file manually.
That error smells like a SQL injection vulnerability. Does your username and/or password have quotes, spaces, special characters - basically anything non-alphanumeric?
You might also find these form threads to be useful (or at least entertaining):