October 3, 2008 at 9:29 am
Adam,
It was not there, I am running again the setup..but it failed when installing the client, it says that cannot find the correct sqlcli.exe for this component...
I don't know....
October 3, 2008 at 9:32 am
Not sure what to tell you then ... Not knowing exactly everything that has happened, my recommendation would be to start over. When you uninstall both installs, the .mdf and .ldf for your user database(s) will remain on the file system ... therefore you can reattach them later. Is there anything critical in the system databases that you can't recreate?
October 3, 2008 at 10:14 am
Adam, I appreciate a lot your help....I will try to explain what I am doing.....
I am running again the setup for Standard.
When I got over the part that is asking me for the database , "a default one".....that was created with the previous standard installation.......... or a "named one", that I tried to use with the express db , they both cases failed, so I run again the setup and I chose "named" and i enter a new name, it start running better with that new db name, but it stopped when it found that a sysdatabase already exist in the folder the setup is installing on, so it gave me an error saying that there is another sysdatabase and that I have to move it, so i tried but it failed because is in use...ok I stop and disable all the services on services.msc......and then rename them on a new folder...and left that forlder clean....
Then I run again the setup and since I rename those databases I run the setup with "default" but it said that I already have a default database, so I gave a new name again running it under "named", now with the folder clean because I renamed the sysdatabases and moved it over other folder, I thought that it will be able to create a new installation with a new database name ........however it gave me the following error: ...
SQL Server Setup failed to modify security permission on WMI namespace \\.\root\microsoft\sqlserver\serverevents\ . to proceed verify that the account and domain running SQL Server setup exist, and and the WMI exist on the destination drive...
What is the problem now?? please???
October 3, 2008 at 10:20 am
Adam,
I click on ignore that error, and it continues installing..... but it failed.....I don't know hwat to do...is failing ...
October 3, 2008 at 10:22 am
Can I run everything from the beginning , but delete all the folders, all the files...and everything....like nothing in muy computer with SQL server???
WOuld you mind telling me how please?
October 3, 2008 at 10:56 am
Junior_DBA (10/3/2008)
I am running again the setup for Standard.When I got over the part that is asking me for the database , "a default one".....that was created with the previous standard installation.......... or a "named one", that I tried to use with the express db , they both cases failed, so I run again the setup and I chose "named" and i enter a new name, it start running better with that new db name, but it stopped when it found that a sysdatabase already exist in the folder the setup is installing on, so it gave me an error saying that there is another sysdatabase and that I have to move it, so i tried but it failed because is in use...ok I stop and disable all the services on services.msc......and then rename them on a new folder...and left that forlder clean....
Then I run again the setup and since I rename those databases I run the setup with "default" but it said that I already have a default database, so I gave a new name again running it under "named", now with the folder clean because I renamed the sysdatabases and moved it over other folder, I thought that it will be able to create a new installation with a new database name ........however it gave me the following error: ...
This is the "instance" that the server is installed to. You can run multiple instances with in a server. This allows for logical and physical separation on multiple levels. By default, SQL Express installs to \SQLEXPRESS and any other edition (standard, developer, enterprise) will default to nothing, which means it responds to just the local server name. In the services you'll see it labeled as (MSSQLSERVER), which is nothing more than the "default" instance.
As for your problem about the database already existing ... I'd like to see the actual error. When you uninstall, it is supposed to remove the system databases.
I really don't know how you managed all this! 🙂 Again, my recommendation would be to start fresh. Uninstall ALL SQL Server 2005 components from the add/remove programs (appwiz.cpl from a run line). Remove the "Microsoft SQL Server" directory under Program Files -- **** AFTER moving your user database files ****, restart the box, and start with a fresh install.
October 3, 2008 at 10:57 am
Junior_DBA (10/3/2008)
Can I run everything from the beginning , but delete all the folders, all the files...and everything....like nothing in muy computer with SQL server???WOuld you mind telling me how please?
Yeah, as you saw in my previous post, at this point that is what I'd recommend. Completely uninstall all SQL Server 2005 components, remove the root folder, restart, start over.
October 3, 2008 at 11:02 am
Adam,
would you mind giving me some idea in regedit where can I found the sql server files, so I can delete them...please?...because i run from add/remove programs, i run the folders.. on my c:\drive but on regedit still
October 3, 2008 at 11:50 am
Adam,
I am deleting all, but in the meanwhile I restore one of my backups on other server with Standard, and it open but going by SSMS in file/status says shutdown, manual...what that means, how can i change it???...is because if this happend in the original server how can i change status???
October 3, 2008 at 2:00 pm
Adam,
It worked, thank you for your time....
I reinstalled from scratch, and now it looks is working ok....but I have a doubt........in the future, to not do the same disaster....how can I do to upgrade my express 2005 version to standard in 2005...in a better/clear way???
October 3, 2008 at 4:35 pm
Junior_DBA (10/3/2008)
Adam,It worked, thank you for your time....
I reinstalled from scratch, and now it looks is working ok....but I have a doubt........in the future, to not do the same disaster....how can I do to upgrade my express 2005 version to standard in 2005...in a better/clear way???
You're killing me Junior ... re-read above ... you can NOT upgrade from Express.
October 7, 2008 at 9:39 am
Thank you Adam,
I install Standard, and then I restore the database on it... and now it is working.
Thank you ...and my apologies if I was getting you crazy.
October 7, 2008 at 10:20 am
No problem, glad it worked out for you.
October 8, 2008 at 7:05 am
Junior_DBA, you asked,
...in the future, to not do the same disaster...how can I do to upgrade my express 2005 version to standard in 2005...in a better/clear way???
Upgrading from SQL Express is supported. (http://msdn.microsoft.com/en-us/library/ms143393(SQL.90).aspx"> http://msdn.microsoft.com/en-us/library/ms143393(SQL.90).aspx ) As I have done, you should be able to insert the Standard or Enterprise CD and follow the prompts to upgrade. To upgrade from the command line, you’ll need to be sure to include the “SKUUPGRADE=1” flag (see http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=852573&SiteID=1).
Regarding the Management Studio, the free one from Express is slightly different. You would need to uninstall it and then install the standard one if you want that upgrade. Maybe someone can chime in if there is a simpler way.
Adam, if I ever run into trouble, I could only hope that I would have someone to stick with me through it all as you have for Junior_DBA. You make SQLServerCentral proud.
Danny
October 8, 2008 at 7:17 am
Oh my ... I was looking at the wrong page. I was looking at upgrade paths for 2008! By not seeing any supported upgrade paths for 2005, I was assuming that there was no upgrade path. Many apologies Junior, I believe I led you astray.
Thanks for the information dcorbitt, this is good to know. Unfortunately I don't really have any experience with Express and found this information simply by searching, shame that you didn't see this post earlier.
Viewing 15 posts - 16 through 29 (of 29 total)
You must be logged in to reply to this topic. Login to reply