Results 1 to 4 of 4

Thread: SQL 2005: SSIS: Error using SQL Server credentials

  1. #1
    Join Date
    Aug 2012
    Posts
    1

    Angry SQL 2005: SSIS: Error using SQL Server credentials

    I'm having difficulty getting an SSIS package to work using SQL Server Authentication. I receive the following error:

    "Package Validation Error

    Error at Export Audit data [OLE DB Source [1]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
    An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The server principal "username" is not able to access the database "foo" under the current security context."


    The package works if I switch it back to Windows Authentication and I am able to sign into SSMS directly using the same SQL credentials .

    I've tried setting DelayValidation to 'True' but it made no difference.

    Any insight/suggestions would be greatly appreciated.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Are you executing it from BIDS or scheduling to run it?. Have you looked at package properties to change options to save passwords in the package.

  3. #3
    Join Date
    Aug 2009
    Posts
    50
    did you buy this product or you just downloaded it as free product ? if so, it will not work that is technical error just turn the product back to the vendor to fix it or give you another package

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Error message says that the user doesn't have permission to access. Is it valid user in the db? What kind of permission in it?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •