kjjdelist
Well Known Member
Not exactly a JDEdwards question, but I wouldn't have this question if it
weren't for JDE.
NT4.0 Servers
MSSQL7.0
I recently installed MSSQL SP2, the SQL Hotfix 851, and MDAC2.5 to be in
compliance with JDEdwards' recommended configuration.
Now, I can't run my DTS packages on SQL.
I'm told that 'login failed for user JDE'
Note: JDE is the SQL login being used in ths package.
I went into design view of the DTS package and checked the Connection. It's
using SQL authentication and has JDE in the user field. The password field
was blank, so I typed that in and tried to run the package again, but it
still doen't run.
I've checked the Security in SQL for my JDE account and it's still a System
Admin. It also has access to all necessary databases. I'm kind of at a loss
here.
If any SQL magicians are out there, I'd appreciate any help.
You can reply to [email protected] to keep this topic from interfering
with regular JDEList topics.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
weren't for JDE.
NT4.0 Servers
MSSQL7.0
I recently installed MSSQL SP2, the SQL Hotfix 851, and MDAC2.5 to be in
compliance with JDEdwards' recommended configuration.
Now, I can't run my DTS packages on SQL.
I'm told that 'login failed for user JDE'
Note: JDE is the SQL login being used in ths package.
I went into design view of the DTS package and checked the Connection. It's
using SQL authentication and has JDE in the user field. The password field
was blank, so I typed that in and tried to run the package again, but it
still doen't run.
I've checked the Security in SQL for my JDE account and it's still a System
Admin. It also has access to all necessary databases. I'm kind of at a loss
here.
If any SQL magicians are out there, I'd appreciate any help.
You can reply to [email protected] to keep this topic from interfering
with regular JDEList topics.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.