SQL Server 2005 Express Edition fails to install

Shawn Kovalchick

unread,

Oct 28, 2005, 12:52:26 PM10/28/05

to

While installing the release version of Visual Studio 2005 from MSDN
(10/27/2005), MS SQL Server 2005 Express Edition fails. I had this same
problem with thr RC version from 9/12/2005.

From summary.log:
Machine : SKOVALCHICK-PC
Product : SQL Server Database Services
Error : SQL Server Setup failed to execute a command for
server configuration. The error was [Microsoft][SQL Native Client][SQL
Server]Cannot alter the login 'sa', because it does not exist or you do
not have permission.. Refer to the server error logs and Setup logs for
detailed error information.
--------------------------------------------------------------------------------
Machine : SKOVALCHICK-PC
Product : SQL Server Database Services
Error : SQL Server Setup failed to execute a command for
server configuration. The error was [Microsoft][SQL Native Client][SQL
Server]Cannot alter the login 'sa', because it does not exist or you do
not have permission.. Refer to the server error logs and Setup logs for
detailed error information.
--------------------------------------------------------------------------------
Machine : SKOVALCHICK-PC
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0010_SKOVALCHICK-PC_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup failed to execute a command for
server configuration. The error was {Microsoft}{SQL Native Client}{SQL
Server}Cannot alter the login 'sa', because it does not exist or you do
not have permission.. Refer to the server error logs and Setup logs for
detailed error information.
Error Number : 29521

Shawn Kovalchick

unread,

Oct 28, 2005, 1:52:28 PM10/28/05

to

***Additional Information***
From SQLSetup0010_SKOVALCHICK-PC_SQL.log. This is the function that is
dying.

<Func Name='LaunchFunction'>
Function=Do_sqlScript
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Fri Oct 28 12:12:46 2005
Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q
-qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being
started at Fri Oct 28 12:12:46 2005
SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL
service to accept client connections
Service MSSQL$SQLEXPRESS started at Fri Oct 28 12:13:04 2005
Loaded DLL:
C:\WINDOWS\system32\Odbc32.dll
Version:
3.525.1117.0

SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connect
sqlstate=01000, level=-1, state=-1, native_error=5701,
msg=[Microsoft][SQL Native Client][SQL Server]Changed database context
to 'master'.
sqlstate=01000, level=-1, state=-1, native_error=5703,
msg=[Microsoft][SQL Native Client][SQL Server]Changed language setting
to us_english.

SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batch
sqlstate=01000, level=0, state=1, native_error=5701, msg=[Microsoft][SQL
Native Client][SQL Server]Changed database context to 'master'.

SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batch
sqlstate=01000, level=0, state=1, native_error=15457,
msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'show
advanced options' changed from 0 to 1. Run the RECONFIGURE statement to
install.

SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batch
sqlstate=01000, level=0, state=1, native_error=15457,
msg=[Microsoft][SQL Native Client][SQL Server]Configuration option
'default language' changed from 0 to 0. Run the RECONFIGURE statement to
install.
sqlstate=01000, level=0, state=1, native_error=15457,
msg=[Microsoft][SQL Native Client][SQL Server]Configuration option
'default full-text language' changed from 1033 to 1033. Run the
RECONFIGURE statement to install.

SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batch
sqlstate=01000, level=0, state=1, native_error=15457,
msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'show
advanced options' changed from 1 to 0. Run the RECONFIGURE statement to
install.

SQL_ERROR (-1) in OdbcStatement::execute_batch
sqlstate=42000, level=16, state=1, native_error=15151,
msg=[Microsoft][SQL Native Client][SQL Server]Cannot alter the login

'sa', because it does not exist or you do not have permission.

Error Code: 0x80073b2f (15151)
Windows Error Text: Source File Name: lib\odbc_statement.h
Compiler Timestamp: Mon Jun 13 14:30:24 2005
Function Name: OdbcStatement::execute_batch@CnfgSQL@120
Source Line Number: 91

---- Context -----------------------------------------------

Connecting to SQL Server
ExecuteSqlCommands
USE [master ]
<Started SQL statement: Fri Oct 28 12:13:05 2005>declare @ServerName
nvarchar(255) if not exists (select * from sysservers) begin select
@ServerName = Convert(nvarchar(255), SERVERPROPERTY(N'ServerName'))
execute sys.sp_addserver @ServerName, local end
<Finished SQL statement: Fri Oct 28 12:13:06 2005>
<Started SQL statement: Fri Oct 28 12:13:06 2005>ALTER DATABASE model
SET RECOVERY SIMPLE
<Finished SQL statement: Fri Oct 28 12:13:06 2005>
<Started SQL statement: Fri Oct 28 12:13:06 2005>EXEC sp_configure
N'show advanced options', 1 RECONFIGURE WITH OVERRIDE
<Finished SQL statement: Fri Oct 28 12:13:07 2005>
<Started SQL statement: Fri Oct 28 12:13:07 2005>DECLARE @Name AS
nvarchar(128), @LangID AS smallint SELECT @Name=name, @LangID=langid
FROM syslanguages WHERE lcid=1033 EXEC sp_defaultlanguage N'sa', @Name
EXEC sp_configure N'default language', @LangID EXEC sp_configure
N'default full-text language', 1033 RECONFIGURE WITH OVERRIDE
<Finished SQL statement: Fri Oct 28 12:13:07 2005>
<Started SQL statement: Fri Oct 28 12:13:07 2005>EXEC sp_configure
N'show advanced options', 0 RECONFIGURE WITH OVERRIDE
<Finished SQL statement: Fri Oct 28 12:13:07 2005>
<Started SQL statement: Fri Oct 28 12:13:07 2005>EXEC sys.sp_grantlogin
N'BUILTIN\Administrators' EXEC sys.sp_addsrvrolemember
N'BUILTIN\Administrators', N'sysadmin'
<Finished SQL statement: Fri Oct 28 12:13:08 2005>
<Started SQL statement: Fri Oct 28 12:13:08 2005>EXEC sys.sp_grantlogin
N'NT AUTHORITY\SYSTEM' EXEC sys.sp_addsrvrolemember N'NT
AUTHORITY\SYSTEM', N'sysadmin'
<Finished SQL statement: Fri Oct 28 12:13:08 2005>
<Started SQL statement: Fri Oct 28 12:13:08 2005>EXEC sys.sp_grantlogin
N'SKOVALCHICK-PC\SQLServer2005MSSQLUser$SKOVALCHICK-PC$SQLEXPRESS' EXEC
sys.sp_addsrvrolemember
N'SKOVALCHICK-PC\SQLServer2005MSSQLUser$SKOVALCHICK-PC$SQLEXPRESS',
N'sysadmin'
<Finished SQL statement: Fri Oct 28 12:13:08 2005>
<Started SQL statement: Fri Oct 28 12:13:08 2005>EXEC sys.sp_grantlogin
N'BUILTIN\Users'
<Finished SQL statement: Fri Oct 28 12:13:08 2005>
<Started SQL statement: Fri Oct 28 12:13:08 2005>ALTER DATABASE tempdb
SET NEW_BROKER ALTER DATABASE msdb SET NEW_BROKER
<Finished SQL statement: Fri Oct 28 12:13:08 2005>
<Started SQL statement: Fri Oct 28 12:13:08 2005>EXEC
sp_SetAutoSAPasswordAndDisable
Originial error was 80073b2f (15151)

Error Code: 15151
MSI (s) (AC!60) [12:13:08:791]: Product: Microsoft SQL Server 2005
Express Edition -- Error 29521. SQL Server Setup failed to execute a

command for server configuration. The error was [Microsoft][SQL Native
Client][SQL Server]Cannot alter the login 'sa', because it does not
exist or you do not have permission.. Refer to the server error logs and
Setup logs for detailed error information.

Error 29521. SQL Server Setup failed to execute a command for server

configuration. The error was [Microsoft][SQL Native Client][SQL
Server]Cannot alter the login 'sa', because it does not exist or you do
not have permission.. Refer to the server error logs and Setup logs for
detailed error information.

Michael Cheng [MSFT]

unread,

Oct 31, 2005, 4:51:24 AM10/31/05

to

Hi Shawn,

Thanks for your post.

From your descriptions, I understood you installation for SQL Server 2005
Express Edition failed with the error message "Cannot alter the login 'sa',
because it does not exist or you do not have permission". If I have
misunderstood your concern, please feel free to point it out.

Would you please help me answering the question below before we narrow down
this issue?

1. What's your operating system for SQL Server 2005 Express?
2. Have you installed previous version of SQL Server before, such as SQL
Server 2000, MSDE?
3. Does you account that you used to log in the Windows has administrator
permission?
4. Please make sure the account has sufficient permission for the
installation folder.

I think a detailed SQL installation log are also very helpful, it will
defaultly be located at C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG. Would you please compress all the files under LOG folder and
then send the zipped file to me? I understand the information may be
sensitive to you, my direct email address is v-mi...@online.microsoft.com
(please make sure you have removed "online" as it's only for SPAM), you may
send the file to me directly and I will keep secure.

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/

If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

tim2u

unread,

Oct 31, 2005, 1:31:30 PM10/31/05

to

Same issue here. I do have SQL 2000 installed. Here is my error log:

[10/31/05,12:42:30] Microsoft SQL Server 2005 Express Edition x86: [2]
Component Microsoft SQL Server 2005 Express Edition x86 returned an
unexpected value.
***EndOfSession***[10/31/05,12:42:30] Microsoft SQL Server 2005 Express
Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86
returned an unexpected value.
[10/31/05,12:42:33] VS70pgui: [2] DepCheck indicates Microsoft SQL Server
2005 Express Edition x86 is not installed.
***EndOfSession***[10/31/05,12:56:10] Microsoft SQL Server 2005 Express
Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86
returned an unexpected value.
***EndOfSession***[10/31/05,12:56:10] Microsoft SQL Server 2005 Express
Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86
returned an unexpected value.
[10/31/05,12:56:13] VS70pgui: [2] DepCheck indicates Microsoft SQL Server
2005 Express Edition x86 is not installed.
[10/31/05,13:25:48] Microsoft SQL Server 2005 Express Edition x86: [2]
Component Microsoft SQL Server 2005 Express Edition x86 returned an
unexpected value.
***EndOfSession***

SEtup Log:

Michael Cheng [MSFT]

unread,

Nov 2, 2005, 6:19:52 AM11/2/05

to

Hi Shawn,

Thanks for your email.

I am looking into this issue and will keep you updated as soon as I found
anything valueable.

Thanks so much for your patience.

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================

Paul Hale

unread,

Nov 2, 2005, 8:35:09 AM11/2/05

to

Hi there,
I have the exact same problem here...
Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value

I uninstalled VS2005 beta 2 as per microsofts instructions I also removed
any leftover directories.
Setup fails for SQL Server 2005 Express Edition x86 every time.
Is there something that needs to be done when uninstalling previous versions
of VS?

Any help would be greatly appreciated.

Paul

Nick

unread,

Nov 2, 2005, 9:57:06 AM11/2/05

to

I too am getting the same error when installing VS

Shawn Kovalchick

unread,

Nov 2, 2005, 3:14:53 PM11/2/05

to

A solution was provided in another newsgroup. You need to run the SQL
Express standalone installer, select mixed mode authentication, and set
a password for SA. Otherwise, it won't install.

Michael Cheng [MSFT]

unread,

Nov 3, 2005, 1:18:43 AM11/3/05

to

Hi Shawn,

Thanks for your update and kindly experience sharing. It's great to hear
you have found the resolution. Hope this may also benefit others :)