Hi

I had my DBA to create a DTS Package in a SqlServer and I am trying to
run it using LoadFromSQLServer from C#. Its giving exception that the
user is "not a valid user in database 'msdb'". "Public" group has been
given rights to sp_get_dtspackage, so I am not able to see any reason
why this is happening (why it is checking if that particular user is in
that Database or not).

I tried to simulate the whole thing with a SqlServer version installed
in my machine and nothing seems to be wrong with it. Can anyone think
of a reason why this is happening.

Thanks
Jeevan

I apears that the user that executes the request does not have permissions to
the msdb database.

Public is a role, therefore, either that public role has to be assigned to
that specific account or it needs to be added to the database as a user in
msdb.

"jeevankodali (AT) gmail (DOT) com" wrote:

That user is already in public role (DBA told me that all the users
will be under Public role). DBA does not want to add that user in
"msdb". So I am not sure if there is someother problem.