Login failed for user 'sa' During Install for SQL Server 2005 Express - by tysonnero

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


0
0
Sign in
to vote
ID 355471 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 7/8/2008 7:38:03 PM
Access Restriction Public

Description

I am doing a clean install of SQL Server 2005 Express Edition Service Pack 2. While the installer is on the SQL Server Database Services and the Status says Configuring Microsoft SQL Server, it produces this error:

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29515&EvtType=lib%5codbc_connection.cpp%40Do_sqlScript%40OdbcConnection%3a%3aconnect%40connect%40x4818

I have attempted many variations of the install with no success. I have done manual removals of SQL Server 2005 before installs. I have searched and searched for a solution. Nothing thus far.
Sign in to post a comment.
Posted by Microsoft on 9/17/2008 at 11:37 AM
This issue has been resolved as more information is needed for investigation. If you still have this issue and need us to investigate further, please provide the required information.

Thanks,
Peter Saddow [Microsoft]
Posted by Microsoft on 7/23/2008 at 6:50 AM
Hello,

Sorry to hear that you are having problems installing SQL Server! Based on the information we got from the logs, it is not clear the exact reason for failure.

During configuration phase of install, we start SQL Server to configure it in so-called single-user mode, which tries to connect to the server as “sa” account and with a newly placed master database it has a blank password. However, in the SQL Server error log, there is a series of login attempts:

2008-07-08 21:56:06.73 Logon     Error: 18456, Severity: 14, State: 10.
2008-07-08 21:56:06.73 Logon     Login failed for user 'sa'. [CLIENT: <local machine>]

which is an indication that there are problems validating password policy for this account. As I mentioned with a newly installed instance this password should be blank and we suspect that there may be general security infrastructure problems. If you are aware of any specifics of security policies on your machine, please do let me know. I don’t have any specific recommendation at this point except to check Windows error logs for any potential causes.

Few other options to try: try installing on another disk (if applicable) or using Windows Authentication only. Please do let me know if this helps or not or if you aware of any other potential causes for this error.

Thank you,
Boris.
Posted by Microsoft on 7/23/2008 at 6:48 AM
Hello,

Sorry to hear that you are having problems installing SQL Server! Based on the information we got from the logs, it is not clear the exact reason for failure.

During configuration phase of install, we start SQL Server to configure it in so-called single-user mode, which tries to connect to the server as “sa” account and with a newly placed master database it has a blank password. However, in the SQL Server error log, there is a series of login attempts:

2008-07-08 21:56:06.73 Logon     Error: 18456, Severity: 14, State: 10.
2008-07-08 21:56:06.73 Logon     Login failed for user 'sa'. [CLIENT: <local machine>]

which is an indication that there are problems validating password policy for this account. As I mentioned with a newly installed instance this password should be blank and we suspect that there may be general security infrastructure problems. If you are aware of any specifics of security policies on your machine, please do let me know. I don’t have any specific recommendation at this point except to check Windows error logs for any potential causes.

Few other options to try: try installing on another disk (if applicable) or using Windows Authentication only. Please do let me know if this helps or not or if you aware of any other potential causes for this error.

Thank you,
Boris.