[?+]: Wincc 7.0 SP2 installation SQL error on W7 Ultimate

[tactic_23]

Dear All

i have before a wincc 7 in my laptop, running windows 7 ultimate 32bit.
it was running smooth.
then later i decide to uninstall and reinstall wincc 7.0.2 .. when during the installation of SQL 2005, it mentions "sql failed in to start"

mention in the log files

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

Setting status of unmanaged components and removing unmanaged resources
Do_sqlScript
SqlScriptHlpr
Start service MSSQL$WINCC



Error Code: 1067
MSI (s) (C8!FC) [11:25:56:855]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.
.

Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.
.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Sun Sep 18 11:25:56 2011
Service MSSQL$WINCC with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Sun Sep 18 11:25:56 2011

please help me.


regards

[Bolle01]

Is on your Windows 7 Ultimate SP1 installed? WinCC 7.0 SP2 will not work with Windows 7 SP1.
If you want to run WINCC 7 on Windows 7 with SP1 you need WINCC SP3

[tactic_23]

thanks for the info

i already download wincc 7.0 SP3

but still the same problem. MSI error code 43 during SQl intallation

hope someone can help further

[Rex2701]

Read the solution SQL Express Install fails Error 29503 / 1067.

A helpful tech at Microsoft Connect solved the problem.
I am posting a copy of the solution here. See the Microsoft Connect Forum for SQL Express for more details.
Note that my machine is part of a workgroup and does not belong to a domain.
I tried to install SQL Express using the "Advanced Options," as was suggested in some other posts, but this was still inadequate to solve my problem.
A RegEdit was required...

Most likely the "Domain" is missing from the following Windows registry HKEY_LOOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters

I assume you rmachine is not joined to a domain.
If that's the case, you can try creating an empty REG_SZ value named "Domain" in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters of your registry.

You can follow these steps:
(1) Open regedit (Start|Run, type regedit).
(2) Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters.
(3) Right-click parameters.
(4) >Choose New->String value.
(5) Type Domain as the name of the new value, and hit Enter.
(6) Rerun your SQL Server >Setup. Please, let us know if this helped.

*Warning* Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another >method.
These problems might require that you reinstall your operating system.
Microsoft cannot guarantee that these problems can be solved.
Modify the registry at your own risk.

[tactic_23]

thanks for the help

i follow the instruction to add a domain, but in my registry key already have a domain entry..

[DiVan]

the only way - to reinstall Windows from backup disk.

[tactic_23]

thanks for the help

i already reformat and reinstall win 7 in my laptop

and everything is oky now.

thanks to all

[Janosch07]

Hi,
I had the same problem but may be my solution also works with you

If the number of CPUs (Cores) in your computer is not x^2 then SQL 2005 will not start properly.
Make sure you have enabled 2 OR 4 OR 8 OR 16 cores in your computer first.
If you have AMD 3 core, that will not work.
If you have Xeon 6 core then reduce it in the BIOS to 4 core.

[Moofcba]

I'm late but may be i can help.

I only get this error if i have installed, or running "terminal server " or "remote desktop"


i think wincc is not compatbile with terminal services and remote desktop.