Help!

A guy changed our sa-password. now the dts - packages are not running any
more. We do not have the ols passowrd. what do i need to change? The
Server-Agent, the DTS itself? WE have a DTS for dataim- and export running.

Any help is appreciated!
--
Louis

Are the connections using sa as their login credentials?
If yes then you will need to amend the connections

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Louis Haussknecht" <louis (AT) haussknecht (DOT) com> wrote

In article <udW5qH1WDHA.2080 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, Allan Mitchell
<allan (AT) no-spam (DOT) sqldts.com> writes
SQL Server Agent jobs. This is often missed because when you right-click
a package and select Schedule Package it automatically generates the
string for you, but it uses the credentials that you have used in
Enterprise Manager to connect to the server. This means that if someone
used the right-click option to schedule a package AND they used sa
within their Enterprise Manager registration for that server, the sa
username and password will be embedded in the DTSRUN command string. You
won't be able to see that of course because it is encrypted.

Run a SQL Profiler trace for failed logins to help find out where you
may have problems.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com