I have not been able to install SQL ExpressÃÂ SP2ÃÂ (standard or advanced) on Vista Ultimate (RTM). Every time I try to install, I get the following error message:
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.
When I check the logs, the only information I can find that is at all useful is:
Doing Action: Do_sqlScriptPerfTime Start: Do_sqlScript : Thu Mar 01 21:35:42 2007Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Mar 01 21:35:42 2007SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connectionsService MSSQL$SQLEXPRESS started at Thu Mar 01 21:35:48 2007SQL_ERROR (-1) in OdbcConnection::connectsqlstate=28000, level=-1, state=-1, native_error=18456, msg=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ Error Code: 0x80074818 (18456)Windows Error Text:ÃÂ ÃÂ Source File Name: lib\odbc_connection.cppCompiler Timestamp: Wed Jun 14 16:28:15 2006ÃÂ ÃÂ ÃÂ ÃÂ Function Name: OdbcConnection::connect@connectSource Line Number: 148
Has anyone else run into this issue and resolved it? I have seen posts for earlier versions of SQL Express that said to run
View Complete Post