DTS VB.net SQL login issue

[jediaka]

Hi,

I have a DTS pack on my sql server.
I am trying to execute it from a vb.net webapp using
SQL server security.

but I keep getting :
"Cannot open user default database. Login failed. at DTS.Package2Class.LoadFromSQLServer(..."

Do I have to set permission so that my sql server user ( not WinNT user ) can run the DTS. If so how to do it?

Tanks in advance.

ps: the user name and password are correct ( I get a different message when they are not)

 

[jediaka]

Correction,

I have the problem fixed,
I simply had to grant access to the user for the default database.

duh.

I can't believe I missed that , I feel terribly ashamed and I will revoke my IT license.