JMast
Reputable Poster
Hello All,
We are working on an upgrade from SQL 2000 to SQL 2005. We have a very vanilla Intel install of ERP8. We upgraded our development server which has both the development database and JDE logic for DV7334. All is good in JDE and RDA, FDA, and TDA --- until I try to generate a custom table. It gives me a login failure on the testdta user. I know that SQL2005 has schemas, but I was not aware that we had to make changes to security. Am I misinformed?
I can login to the SQL server instance as TESTDTA.
I did test the ODBC connection from the fat client using the TESTDTA id successfully.
I know I need to study up on SQL 2005. I just have a project I was hoping to test on the DEV server this week to get in place before Christmas.
Thanks for the help.
Jer
We are working on an upgrade from SQL 2000 to SQL 2005. We have a very vanilla Intel install of ERP8. We upgraded our development server which has both the development database and JDE logic for DV7334. All is good in JDE and RDA, FDA, and TDA --- until I try to generate a custom table. It gives me a login failure on the testdta user. I know that SQL2005 has schemas, but I was not aware that we had to make changes to security. Am I misinformed?
I can login to the SQL server instance as TESTDTA.
I did test the ODBC connection from the fat client using the TESTDTA id successfully.
I know I need to study up on SQL 2005. I just have a project I was hoping to test on the DEV server this week to get in place before Christmas.
Thanks for the help.
Jer