Re: Cannot See DTS Package Created

From: Ilya Margolin (ilya_no_spam__at_unapen.com)
Date: 02/02/05


Date: Wed, 2 Feb 2005 09:10:36 -0500

Joe,

What rights do you have in msdb database?

Ilya

"Joe K." <Joe K.@discussions.microsoft.com> wrote in message
news:879BAF90-EA96-49EB-BF2E-B29815B270CD@microsoft.com...
>
> I'm SQL Server developer dbo priviledges to a database. I have created 10
> DTS packages but cannot see them in the SQL Server 2000 Enterprise
Manager.
> I deleted and add the SQL Server registration. The old SQL Server had
> authentication with SQL Server and Windows. The new registered SQL Server
was
> Windows only. After the new registered SQL Server with Windows only I
cannot
> see my 10 DTS packages.
>
> How can I resolve this issue without have to register SQL Server with
> authentication?



Relevant Pages

  • RE: Recover SQL files & DST packages from server backup
    ... > after you install the OEM copy on the SBS box. ... If the DTS Packages are saved to SQL Server, they would be saved in the ... > sysdtspackages table in the SQL Server msdb database. ...
    (microsoft.public.windows.server.sbs)
  • Re: Very Very Urgent, Please Help
    ... does your packages are stored in the MSDB database? ... Have you changed your main package to use the right SQL Server instance? ... When my main dts package calls other dts packages getting timeout immediately. ...
    (microsoft.public.sqlserver.datawarehouse)
  • guest user in msdb
    ... dts packages and i donīt want that this users have ... permissions to create it. ... in the msdb database. ... if i this change can cause problems in sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: Connections errors
    ... The reason it is making an NT level connection is because by default, for each registered SQL Server, EM will periodically ping the ...
    (microsoft.public.sqlserver.security)
  • Re: Connections errors
    ... >The error might be this Windows bug: ... >312827 An Incorrect Authentication Package Name May ... by default, for each registered SQL Server, EM will ... >registered server's OS to see if SQL Server is started. ...
    (microsoft.public.sqlserver.security)