dbTalk Databases Forums  

Cannot See DTS Package Created

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Cannot See DTS Package Created in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Joe K.
 
Posts: n/a

Default Cannot See DTS Package Created - 02-01-2005 , 08:17 AM







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?

Reply With Quote
  #2  
Old   
Ilya Margolin
 
Posts: n/a

Default Re: Cannot See DTS Package Created - 02-02-2005 , 08:10 AM






Joe,

What rights do you have in msdb database?

Ilya

"Joe K." <Joe K. (AT) discussions (DOT) microsoft.com> wrote

Quote:
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?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.