Table generation error

[cncjunior1]

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

 

[kicrsa]

Looks like the owner ID sy812 has not been give
permission to the jde812 database.

 

[cncjunior1]

I did some more testing and found some odd results. If I try to generate the table and leave the password field blank, it generates the table fine. If I try to generate the table and fill in the password for the SY812 id using lower case, it fails with the error:
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.

If I type in the password for the SY812 id in lower case I get a database prompt and an error in the log saying the password for SY812 is invalid and the generation fails.

Anyone know any secrets to OMW to know why it would act so differently for each scenario?

Thank you