While running a copy of the production database for a new
machine. I get a CDW error.

Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 28000)
Step Error Description:[Microsoft][ODBC SQL Server Driver]
[SQL Server]Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection.
Step Error code: 80004005
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:700

OK

Is one or both of the boxes setup to only accept Windows Authentication and
you have specified a SQL Server Login in the credentials?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


"garry" <garrydawkins (AT) hotmail (DOT) com> wrote

GDawkins

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

The login failed for user NULL indicates that the account that is logging
cannot be validated on the domain.

Rand
This posting is provided "as is" with no warranties and confers no rights.