VS 2010 SQL Express unable to install on 7 home premium

Quote:

Originally Posted by hwtsai

sorry this my very first thread, also very first time to get to know VS2010. I hv installed VS2010 Ultimate on my Samsung notebook win 7 home premium 64 bit. But one thing was wrong, i couldn't get sql express installed, with some error that i forgot. I can't see SQL Express menu on my menu list though unable to launch it.

after searching the net, it says that i might need Windows Installer 5 (SDK) which is 2,5 GB to download. Is it true that I need that SDK to install sql express properly? or it is not possible to have sql express on home premium 64bit?

any clue would be highly appreciated, thx.

here are some error message:
2012/01/22 22:49:06.01 SQLDIAG

It appears that output folder C:\Program Files\Microsoft SQL Server\100\Tools\Bi
nn\SQLDIAG\ has been used before. Overwrite the files it contains (Y/N)? y
2012/01/22 22:49:13.47 SQLDIAG Collector version
2012/01/22 22:49:13.47 SQLDIAG

IMPORTANT: Please wait until you see "Collection started" before attempting to
reproduce your issue

2012/01/22 22:49:13.48 SQLDIAG Output path: C:\Program Files\Microsoft SQL Serve
r\100\Tools\Binn\SQLDIAG\
2012/01/22 22:49:13.58 SQLDIAG Collecting from 1 logical machine(s)
2012/01/22 22:49:13.59 HWT\* SQL Server version: 10
2012/01/22 22:49:13.59 HWT\* Machine name: HWT (this machine)
2012/01/22 22:49:13.59 HWT\* Target machine is not a cluster
2012/01/22 22:49:13.59 HWT\* Instance: SQLEXPRESS (64-bit)

2012/01/22 22:49:13.91 HWT\* WARNING: User HWT cannot log in to HWT\SQLEXPRESS (
64-bit). Diagnostics for HWT\SQLEXPRESS (64-bit) will not be collected. To add
ress this, ensure you can connect to HWT\SQLEXPRESS (64-bit) and restart the col
lection process

2012/01/22 22:49:13.92 HWT\* No valid instances from which to collect data
2012/01/22 22:49:14.58 SQLDIAG Initialization starting...
2012/01/22 22:49:15.01 HWT\* MsInfo: Get MSINFO32
2012/01/22 22:49:15.20 HWT\* MsInfo: Get default traces
2012/01/22 22:49:15.21 HWT\* MsInfo: Get SQLDumper log
2012/01/22 22:49:15.59 SQLDIAG Initialization complete
2012/01/22 22:49:15.59 HWT\* Collecting diagnostic data

2012/01/22 22:49:16.59 SQLDIAG Collection started. Press Ctrl+C to stop.