I'm trying to understand why the copy database command is not working. I'm in SSMS directly on the db server, I setup the copy job, using (local) as the source and destination, with sa login selected for each. This works fine on my local dev machine setup.
Event Viewer reports:
Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT:
But, I know I have the right password.
This is on Windows Server 2008 with SQL Server 2008. Both the SQL Server and SQL Server Agent services are running under a non-system account (one that was setup when SQL was installed).
Any ideas for what to look at?