how to instal MS SQL Server 2008 management studio in windows 8?

sql-server sql-server-2008 sql-server-2008-express
user1656381 picture user1656381 · Sep 8, 2012 · Viewed 35.4k times · Source

I am using 64bit Windows 8 rtm. Where can I get Sql server 2008 mgmt. studio for it?I tried installing sql server 2008 express sp1 and SQL Server 2008 R2 Express SP1, but it wont install.(ref: http://blogs.msdn.com/b/sqlexpress/archive/2012/03/02/sql-server-express-and-windows-8.aspx) Can you provide me a link from where I can download a working setup and give step by step installation instructions?

Answer

Ian P picture Ian P · Sep 8, 2012

Well for a start the OS requires the appropriate version of MS SQL to be installed. You may have difficulty in installing just the management studio because express is primarily designed to run on a stand alone machine. There is some configueration work to do to get ports open and protocols enabled. I suggest you install SQL 2008 R2 express with tools: http://www.microsoft.com/en-gb/download/details.aspx?id=26729

You want the WT (with tools versions)

however you may want to install sql 2012 express as this will connect to all earlier versions of MS SQL

Related questions

Visual studio 2010 and Sql Server

Do visual studio 2010 include already Sql Server instance, or I need to install Sql Server developer edition to develop an application that need a Sql Server db. If it installs a Sql Server express edition, it this enough or it's …

Read More
SQL Server Browser showing only hostname, not instance name

I just setup a new Windows Server 2008 machine with an instance of SQL Server 2008 Express. The SQL Browser service does not appear to be working correctly. In Management Studio, browsing for servers shows the hostname of the new server, but …

Read More
No Management Studio seen after SQL Server 2008 Express installation

I have recently successfully completed the installation of SQL Server 2008 Express. After installation when I tried accessing SQL Server Express I found there was no Management Studio installed. Is there an issue with express, that Management Studio is not installed …

Read More