is it possible to install sql managment studio on XP?

Question

is it possible to install sql managment studio on XP?

Viewing 9 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

TomThomson SSC Guru Points: 104768 More actions · Answer 1

You certainly can have SSMS with SQLS 2008 Express, but the way I did it was to install "SQL Server Express with Tools" rather than the server and the tools separately.

Tom

SQLRNNR SSC Guru Points: 281344 More actions · Answer 2

Are you getting an error during the install?

I have installed it several times separately, so I would expect some sort of error if it is not working for you.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 3

As much as I loved XP, XP is no longer supported. You really need to upgrade.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

dbe003-forum SSC Rookie Points: 37 More actions · Answer 4

hi guys,

many thanks for the replies.

ah ok - so i dont need to be installing server then?

as you can tell im rather new to all this sql lark 😀

..all im trying to do is get a db enviro along with the graphical view/management tool, so assumed that would mean a server install :/

i wasnt getting any errors at the end when trying to install the studio exe - it sent me back in to the same install screens, where it sounded like i need to be able to select the management tools basic option....but i just coudnt see that option available to me :/

yeah i was wondering whether i would need to buy win7 and upgrade the old laptop - but will try it on my win7 pc first just to make sure that sorts it

cheers

dan

...oh btw - someone has advised me to install oracle db for trying things out - but im guessing that is a fair bit different to Sql server enviro?

dbe003-forum SSC Rookie Points: 37 More actions · Answer 5

SQLRNNR (7/25/2015)
Are you getting an error during the install?
I have installed it several times separately, so I would expect some sort of error if it is not working for you.

ahh...found this one with tools 🙂 cool thanks - will give that a bash

http://www.microsoft.com/en-gb/download/details.aspx?id=22973

cheers

dbe003-forum SSC Rookie Points: 37 More actions · Answer 6

TomThomson (7/25/2015)
You certainly can have SSMS with SQLS 2008 Express, but the way I did it was to install "SQL Server Express with Tools" rather than the server and the tools separately.

awesome! thanks Tom - studio is now installed 🙂

cheers

dan

SQLRNNR SSC Guru Points: 281344 More actions · Answer 7

dbe003-forum (7/27/2015)
studio is now installed 🙂

Congrats

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Eirikur Eiriksson SSC Guru Points: 182951 More actions · Answer 8

Quick thought, hope you have either the appropriate firewall/security measures in place or that the machine is either not connected or unplugged from the internet, XP is indeed inherently vulnerable and should NOT be used.

😎

dbe003-forum SSC Rookie Points: 37 More actions · Answer 9

cheers guys ... im not too bothered about this machine as its just my play/install/old laptop - its got AV on it, but im not too bothered if it gets attacked

dan