Re: Problem after change sa password in SQL Server 2005.
- From: Charles Calvert <cbciv@xxxxxxxxx>
- Date: Fri, 21 Mar 2008 11:00:03 -0400
On Tue, 18 Mar 2008 07:46:03 -0700, Chen
<Chen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
<CFC93A46-297F-4C98-AEDD-9206A4E68A57@xxxxxxxxxxxxx>:
We use SQL Server 2005 (with SP2) for multi applications. Since sa password
change requested by Internal/External audit, I start this test now.
I got problem after I change the sa password, DB backup that generate from
Maintenance Plan Wizard job was failed. Try to drop and recreate it, I got
error message from SSMS: Exception has been thrown by the target of an
invocation.(mscorlib). Login failed for user 'sa'. (Microsoft SQL Server,
Error:18456).
It sounds like you may have entered the new password with a typo and
so you don't have the correct password. This is possible to do; I've
done it.
Try resetting the sa password again and see if that helps.
--
Charles Calvert | Software Design/Development
Celtic Wolf, Inc. | Project Management
http://www.celticwolf.com/ | Technical Writing
(703) 580-0210 | Research
.
- Prev by Date: Re: I cannot Create an ODBC source for SQL server 2005
- Next by Date: Re: SQL Server 2000 SP4 client connection problem
- Previous by thread: Re: I cannot Create an ODBC source for SQL server 2005
- Next by thread: Re: Visual
- Index(es):
Relevant Pages
|
