October 2, 2008 at 11:48 am
Hi Guys,
I have a server/database running with SSMS Express 2005, and I want to upgrade to Enterprise Edition 2005, since I run out of its database full size (4GB).....it is running with WIN Server 2003.
Please I need some guide before performing this task. How can I do that to avoid making a mess with the database already there?
Thank you.
October 2, 2008 at 11:52 am
http://msdn.microsoft.com/en-us/library/ms143393.aspx
In this article it states:
Upgrade from
SQL Server 2005 Enterprise Evaluation (32-bit, IA64, X64)
Supported Upgrade Paths
No upgrade support.
What's the harm in ripping down the instance and simply starting fresh? Doesn't take all that long. Also, are you sure you need Enterprise? You're coming from Express which is much more limited than Standard ... Enterprise costs quite a bit more than Standard. You may want to review the features of each before jumping on Enterprise.
Good luck.
October 2, 2008 at 12:26 pm
Ok....if I go to Standard, can I just run the CD with the setup?
October 2, 2008 at 1:05 pm
Junior_DBA (10/2/2008)
Ok....if I go to Standard, can I just run the CD with the setup?
Yes, but I don't believe you'll be able to upgrade your existing Express edition. As far as I know, you can't take an upgrade path off of Express. But you can backup/restore your databases and move logins.
October 2, 2008 at 3:19 pm
I am in troubles....please I need help, I upgrade my database, but my engine remain in the previous version..please??? some little help.
Thank you.
October 2, 2008 at 3:42 pm
Guys, please I really need some help...I did something stupid....and now I don't know what to do...
I run SQL server standard ...and it looks like everything upgrade but the database engine no....it just remain under express edition, and now I don't know what to do to upgrade that also...
please help me....
thank you.
October 2, 2008 at 5:29 pm
there is no upgrade path for express. detach the databases and re attach them under sql2005 standard, also script off the logins and apply those too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 2, 2008 at 6:10 pm
Junior_DBA (10/2/2008)
I am in troubles....please I need help, I upgrade my database, but my engine remain in the previous version..please??? some little help.Thank you.
What? As I've stated above, there is no upgrade for Express. I'm assuming you installed Standard, but simply under a different instance. Usually Express defaults to \SQLExpress I believe; therefore I'd assume that your new install is simply the default instance.
As stated earlier, you'll need to move your databases and logins off the Express instance to your new instance. You'll also need to correct your database user SID's.
October 3, 2008 at 7:34 am
Guys,
I don't know what to do, I did it, but the SSMS remind under SSMS Express, so I uninstall enverything and tried to install all from "0" , but I got and error, now I cannot see anything under Add or Remove programs, also, I cannot see my SSMS...nothing, please...what should I do??.... I need help...
thank you.
October 3, 2008 at 8:02 am
Junior_DBA (10/3/2008)
Guys,I don't know what to do, I did it, but the SSMS remind under SSMS Express, so I uninstall enverything and tried to install all from "0" , but I got and error, now I cannot see anything under Add or Remove programs, also, I cannot see my SSMS...nothing, please...what should I do??.... I need help...
thank you.
You can't upgrade ...... check your services, you should have two instances now installed.
October 3, 2008 at 8:08 am
Yes Adam,
But I don't have my SSMS ..what can I do???, also I tried to install again the express version, oh please help me..I really mmade a mess of this....please??? what can I do, I am getting very nervous..
October 3, 2008 at 8:11 am
Junior_DBA (10/3/2008)
Yes Adam,But I don't have my SSMS ..what can I do???, also I tried to install again the express version, oh please help me..I really mmade a mess of this....please??? what can I do, I am getting very nervous..
You installed the standard edition right? Did you not install the workstation components? You should have SSMS installed ... type sqlwb from a run line.
If not, rerun the install and just install the workstation components.
Also, if you check services (services.msc from a run line) go down to SQL Server, do you have SQL Server(MSSQLSERVER) and SQL Server (SQL Express)?
October 3, 2008 at 8:59 am
Adam,
I installed SQL Standard...because I cannot see that my SSMS Express change names to SSMS (no more express), I reinstall Express again, the I got the error that I already have one instance on that.
Yes I can see on my services.msc both SQL (standard) , and SQL (express)..but I cannot see my sqlwb, when i run it on my command prompt it says that is not recognized.
October 3, 2008 at 9:02 am
Adam,
I forgot to tell you, then because of that I decided to remove everything to start from the beginning, so I remove everything from add/remove programs, but the files still on the folder SQL Server on my c:\drive....and now I don't know what to do.
October 3, 2008 at 9:08 am
Junior_DBA (10/3/2008)
Adam,I installed SQL Standard...because I cannot see that my SSMS Express change names to SSMS (no more express), I reinstall Express again, the I got the error that I already have one instance on that.
Yes I can see on my services.msc both SQL (standard) , and SQL (express)..but I cannot see my sqlwb, when i run it on my command prompt it says that is not recognized.
This is the default location for the SSMS executable, do you have this?
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"
Unless you changed the install options, SSMS installs by default (under workstation components) on the install. Launch the install again ... when you're at components to install, check "workstation components" and then go to advanced. Then go to client Components ... this should already be enabled, and check to see that management tools is enabled underneath it.
Viewing 15 posts - 1 through 15 (of 29 total)
You must be logged in to reply to this topic. Login to reply