cncjunior1
Reputable Poster
Hi,
I have a client who is getting an error when trying to generate a table. It appears from the error messages in the jde.log file that it's a setup issue with the SY812 id on SQL Server 2005, but I'm not very familiar with SQL Server. Any insight is appreciated.
28924/29780 MAIN_THREAD Mon Feb 12 10:21:29.057000 Jdb_ctl.c3488
Starting OneWorld
28924/30472 WRK:Starting jdeCallObject Mon Feb 12 10:24:52.421000 Jdbodbc.c8330
ODB0000163 - wSQLExecute failure. rc=-1
28924/30472 WRK:Starting jdeCallObject Mon Feb 12 10:24:52.421001 Jdbodbc.c8330
ODB0000164 - STMT:00 [08004][916] [Microsoft][SQL Native Client][SQL Server]The server principal "SY812" is not able to access the database "JDE812" under the current security context.
28924/30472 WRK:Starting jdeCallObject Mon Feb 12 10:24:52.421002 Jdb_drvm.c982
JDB9900401 - Failed to execute db request
28924/30472 WRK:Starting jdeCallObject Mon Feb 12 10:24:52.436000 Jdb_exem.c411
JDB21000091 - Failed to create table FY5AF402 in data source System - 812
Thank you
I have a client who is getting an error when trying to generate a table. It appears from the error messages in the jde.log file that it's a setup issue with the SY812 id on SQL Server 2005, but I'm not very familiar with SQL Server. Any insight is appreciated.
28924/29780 MAIN_THREAD Mon Feb 12 10:21:29.057000 Jdb_ctl.c3488
Starting OneWorld
28924/30472 WRK:Starting jdeCallObject Mon Feb 12 10:24:52.421000 Jdbodbc.c8330
ODB0000163 - wSQLExecute failure. rc=-1
28924/30472 WRK:Starting jdeCallObject Mon Feb 12 10:24:52.421001 Jdbodbc.c8330
ODB0000164 - STMT:00 [08004][916] [Microsoft][SQL Native Client][SQL Server]The server principal "SY812" is not able to access the database "JDE812" under the current security context.
28924/30472 WRK:Starting jdeCallObject Mon Feb 12 10:24:52.421002 Jdb_drvm.c982
JDB9900401 - Failed to execute db request
28924/30472 WRK:Starting jdeCallObject Mon Feb 12 10:24:52.436000 Jdb_exem.c411
JDB21000091 - Failed to create table FY5AF402 in data source System - 812
Thank you