Pai...m-am dus la pagina Microsoft sa downloadez SQL Service 2005 Express, care este gratuit. Inainte de asta am downloadat si instalat cu mare succes .Net.Framework 2.0 x86. Am downloadat ceea ce se numeste la mine in folder SQLEXPR_ADV si de ieri ma lupt cu errors de instalare: fixeaza aia, reinstall ailalta, am tot umblat prin locuri prin care un om de alta meserie ca mine n-are ce cauta, cum ar fi Run din meniul Start. Am fost atenta, nu am stricat nimic. Cam 10 ore m-am chinuit ieri cu asta.

La urma, mi-a declarat ca s-a instalat. Da' de unde: cand sa-i dau drumul, mi-a aparut celebra eroare "Your SQL Server installation is either corrupt or has been tampered with (Error getting instance ID from name.). Please uninstall then re-run setup to correct this problem". Fireste, am facut asta. Nu ajuta. Am cautat pe net, pana am dat de un blog unde explica, din cate am inteles, ca modul express de instalare are metehne, in sensul ca la urma isi sterge (isi muta) niste fisiere si nu le mai gaseste cand sa le foloseasca.

Solutia pare a fi prezenta aici: http://blogs.msdn.com/sqlserverstorageengine/archive/2006/09/26/772550.aspx . Aici scrie ca:

"The reason that this complicated matters is that Express is normally installed by downloading the compressed installer, which expands itself, runs the installation, and then cleans up the install files.  Unfortunately, with the command above, MSI is going to look for the .MSI files in the location that SQL was installed from, which no longer exists, since it was cleaned up...

So, there are a couple of extra steps:  First is to download the Express kit, and extract the contents to a local directory.  This is done by saving the SQLEXPRESS.EXE file and NOT running it from the download prompt.  Instead, after the download completes, manually run the program with the -x switch. i.e. D:\Expressdir\SQLEXPRESS.EXE -x

This results in the setup files being extracted, but no other steps are taken.  Now we need to instruct MSI to use these files and not the remembered location when rebuilding the databases.  This is done by adding the REINSTALLMODE=vomus option to the command:

start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=SQLExpress REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword> REINSTALLMODE=vomus

And it's just that easy!"

Pentru ca nu sunt profesionist, chiar nu am reusit sa deschid kitul meu de instalare, SQLEXPR_ADV, pe care l-am luat de pe site de la Microsoft, fara sa-l "Run" din fereastra lui gri. Am incercat sa il "run" din meniul Start, dar zice ca nu am in computer SQLEXPRESS.EXE...pai n-am, ca de unde?

SQLEXPR_ADV incepe "Run" prin a despacheta un folder cu multe litere si cifre in nume la mine pe disk. Am incercat sa-i fac de toate: sa-l copiez (nu, ca e in use, iar daca intrerup instalarea dispare si folderul despachetat), sa-l deschid si sa ma duc sa caut SQLEXPRESS.EXE aia, ori MSI alea...in fine, ma doare mintea...Si nici nu mi-e clar de ce sa dau o comanda care incepe cu "start/wait <CD or DVD drive...", daca eu l-am downloadat de pe net si nu de pe CD sau DVD...

In concluzie, pe net eu una n-am mai gasit nimic, asa ca m-am impotmolit. Am Windows XP si cu SP2. Ce sa-i mai fac? Foloseste careva versiunea asta? Cum a instalat-o? Ce a facut la Error getting instance ID from name? Tare v-as fi recunoscatoare pentru ajutor rapid...