Install sql server 2005 on server2008 OS

  • 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!

  • 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?

  • 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!

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

  • 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!

  • 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..

  • 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!

  • 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

  • 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!

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

  • 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!

  • 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.

  • 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

  • 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.

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

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