Wednesday, March 7, 2012

ref mail error

when I attepmt to start SQL ServerAgent I get the
following error messages:
[298] SQLServer Error: 18456, Login failed for user 'sa'.
[SQLSTATE 28000]
[000] Unable to connect to server '(local)';
SQLServerAgent cannot start
In SQL ServerAgent properties my sa password is correct
and I get a similar error message when I select 'Use
Windows authentication' on the Server Conection tab, can
this be caused by a problem with my Service Startup
acount ?
> when I attepmt to start SQL ServerAgent I get the
> following error messages:
> [298] SQLServer Error: 18456, Login failed for user 'sa'.
> [SQLSTATE 28000]
> [000] Unable to connect to server '(local)';
> SQLServerAgent cannot start
> In SQL ServerAgent properties my sa password is correct
> and I get a similar error message when I select 'Use
> Windows authentication' on the Server Conection tab, can
> this be caused by a problem with my Service Startup
> acount ?
The Builtin\Administrators might have been removed as a sysadmin.
Hope this helps,
Eric Crdenas
SQL Server senior support professional

No comments:

Post a Comment