How to find SQL management studio after installing SQL server 2008 express edition

[kothandaraman_nagarajan]

Dear Experts,

May be this thread not related to SAP B1.

How to find SQL management studio after installing SQL server 2008 express edition?

OR

how to download and match with installed SQL server?

Please help.

Thanks & Regards,

Nagarajan

[Former Member]

Dear Sir,

I am facing same problem,

not able to see management studio, i have installed SQL Server 2008 R2 Express Edition.

I gone throw above discussion.

I have downloaded sql server versions from above given links,

But still giving compatible error as below,

[kothandaraman_nagarajan]

Dear all,

Already marked with correct answer. So please do not reply.

[KennedyT21]

Hi Naga Rajan...

Does the Issue closed or Not if closed the close the thread with correct or helpful answers

Regards

Kennedy

[KennedyT21]

Hi NagaRajan...

If you have the original installer disc of your SQL Server, install it from there.

It is not installed by default. you need to install the tools.

The links posted above are for express edition which is a free edition, but have several limitation.

To learn more about the limitation see here.

One thing missing from the express edition that is quite usefull is the SQL profiler.

You required to install separately  SQL Server Management Studio.. You can download from the link..

http://www.microsoft.com/en-us/download/details.aspx?id=7593

http://www.filehippo.com/download_sql_server_studio/

Hope helpful

Regards

Kennedy

[kothandaraman_nagarajan]

Hi,

Thanks for reply.

Before that, i have installed three times SQL server in my machine and it creates 3 instance namely MSSQLServer, SQLexpress, SQLepxess2, SQLexpress3.

How to remove it? or is it affect dowloading of SQL management studio?How to located correct server for installing management studio?

How to find whether tools installed in my system?

Sorry for too many querstions.

Thanks,

Nagarajan

[KennedyT21]

Hi Naga Rajan...

To uninstall an instance of SQL Server on Windows Vista and Windows Server 2008 Operating Systems

1. To begin the uninstall process, from the Start menu, click Control Panel, and then double-click Program and Features.
2. Select the SQL Server component to uninstall, and then click Uninstall. This starts the SQL Server Installation Wizard.
3. Setup Support Rules runs to verify your computer configuration. To continue, click OK.
4. On the Select Instance page, use the drop-down box to specify an instance of SQL Server to remove, or specify the option to remove only the SQL Server shared features and management tools. To continue, click Next.
5. On the Select Features page, specify the features to remove from the specified instance of SQL Server. 
6. Removal rules runs to verify that the operation can complete successfully.
7. On the Ready to Uninstall page, review the list of components and features that will be uninstalled. 
8. The Setup Progress page displays Setup status.
9. On the Completing Setup page, click Close to exit the Installation Wizard.
10. Repeat steps 2-9 until all SQL Server 2012 components have been removed.

To Uninstall an instance of SQL Server on Windows 7 and Windows Server 2008 R2 Operating Systems

1. To begin the uninstall process, from the Start menu, click Control Panel, and then click Unistall a program under Programs.
2. Select the SQL Server component to uninstall, and then click Uninstall. Click Remove. This starts the SQL Server Installation Wizard.
3. Setup Support Rules runs to verify your computer configuration. To continue, click OK.
4. On the Select Instance page, use the drop-down box to specify an instance of SQL Server to remove, or specify the option to remove only the SQL Server shared features and management tools. To continue, click Next.
5. On the Select Features page, specify the features to remove from the specified instance of SQL Server. 
6. Removal rules runs to verify that the operation can complete successfully.
7. On the Ready to Uninstall page, review the list of components and features that will be uninstalled. 
8. The Setup Progress page displays Setup status.
9. On the Completing Setup page, click Close to exit the Installation Wizard.
10. Repeat steps 2-9 until all SQL Server 2012 components have been removed.

Check with the Link also

http://msdn.microsoft.com/en-us/library/ms143412.aspx

http://technet.microsoft.com/en-us/library/ms144242%28v=sql.90%29.aspx

http://www.youtube.com/watch?v=ugkP3Wt850c

Hope helpful

Regards

Kennedy

[kothandaraman_nagarajan]

Hi Kennedy,

Thanks for reply.

1. Is it same procedure for Windows 8?

2. Before removing, i  want to locate which SQL server running for SAP. How to locate?

[KennedyT21]

Best way is go for fresh installation of sql server...

Regards

Kennedy

[KennedyT21]

Yes same for win8

[kothandaraman_nagarajan]

Hi,

So i need to uninstall SAP and SQL server again?

My purpose is, to check and excute some stored procedure, that requires management studio.

Any other way ( without fresh installation) to get this?

Thanks Kennedy for all reply.

[KennedyT21]

just install management studio no issue with the multiple instance..

[kothandaraman_nagarajan]

Thanks Kenndy.

I will do it and come back to you by evening. I will follow below links to download :

http://www.microsoft.com/en-us/download/details.aspx?id=7593

http://www.filehippo.com/download_sql_server_studio/

Have a nice day.

[KennedyT21]

Hi Naga..

Does the Issue Solved or  Not

Regards

Kennedy

[KennedyT21]

Hey Naga Rajan..

Refer My first post i have provide you the same link but u marked your answer as correct answer.

read The Rules Of Engagement