• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

MSSQL DTS Packages

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 kjjdelist@hotmail.com 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.
 
Top