Server user 'ABC' is not a valid user in database 'msdb

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

batgirl - 25 Sep 2006 15:30 GMT

When I try to run a DTS package as a job, this is the error message I
receive. The user has db_datareader, db_datawriter and db_ddladmin rights.
All the DTS does is execute a stored procedure and put the results in an
excel file.
Any help is appreciated
Thanks
SS

Reply to this Message

Sue Hoegemeier - 25 Sep 2006 17:40 GMT

You'd probably want to start by taking a look at the job
owner. The following article provides information needed to
run a DTS package from a job in both SQL 7 and SQL 2000:
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/?id=269074

-Sue

>When I try to run a DTS package as a job, this is the error message I
>receive. The user has db_datareader, db_datawriter and db_ddladmin rights.
[quoted text clipped - 3 lines]
>Thanks
>SS

Reply to this Message

batgirl - 25 Sep 2006 17:56 GMT

The job owner is sa. The user is not an orphan user.

Signature

batgirl

> You'd probably want to start by taking a look at the job
> owner. The following article provides information needed to
[quoted text clipped - 11 lines]
> >Thanks
> >SS

Reply to this Message

Sue Hoegemeier - 25 Sep 2006 18:56 GMT

Can you run the package manually? If you get any errors,
what are they?
You said the job owner is sa and in your original post you
said "The user has db_datareader, db_datawriter and
db_ddladmin rights. "
Who is this user and how does it related to the job and
package?

-Sue

>The job owner is sa. The user is not an orphan user.

Reply to this Message

batgirl - 25 Sep 2006 19:39 GMT

The user is a SQL user that is used in the DTS package to connect to the SQL
server. The package just executes a stored procedure.

Signature

batgirl

> Can you run the package manually? If you get any errors,
> what are they?
[quoted text clipped - 7 lines]
>
> >The job owner is sa. The user is not an orphan user.

Reply to this Message

Sue Hoegemeier - 25 Sep 2006 20:28 GMT

Just trying to guess at whatever else you have set up in the
package, if you have package logging, remove it.
Normally if the user you are getting the error for is only
used to connect to a server and a specific database to just
execute a stored procedure on that server and in that
database and the user is not an orphan and has the required
permissions in the database, you wouldn't get an error for
msdb. It would just connect to the server and access that
database. So some other piece of information is missing and
package logging is the only guess off the top of my head.

-Sue

>The user is a SQL user that is used in the DTS package to connect to the SQL
>server. The package just executes a stored procedure.

Reply to this Message