Monday, March 19, 2012

Logon failure?

Hello,
We just installed SQL Server developer's edition on a new Windows XP Pro
workstation. But whenever we bring up the SQL Server service manager, and
click Start, we get the error:
"The service did not start due to logon failure"
When we did the install, we left the "sa" password blank, and we're using
SQL Server authentication. Can anyone say what might be wrong?
Thanks!!
It's most likely the Windows account that starts up the SQL Server
service. The password is probably expired. Check your SQL
Server Service log on credentials
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:OfpH2J1dFHA.1136@.TK2MSFTNGP12.phx.gbl...
> Hello,
> We just installed SQL Server developer's edition on a new Windows XP Pro
> workstation. But whenever we bring up the SQL Server service manager, and
> click Start, we get the error:
> "The service did not start due to logon failure"
> When we did the install, we left the "sa" password blank, and we're using
> SQL Server authentication. Can anyone say what might be wrong?
> Thanks!!
>
|||Oh, by the way... USE A STRONG PASSWORD FOR 'sa'!!!!
Don't use blanks; a lot of SQL Server exploits use a brute force method
to compromise a system. They'll check for passwords such 'sa' or blank.
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:OfpH2J1dFHA.1136@.TK2MSFTNGP12.phx.gbl...
> Hello,
> We just installed SQL Server developer's edition on a new Windows XP Pro
> workstation. But whenever we bring up the SQL Server service manager, and
> click Start, we get the error:
> "The service did not start due to logon failure"
> When we did the install, we left the "sa" password blank, and we're using
> SQL Server authentication. Can anyone say what might be wrong?
> Thanks!!
>
|||Oh yes, for server deployments of SQL Server, we always use strong
passwords, but the workstation in question is at a home office, and not
connected to the Internet. Thanks!
"Armando Prato" <aprato@.REMOVEMEkronos.com> wrote in message
news:O#ZOgN1dFHA.3836@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Oh, by the way... USE A STRONG PASSWORD FOR 'sa'!!!!
> Don't use blanks; a lot of SQL Server exploits use a brute force method
> to compromise a system. They'll check for passwords such 'sa' or blank.
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:OfpH2J1dFHA.1136@.TK2MSFTNGP12.phx.gbl...
and[vbcol=seagreen]
using
>

No comments:

Post a Comment