DB cant be found. DSN (write): NOT OK(MDB2 Error: not found)

[nlks]

Hi all,

I'm new here to ask for help setting up RoundCube.
I'm having problem setting up Roundcube with IIS + MSSQL 2005 on a Windows 2008 Server.
The Roundcube & Database server are in the same box.

Below is my software and roundcube configuration:

PHP Installed.



MSSQL DB Configuration:

I have no experience on this, thus I created an accounts (RCDBADM) in server login & also database security, and also granted all server roles to the ID.
(May i know where actually the ID should be created and which role to grant?)

Roundcube DB Configuration:

I don't see MSSQL can be selected from the list.
However, i have changed it manually in the db.inc.php:
$rcmail_config['db_dsnw'] = 'mssql://rcdbadm:********@localhost/roundcubedb';

Almost everything is OK & I have tested SMTP & IMAP config successfully.
The only error is the database cannot be found. Error is as below:
DSN (write):  NOT OK(MDB2 Error: not found)
Make sure that the configured database exists and that the user has write privileges
DSN: mssql://rcdbadm:********@localhost/roundcubedb

I did search in forum and found some post saying it could be cause by MDB2 Package or driver thingy.
However I have no idea on both of these and I never installe anything about MDB2.
With the image can anyone enlighten me whether my environment is ready?
If yes then how come Roundcube still not able to connect to my DB?Am I still missing something?

Hope someone can assist me on this. Thanks.

[alec]

DSN (write):  NOT OK(MDB2 Error: not found)
Make sure that the configured database exists and that the user has write privileges
DSN: mssql://rcdbadm:********@localhost/roundcubedb

Check logs for more information. This database driver is not fully supported (especially in Installer). You can try changing 'mssql' with 'sqlsrv'.

[nlks]

Do you means the logs for Roundcube?
May I know where are the logs located?

By the way I have already tried sqlsvr:// but same error occur

[nlks]

Dear all,

I manage to rectify the problem by changing the DB to MySQL.
Problem solved. Thank for all your assistant