Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How do I change from SQL Management Studio basic into complete? Expand / Collapse
Author
Message
Posted Sunday, December 22, 2013 10:10 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 8:14 PM
Points: 118, Visits: 264
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


  Post Attachments 
sql installer.png (16 views, 41.21 KB)
Post #1525404
Posted Monday, December 23, 2013 5:12 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, October 16, 2014 11:18 PM
Points: 1,248, Visits: 1,735
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.
Post #1525476
Posted Monday, December 23, 2013 3:49 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 8:14 PM
Points: 118, Visits: 264
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
Post #1525652
Posted Monday, December 23, 2013 4:29 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, October 16, 2014 11:18 PM
Points: 1,248, Visits: 1,735
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.

Post #1525656
Posted Monday, December 23, 2013 6:22 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 8:14 PM
Points: 118, Visits: 264
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


  Post Attachments 
sql installer.png (10 views, 41.21 KB)
Post #1525665
Posted Monday, December 23, 2013 6:39 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, October 16, 2014 11:18 PM
Points: 1,248, Visits: 1,735
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


Post #1525667
Posted Wednesday, January 1, 2014 7:45 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 8:14 PM
Points: 118, Visits: 264
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
Post #1526970
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse