I've successfully installed mydbr community edition (myDBR 2.9.1 build 1131) on Win2008R2 running IIS and MSSQL 2008 R2 Express. I can login, create users, reports, folders but the interface begins to behave strangely after a few minutes of work. For example I'll edit a folder name and select OK, but the folder name never changes. Or I'll go into SQL Editor, select Show Query Builder then the database and no objects are listed (where they were previously there 5 minutes ago). Or I'll edit a report and there's no display of assigned users under the Report Privileges section. If I go to Users, I do get an error saying "Notice: Undefined index: ajax_ref in C:\inetpub\wwwroot\apps\users.php on line 34" and it won't let me add users.
All point to some kind of connection issue with the database I think.
The mydbr database user has the dbadmin role on the mydbr database and dbdatareader role on the report database. The freetds.conf contents are:
[global]
host = localhost
port = 1433
client charset = UTF-8
tds version = 8.0
text size = 64512
Mydbr_config.php contents: (with name/password changed)
define( "DB_VENDOR", 'mssql' );
define( "DB_HOST", 'localhost' );
define( "DB_PORT", NULL );
define( "DB_NAME", 'mydbr' );
define( "DB_USER", 'admin' );
define( "DB_PASSWORD", 'password' );
define( "SETUP_DONE", true );
I can also configure the mssql.php file in the tools\troubleshooting folder with the correct credentials and it tells me the connection is ok.
Any ideas on what is going on?
Thanks,
-nth-