Re: Change sa pasword affect current DTS packages

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 12:56:21 -0000

No you will not need to rebuild transformations
If you use the ~Z option of DTSRUN and you specified sa as the username to
get onto the SQL Server you will need to regenerate this as it will have
saved your blank password inside. 

-- 
----------------------------
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Jen" <anonymous@discussions.microsoft.com> wrote in message
news:1285001c41196$03f80910$a301280a@phx.gbl...
> hi,
>
> Thanks for the the advice to my earlier question.
>
> now I have another..
>
> I have quite a number of DTS package that were created
> with  the current sa account with blank password.
>
> Now I want to change a password for my sa account.
>
> Do I just have to resave my DTS package with the new
> password key in ?
>
> Will it affect my transformation(meaning I need to
> redefine etc.)  or anything at all ? I hope not..

Relevant Pages

  • Re: logon failure
    ... MSSQLServer service after you change the username of administrator account. ... username for the SQL Server startup service account or the SQL Server Agent ... Microsoft SQL Server service account on the SQL Server host computer. ...
    (microsoft.public.windows.server.sbs)
  • Re: xp_cmdshell and dtsrun
    ... The Sql Server Service account and Server ... Agent Service account are both the same... ... I'm not having a problem executing the the DTS Package, ...
    (microsoft.public.sqlserver.programming)
  • Re: Error running DTS package on a schedule (only!)
    ... I use Remote Desktop to access the server where the DTS package was ... > Right Click on the SQL Server Agent icon in EM and choose properties. ... > page here will tell you the account. ...
    (microsoft.public.sqlserver.dts)
  • Re: Creating a DTS ActiveX Task
    ... (this is the service that runs jobs in SQL Server) ... the 'logon as' tab, you'll see what account this service runs as, this is ... from the network from your DTS package you'll be fine, ... > I'm not very familiar with SQL Server, I only know some VB and TSQL. ...
    (microsoft.public.sqlserver.programming)
  • Re: dts import/export problems
    ... it is configured for mixed mode authentication already. ... in security there is a 'start and run sql server in the following account' option that has a username and password entered. ...
    (microsoft.public.sqlserver.server)