dbTalk Databases Forums  

Changing Security to Windows Authentications from sql login

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


Discuss Changing Security to Windows Authentications from sql login in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
JP
 
Posts: n/a

Default Changing Security to Windows Authentications from sql login - 04-05-2004 , 04:51 PM






H

I have around 300+ DTS packages, with most of the have been created by users with SQL Login information
MY company is now moving to Windows Authentication.

There two places where we can put SQL Login information in DTS Packages
1. When you create new connection in DTS for SQL Server
2. When you save DTS packages..

It is lots of manual work to change all the dts packages to windows authenticatiosn.
Is there any simple and automatic way to change all the connections to use windows authentications....????
Appreciate your help
Thank
JP

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.