Install sql server 2005 on server2008 OS

Question

Install sql server 2005 on server2008 OS

BuilderBits

SSCertifiable

Points: 6071
More actions
August 3, 2008 at 11:44 pm

#188875

I am having a tough time trying to install a 64 bit version of sql server2005 on a fresh install of server 2008.
I can see the files in C:\Program Files (x86) but nothing is in C:\Program Files " This is where the 64 bit lives at"
it seems to install but i can not find it anywhere.
What do i do to get this to install correctly?
thanks
erik
Dam again!

Viewing 14 posts - 1 through 13 (of 13 total)

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

antonio.collins SSCrazy Eights Points: 9600 More actions · Answer 1

do you see the MS SQL Server 2005 program group in the start menu? did you use the defaults when installing? (C:\Program Files\Microsoft SQL Server is the default home.) do you see SQL Server services when listing services?

BuilderBits SSCertifiable Points: 6071 More actions · Answer 2

I have installed and uninstalled until I am officially fing crazy.

Here are some pictures that show what I have. Notice how everything looks installed but i can not get to the object explorer.

I also have vs2008 installed on the same machine.

Thank you for any help at all.

ERik

Dam again!

antonio.collins SSCrazy Eights Points: 9600 More actions · Answer 3

it's installed properly. use management studio, not the configuration manager to browse databases and objects.

BuilderBits SSCertifiable Points: 6071 More actions · Answer 4

I know this one is going to sound super loco....

It seems to me that management studio is not installed. That is what i have been looking for this whole time.

That is why i took that snap shot of of the folders from the start/all programs/Microsoft SQL Server 2005 for you.

Where should i look for management studio?

erik

Dam again!

steveb. SSC-Forever Points: 46733 More actions · Answer 5

Management Studio does not install as default when you are installing on a server, you need to click on the option to install Client tools if you want these on your server..

BuilderBits SSCertifiable Points: 6071 More actions · Answer 6

Thanks so much for the help...

Your help guided me to be able to fix my problem.

After digging into this from your eduction i am able to find this issue on Google, and this is a know MS f-up.

http://aspadvice.com/blogs/ssmith/archive/2008/03/21/SQL-2005-Tools-Install-Experience-is-the-suck.aspx

However, this does raise some new questions to my .net developer mind. 😉 SOOOOO, we install sql with no management studio ? this means we install sql and manage it with ? I think i bumped into an area that is a little deep. 😉

p.s. i am still not running in 64 bit mode. How do i switch from 32 bit to 64 bit?

Storefront Doors

Erik

Dam again!

steveb. SSC-Forever Points: 46733 More actions · Answer 7

Well Generally SQL sever is run on a server with a bare as possible install, this means that unless you need the service then there is no reason to install it. You can run sql sever without Management studio installed on the server, in fact it is recommended.

Management studio is usally installed on the Client computer, this is used to manage the SQL server, a .net developer should also be able to connect to the server to develop, either via SSMS or .NET

BuilderBits SSCertifiable Points: 6071 More actions · Answer 8

I actually have a web server with only iis7.0 installed, a server with only sql installed "NOT this one you guys are helping me with", and a dns server that only has DNS installed on it.

I am glad this has come up because i was not even aware that one could manage the software application sql with out the management studio. I just never thought of looking that deep.

This install has really opened my eyes on some new things.

Erik

Dam again!

steveb. SSC-Forever Points: 46733 More actions · Answer 9

you do need SQL Management Studio to manage SQL Server, it just does not need to be installed on the server.

BuilderBits SSCertifiable Points: 6071 More actions · Answer 10

So you are saying it is best to install sql server on the production machine and have another box with management studio installed to remotely manage sql server.

Ok, i see whats going on, in a big production environment there are many servers with only sql server on them and only one (or more) box(s) that remotely manage all of the sql servers.

erik

Dam again!

steveb. SSC-Forever Points: 46733 More actions · Answer 11

Yes that is the way that usually done, it means you can manage all your servers from your pc, also the less server resources you use the better.

dweil SSCrazy Points: 2408 More actions · Answer 12

On this subject we are hoping to install sql server 2005 standard on a two node 64 bit cluster in the near future.

Is windows 2008 mature enough to run in a production environment of would it make sense to stay with windows 2003

Thanks

David Weil

Jeremy Brown SSCarpal Tunnel Points: 4223 More actions · Answer 13

dweil (8/7/2008)
On this subject we are hoping to install sql server 2005 standard on a two node 64 bit cluster in the near future.
Is windows 2008 mature enough to run in a production environment of would it make sense to stay with windows 2003
Thanks
David Weil

If it were me, I wouldn't... Not unless you've got the super special secret Microsoft BatPhone when you run into issues. I'd stay with WIN2K3 at least until next year.