SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How do I change from SQL Management Studio basic into complete?


How do I change from SQL Management Studio basic into complete?

Author
Message
WhiteLotus
WhiteLotus
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2932 Visits: 971
Hi All,

How do I change from SQL Management Studio basic into complete?
I use the standard edition of SQL Server 2008.

Please kindly help. Much aapreciated.

Rgds,
Mi
Attachments
sql installer.png (27 views, 41.00 KB)
Andrew G
Andrew G
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4205 Visits: 2285
You need to completely uninstall the express edition - you might need to go via control panel, change installed program and uninstall that way.
Reboot.
Install SSMS from the standard edition media.
WhiteLotus
WhiteLotus
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2932 Visits: 971
Thank you for your response,appreciate it. But I upgrade in the production server so I am afraid if I remove the SQL server and when I install it , I couldnt get my databases back.I am using SQL Standard not Express Edition.
How is that ?

Thanks
Andrew G
Andrew G
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4205 Visits: 2285
Are you upgrading the SQL database engine/instance or just SQL Management Studio (the client tools)?

If you are upgrading the instance, you can perform an edition upgrade via the install media and selecting "Maintenance", "Edition Upgrade". You need to upgrade the database engine before upgrading the client tools.
http://sqlblog.com/blogs/tibor_karaszi/archive/2011/01/27/upgrading-from-express-edition-to-standard-edition.aspx

Make sure you have a full backup of your databases before attempting any upgrade, including the master database. If needed, you can completely rebuild the instance.
WhiteLotus
WhiteLotus
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2932 Visits: 971
I am upgrading the Management studio ( client tool ) only and I dont want to upgrade the server edition.
The problem is when I want to change from management studio basic to complete there is no option for choosing the complete one (as attached). I am confused ...( Previously I didnt uninstall it but I did the repair straight away using the Standard Edition )
Any advice about it ?


Much appreciated.

Regards,
MI
Attachments
sql installer.png (18 views, 41.00 KB)
Andrew G
Andrew G
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4205 Visits: 2285
In the screenshot you have attached, it says the edition you are trying to install is "Express with Advanced Services".
Express editions only include the "Basic" management tools.

Are you running the install from the SQL Standard edition media?

Can you answer the following:
- What edition and version of SQL is installed
- What edition and version do you want installed
- What final outcome are you trying to achieve
WhiteLotus
WhiteLotus
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2932 Visits: 971
Hi Andrew,

Happy New Year and thanks for your response. I have just checked my email and got your reply. Thank you so much.

1. At the moment I am using SQL Standard Edition with SQL Management Studio "Basic"
2. I want to upgrade it into SQL Standard Edition with SQL Management Studio "Complete"
3. I am trying to modify the maintenance plan for Backup because it is failed . I reckon if I upgrade the SQL Management studio , I am able to modify it.

Any advice please ?

Thank you so much

Rgds,
MI
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search