Need help with PHPBB setup and sql security

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Need help with PHPBB setup and sql security

Author

Topic

boiseneon
Starting Member

2 Posts

Posted - 2006-02-10 : 00:10:15

I run a windows 2003 server with sql server 2000. I set up everything according to the how to but I am getting this error when I do the php setup...I am pretty sure it is a security thing with sql server but have never used it before.

phpBB : Critical Error 

Could not connect to the database

DEBUG MODE

SQL Error : Login failed for user 'BEAVIS\IUSR_BEAVIS'.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-02-10 : 00:51:31

the user do not have access to the database (need to add it)

ask your DBA to provide the permission at SQL server

HTH

--------------------
keeping it simple...

boiseneon
Starting Member

2 Posts

Posted - 2006-02-10 : 10:09:09

ok how do I add the user to the database? I am the administrator of everything I am working on

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-02-10 : 19:05:37

quote:
Originally posted by boiseneon

ok how do I add the user to the database? I am the administrator of everything I am working on

Got to Enterprise Manager - Security - Logins

or use sp_addlogin

----------------------------------
'KH'
everything that has a beginning has an end

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-02-12 : 20:58:27

if the user already exists in the server:

use [databasename]
go
exec sp_grantdbaccess 'beavis\iusr_beavis','beavis\iusr_beavis'
--provide appropriate permissions

otherwise, if you are also the administrator of the server:
issue the sp_addlogin statement as per khtan

--------------------
keeping it simple...

my_aro
Yak Posting Veteran

50 Posts

Posted - 2006-02-13 : 10:17:15

hey friend,

i dont know if you can do it in mssqlserver, all i know is that phpBB uses mysql as the database or postGres(but not mostly used as for today), and as far as i have done several web projects having forums, and using phpBB, it is "always" mysql that is used for phpBB for reasons that php is actually designed for mysql as dbserver.

try to look at the logo, it says "powered by mysql; powered by phpBB"

but if u think it does work with mysqlserver try to locate the database driver call inside the phpBB file then change it so it will use an mssqlerver driver for connection... try to locate the config.php packed with the phpBB zipped file the right click on that then try to check owner - execute; group - read; and all users - read and as u run tru the web project phpBB will install all databases..

and i think u dont have to run the database name yourself since phpBB will automatically run tru it..

hope this helps!

God Bless..

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources