Tuesday, February 14, 2012
Cant install MSDE Rel A
matter what I try. I am typing the following at the command line.
setup.exe /L*v C:\MSDElog.txt SAPWD="password" SECURITYMODE=SQL
Below are the portions of the error log that contain RETURN VALUE 3,
including sevral lines before and after. Any help would be appreciated.
Error the following data files were found in data directory:
C:\Program Files\Microsoft SQL Server\MSSQL\Data\msdbdata.mdf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\msdblog.ldf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\mastlog.ldf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\model.mdf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\modellog.ldf
Setup has detected existing data/log files. Please make sure to delete/move
the files before re-running setup
Ending custom action DetectExistingData
Action ended 13:58:34:
DetectExistingData.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B. Return value 3.
Action ended 13:58:34: INSTALL. Return value 3.
Property(S): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
Property(S): SqlDataDir = C:\Program Files\Microsoft SQL Server\
Property(S): SqlProgramDir = C:\Program Files\Microsoft SQL Server\
Property(S): SqlInstanceName = MSSQLSERVER
Property(S): SqlSecurityMode = SQL
Property(S): SqlSa...
Property(S): SqlDisableNetworkProtocols = 1
Property(S): VersionNT = 501
Property(S): ALLUSERS = 1
Property(S): ARPNOMODIFY = 1
Property(S): DefaultUIFont = Tahoma8
Property(S): INSTALLLEVEL = 3
Property(S): LIMITUI = 1
Property(S): Manufacturer = Microsoft Corporation
Property(S): ProductCode = {E09B48B5-E141-427A-AB0C-D3605127224A}
Property(S): ProductLanguage = 1033
Property(S): SqlStates = 0
Property(S): ROOTDRIVE = C:\
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): SqlFeature = SqlRun
MSI (s) (80:D8) [13:58:34:748]: MainEngineThread is returning 1603
MSI (s) (80:A4) [13:58:34:748]: Destroying RemoteAPI object.
MSI (s) (80:60) [13:58:34:748]: Custom Action Manager thread ending.
MSI (c) (3C:E4) [13:58:34:748]: Back from server. Return value: 1603
MSI (c) (3C:E4) [13:58:34:748]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
Action ended 13:58:34: INSTALL. Return value 3.
Property(C): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
Property(C): VersionNT = 501
Property(C): ALLUSERS = 1
Property(C): ARPNOMODIFY = 1
Property(C): DefaultUIFont = Tahoma8
Property(C): INSTALLLEVEL = 3
Property(C): LIMITUI = 1
Property(C): Manufacturer = Microsoft Corporation
Property(C): ProductCode = {E09B48B5-E141-427A-AB0C-D3605127224A}
Property(C): ProductLanguage = 1033
Property(C): ProductName = Microsoft SQL Server Desktop Engine
Property(C): ProductVersion = 8.00.761
Property(C): MsiHiddenProperties = SqlSa...
Property(S): SqlStates = 0
Property(S): ROOTDRIVE = C:\
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): SqlFeature = SqlRun
MSI (s) (80:D8) [13:58:34:748]: MainEngineThread is returning 1603
MSI (s) (80:A4) [13:58:34:748]: Destroying RemoteAPI object.
MSI (s) (80:60) [13:58:34:748]: Custom Action Manager thread ending.
MSI (c) (3C:E4) [13:58:34:748]: Back from server. Return value: 1603
MSI (c) (3C:E4) [13:58:34:748]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
Action ended 13:58:34: INSTALL. Return value 3.
Property(C): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
Property(C): VersionNT = 501
Property(C): ALLUSERS = 1
Property(C): ARPNOMODIFY = 1
Property(C): DefaultUIFont = Tahoma8
Property(C): INSTALLLEVEL = 3
Property(C): LIMITUI = 1
Property(C): Manufacturer = Microsoft Corporation
Property(C): ProductCode = {E09B48B5-E141-427A-AB0C-D3605127224A}
Property(C): ProductLanguage = 1033
looks like the setup is detecting data from a a previous install of SQL.
"C:\Program Files\Microsoft SQL Server\MSSQL\Data\msdbdata.mdf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\msdblog.ldf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\mastlog.ldf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\model.mdf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\modellog.ldf
"
You can simply delete these assuming they are not needed any more.
Andrew Robinson
www.binaryocean.com
www.bellinghamdotnet.org
"MEI Admin" <MEI Admin@.discussions.microsoft.com> wrote in message
news:325180D7-9B24-4941-B5A7-B4E7351DD83D@.microsoft.com...
>I am trying to install MSDE Rel A on a Windows XP SP2 machine with no luck
>no
> matter what I try. I am typing the following at the command line.
> setup.exe /L*v C:\MSDElog.txt SAPWD="password" SECURITYMODE=SQL
> Below are the portions of the error log that contain RETURN VALUE 3,
> including sevral lines before and after. Any help would be appreciated.
> Error the following data files were found in data directory:
> C:\Program Files\Microsoft SQL Server\MSSQL\Data\msdbdata.mdf
> C:\Program Files\Microsoft SQL Server\MSSQL\Data\msdblog.ldf
> C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf
> C:\Program Files\Microsoft SQL Server\MSSQL\Data\mastlog.ldf
> C:\Program Files\Microsoft SQL Server\MSSQL\Data\model.mdf
> C:\Program Files\Microsoft SQL Server\MSSQL\Data\modellog.ldf
> Setup has detected existing data/log files. Please make sure to
> delete/move
> the files before re-running setup
> Ending custom action DetectExistingData
> Action ended 13:58:34:
> DetectExistingData.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B. Return value 3.
> Action ended 13:58:34: INSTALL. Return value 3.
> Property(S): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
> Property(S): SqlDataDir = C:\Program Files\Microsoft SQL Server\
> Property(S): SqlProgramDir = C:\Program Files\Microsoft SQL Server\
> Property(S): SqlInstanceName = MSSQLSERVER
> Property(S): SqlSecurityMode = SQL
> Property(S): SqlSa...
> Property(S): SqlDisableNetworkProtocols = 1
> Property(S): VersionNT = 501
> Property(S): ALLUSERS = 1
> Property(S): ARPNOMODIFY = 1
> Property(S): DefaultUIFont = Tahoma8
> Property(S): INSTALLLEVEL = 3
> Property(S): LIMITUI = 1
> Property(S): Manufacturer = Microsoft Corporation
> Property(S): ProductCode = {E09B48B5-E141-427A-AB0C-D3605127224A}
> Property(S): ProductLanguage = 1033
>
> Property(S): SqlStates = 0
> Property(S): ROOTDRIVE = C:\
> Property(S): CostingComplete = 1
> Property(S): OutOfDiskSpace = 0
> Property(S): OutOfNoRbDiskSpace = 0
> Property(S): PrimaryVolumeSpaceAvailable = 0
> Property(S): PrimaryVolumeSpaceRequired = 0
> Property(S): PrimaryVolumeSpaceRemaining = 0
> Property(S): SqlFeature = SqlRun
> MSI (s) (80:D8) [13:58:34:748]: MainEngineThread is returning 1603
> MSI (s) (80:A4) [13:58:34:748]: Destroying RemoteAPI object.
> MSI (s) (80:60) [13:58:34:748]: Custom Action Manager thread ending.
> MSI (c) (3C:E4) [13:58:34:748]: Back from server. Return value: 1603
> MSI (c) (3C:E4) [13:58:34:748]: Decrementing counter to disable shutdown.
> If
> counter >= 0, shutdown will be denied. Counter after decrement: -1
> Action ended 13:58:34: INSTALL. Return value 3.
> Property(C): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
> Property(C): VersionNT = 501
> Property(C): ALLUSERS = 1
> Property(C): ARPNOMODIFY = 1
> Property(C): DefaultUIFont = Tahoma8
> Property(C): INSTALLLEVEL = 3
> Property(C): LIMITUI = 1
> Property(C): Manufacturer = Microsoft Corporation
> Property(C): ProductCode = {E09B48B5-E141-427A-AB0C-D3605127224A}
> Property(C): ProductLanguage = 1033
> Property(C): ProductName = Microsoft SQL Server Desktop Engine
> Property(C): ProductVersion = 8.00.761
> Property(C): MsiHiddenProperties = SqlSa...
>
> Property(S): SqlStates = 0
> Property(S): ROOTDRIVE = C:\
> Property(S): CostingComplete = 1
> Property(S): OutOfDiskSpace = 0
> Property(S): OutOfNoRbDiskSpace = 0
> Property(S): PrimaryVolumeSpaceAvailable = 0
> Property(S): PrimaryVolumeSpaceRequired = 0
> Property(S): PrimaryVolumeSpaceRemaining = 0
> Property(S): SqlFeature = SqlRun
> MSI (s) (80:D8) [13:58:34:748]: MainEngineThread is returning 1603
> MSI (s) (80:A4) [13:58:34:748]: Destroying RemoteAPI object.
> MSI (s) (80:60) [13:58:34:748]: Custom Action Manager thread ending.
> MSI (c) (3C:E4) [13:58:34:748]: Back from server. Return value: 1603
> MSI (c) (3C:E4) [13:58:34:748]: Decrementing counter to disable shutdown.
> If
> counter >= 0, shutdown will be denied. Counter after decrement: -1
> Action ended 13:58:34: INSTALL. Return value 3.
> Property(C): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
> Property(C): VersionNT = 501
> Property(C): ALLUSERS = 1
> Property(C): ARPNOMODIFY = 1
> Property(C): DefaultUIFont = Tahoma8
> Property(C): INSTALLLEVEL = 3
> Property(C): LIMITUI = 1
> Property(C): Manufacturer = Microsoft Corporation
> Property(C): ProductCode = {E09B48B5-E141-427A-AB0C-D3605127224A}
> Property(C): ProductLanguage = 1033
Friday, February 10, 2012
Can't get SS Express SP2 to install on Vista build 5744
Having had no luck getting prior versions of Sql Server Express to install on Vista RC2. I was hoping that SP2 would install with no problems however I'm still getting the same error as before and can't find any working solution to this anywhere on the web.
The actual error I'm getting occurs when the install tries to start the SQL Server service and connect. I get
TITLE: Microsoft SQL Server 2005 Setup
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe.
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.
This error apparently also occurs on other platforms than Vista. Any ideas how to get past this? The Vista install is still pretty much a clean install.
TIA Adrian Heath
Hi Adrian,
The most obvious question is, "did you check the setup logs?" as per the instructions in the message? The setup logs will help track down the root cause of the error. I've installed SSE on many different builds of Vista without problems, so I know it's possible.
Mike
|||I did but the final entry basically says the same as the displayed error and it was hard to figure out if any other part of the preceeding 5Mb of log was relevant. The complete log entry is as follows. If you have any suggestions what else to look for in the log please let me know.
TIA Adrian Heath
Error Code: 233
MSI (s) (C0!C4) [22:58:58:097]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe.
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.
Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe.
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.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Fri Nov 17 22:58:58 2006
Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Fri Nov 17 22:58:58 2006
Attempt to start service when it is already running
SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connections
Service MSSQL$SQLEXPRESS started at Fri Nov 17 22:58:58 2006
SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=08001, level=-1, state=-1, native_error=233, msg=[Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe.
sqlstate=08001, level=-1, state=-1, native_error=233, msg=[Microsoft][SQL Native Client]Client unable to establish connection
Error Code: 0x800700e9 (233)
Windows Error Text: No process is on the other end of the pipe.
Source File Name: lib\odbc_connection.cpp
Compiler Timestamp: Wed Aug 2 16:21:01 2006
Function Name: OdbcConnection::connect@.connect
Source Line Number: 148
- Context --
Connecting to SQL Server
ExecuteSqlCommands
Originial error was 800700e9 (233)
Do_sqlScript
SqlScriptHlpr
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=197758&SiteID=1
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||
Thanks
SS Express is now installed
I followed the instructions for removing certificates from here
http://support.microsoft.com/default.aspx/kb/309398/
(mentioned near the bottom of the link suggested above) and the install completed. I'm not sure what the two certificates were from, I guess they are Vista default certificates but if so why have more people not reported this problem?
Oh well it's working now
Thanks again for the help
Adrian Heath