nileshm
15th April 2009, 07:45
Hi

I have taken a backup SQL db of live server and restored it on development server. After that when i tried to run baan, system is giving me error -

Fatal error : Error 1916 (bdb_errno 1916) on select
Fatal error : can not continue in ottsttpstdlib (mess)

Can anybody help me to start baan application normally?

Thanks

Nilesh M.

sushil
15th April 2009, 09:00
Hi,

Please check and post Windows error Log .

BR,
Sushil Kumar Mudaliar

ahmer91
15th April 2009, 09:06
acutally it is permission problem , i had the similar problem , here is the remedy:
1 : DELETE DEFAULT BAAN LOGIN baan AND GROUP baan4dbg

2: EXECUTE BELOW QUERY

use master
EXEC sp_addlogin baan_id,password,baan_dbname
use baan4db -- or your baan dbname here
EXEC sp_changedbowner baan4db, baan
use baan4db
EXEC sp_addrole baan4dbg
use baan4db
grant create table to baan4dbg
use baan4db
EXEC sp_adduser baan
EXEC sp_addrolemember baan4dbg, baan

3. AFTER THIS SET PERMISSION of user baan TO DB_OWNER TO DATABASE BAAN4DB

ahmer91
15th April 2009, 09:08
update post if it helps or pm if need further help

nileshm
18th April 2009, 15:34
Dear ahmer91

Thanks very much. My problem get resolved after following your instructions. Now i can easily logged in.

Thanks

Nilesh