Microsoft SQL-DMO (ODBC SQLState:42000) [microsoft] [odbc sql server driver] [sq

From: bab shrestha (babin11_at_yahoo.com)
Date: 04/30/03


Date: Wed, 30 Apr 2003 08:25:35 -0700


I have a package that run DTS from FoxPro to SQL the
packages have been running about 8 months without failure.
Now i need to change the schedule on one of the package
and got an error like:
Microsoft SQL-DMO (ODBC SQLState:42000) [microsoft] [odbc
sql server driver] [sql server] login failed for
user '(null)' Reason: Not Associated with trusted SQl
Server connection
---*********-------
i login as administrator and login for server agent is
also administrator. administrator has complete and
unrestricted permissions. Anybody hae any ideas whould
could be wrong here?



Relevant Pages

  • Re: SSIS as part of scheduled job fails
    ... Can't even open the package. ... Microsoft SQL Server Management Studio ... Encryption not supported on SQL Server. ...
    (microsoft.public.sqlserver.dts)
  • Re: SSIS as part of scheduled job fails
    ... I noticed that you are currently working with Matt and I'd like to know how ... Can't even open the package. ... Microsoft SQL Server Management Studio ...
    (microsoft.public.sqlserver.dts)
  • RE: Could not open global shared memory to communicate w/ performa
    ... a package in BIDS (business Intelligence Development Studio, ... On the SQL Server box, open Programs, SQL Server 2008, COnfiguration Tools, ... for executing SSIS Packages. ... I am logged in as domain administrator yet still have ...
    (microsoft.public.sqlserver.dts)
  • RE: Could not open global shared memory to communicate w/ performa
    ... I am logged in as domain administrator yet still have ... In the SQL Server Configuration, do you have Shared Memory turned on? ... run Sql Server Management Studio as administrator, the package runs perfectly. ... So my problem is how to execute this package with the right privileges. ...
    (microsoft.public.sqlserver.dts)
  • Re: SSIS as part of scheduled job fails
    ... Can't even open the package. ... Deloyed to SQL store. ... Microsoft SQL Server Management Studio ... Encryption not supported on SQL Server. ...
    (microsoft.public.sqlserver.dts)