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

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

On Mon, 25 Sep 2006 11:39:02 -0700, batgirl
<batgirl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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.

.

Relevant Pages

  • Re: Creating a database
    ... Please do yourself a favor, find a local user group, or buy a beginning book on SQL Server or take a class, you will save yourself a great deal of pain in the long run. ... CREATE DATABASE Products ... I can create a stored procedure from within the Server Explorer and from ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Facing the same problem
    ... My stored procedure is being activated from a Service Broker ... remote server is denied because the current security context is not ... The linked server is a SQL server, but not one where I have any ... ALTER DATABASE db SET TRUSTWORTHY ...
    (microsoft.public.sqlserver.security)
  • Re: connecting to two adp projects error-
    ... We have an ADP which is linked to one database but which has to ... make a call on startup to a second database for extended user ... Your point of handling action on the server is taken. ... T-SQL code in your stored procedure. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Design question
    ... username and password on the App Server and Database server and synchronize ... recommend using the stored procedure for security and performance reasons. ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: ADP/SQL Server 2000 Security Problem
    ... I executed the stored procedure for two individual users after I attached ... > before the reattachment of the database? ... >> users are connecting to the server as guests. ... >> I'll also test using a SQL Server account and see what happens. ...
    (microsoft.public.access.adp.sqlserver)