sql server management studio

Question

Hi all

  I downloaded visual studio 2010 ultimate.But i do not have sql server or management studio to work with. Which one shall i dowload for visual studio sp1. and where can i get it?

Any help greatly appreciated.

thanks

Answer 1

If you are using an MSDN license (which I presume you are in order to have Visual Studio) then I would recommend getting SQL Server 2012 Developer Edition using your MSDN.  It has full features of SQL Server and the install will also give you Management Studio.  It will also work with Visual Studio SP1.

You could also get SQL Server 2008 R2 if you wanted...  it would work just as well...  but I'd always go for the newest thing.

If you don't have MSDN (which would make me concerned as to how you have Visual Studio Ultimate) then you need to download SQL Server 2012 Express with Management Studio.  This can be easily found with a Bing or Google search.

Answer 2

In addition to Kevin notes, you can install SSDT for VS2010. Please see this link:

Microsoft SQL Server Data Tools

---

sqldevelop.wordpress.com

Answer 3

Hi all

  I downloaded visual studio 2010 ultimate.But i do not have sql server or management studio to work with. Which one shall i dowload for visual studio sp1. and where can i get it?

thanks

One option is to you can download SSMS from here

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

Other option for getting SSMS is to install SQL server 2008 R2 express edition it is free and gives you SSMS feature

http://www.microsoft.com/en-in/download/details.aspx?id=30438

---

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

Answer 4

I did as you mentioned in option 1. when i run it says " not a win32 application".

Answer 5

I did as you mentioned in option 1. when i run it says " not a win32 application".

Hello ,

can you check below link and see if this is helpful.

http://blog.sqlauthority.com/2009/04/30/sql-server-fix-error-is-not-a-valid-win32-application-exception-from-hresult-0x800700c1/

---

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

Answer 6

I did as you mentioned in option 1. when i run it says " not a win32 application".

This implies you are trying to download the 64bit version and you do not have a 64bit machine.

Can you download and install the x86 version?

If you already have the x86 version then use the Link provided above by Shanky_621.

Answer 7

I am using windows 8. It is saying it is not compatible. what shall i do ?

On other system on which it gives error sayig" not a win 32 appication".The syatem details are microsoft windows xp

version 2002

service pack 3.

actually i want to download on windows 8. can i do that.

Please tell me the available options for both systems. thank you

Answer 8

I do not have IIS on my machine. which is windows xp.version 2002.service pack 3.

Answer 9

You need to download the x86 (32bit) version. The version you have is x64 (64bit) which will not work.

Answer 10

 did the following.But did not not see IIS.

1. On the Start menu, click Control Panel.
2. Double-click Add or Remove Programs.
3. Click Add/Remove Windows Components.
4. Click Internet Information Services (IIS) and then click Details.

Answer 11

Sorry but no-one will help you if you don't take our advice and try all suggestions.

I have repeatedly asked that you try to download the x86 32bit version because it seems you are trying to install a 64bit version on your system which is incompatible.

Thanks

Answer 12

Hi

 I just tyed in google "How to download the x86 32bit version" ? It gave me bunch of things. Do not understand which one? I am trying to this on windows 8.Thanks

Answer 13

Hi,

You need to go here:

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

And then press Download.

When presented with options you need to scroll down and choose:

ENU\x86\SQLEXPRWT_x86_ENU.exe

This is the 32bit one that you want (database engine and Management Studio)

Answer 14

Hi

 I did as you said. Now I am getting following error.

TITLE: Upgrade to SQL Server 2012
------------------------------

There are validation errors on this page. Click OK to close this dialog box. Review errors at the bottom of the setup page, then provide valid parameters or click Help for more information.

------------------------------
BUTTONS:

OK
------------------------------

Answer 15

Could you provide a screenshot.  Also, it says "Upgrade to SQL Server 2012"...  why are you running an upgrade?  I didn't think you had SQL Server installed...  an upgrade would imply that you do?  Either that or you've already got SQL Server installed?

Answer 16

does any of the visual studio express or ultimate comes with sqlserver or do I need to download sqlserver separately?

Answer 17

I don't believe so, no.  I have Visual Studio 2010 Ultimate and Visual Studio 2012 Professional on my laptop and neither came with SQL Server.  I installed SQL Server 2008 R2 Express separately on my laptop with no issues at all.

Answer 18

But the problem is I am using windows 8.That is the reason I am not being successful in downloading all these.

Answer 19

I am also using Windows 8...  therefore that is irrelevant to the situation.

I think you need to contact Microsoft Support directly.

In order to legally license Visual Studio you must have a MSDN subscription and this comes with free support calls.

Sorry we couldn't seem to help.

Answer 20

Thank you anyway.