August 3, 2008 at 11:44 pm
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!
August 4, 2008 at 10:06 am
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?
August 5, 2008 at 7:31 am
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!
August 5, 2008 at 8:08 am
it's installed properly. use management studio, not the configuration manager to browse databases and objects.
August 5, 2008 at 8:27 am
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!
August 5, 2008 at 8:35 am
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..
August 5, 2008 at 10:07 am
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.
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?
Erik
Dam again!
August 5, 2008 at 10:13 am
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
August 5, 2008 at 10:19 am
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!
August 5, 2008 at 10:44 am
you do need SQL Management Studio to manage SQL Server, it just does not need to be installed on the server.
August 5, 2008 at 11:16 am
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!
August 6, 2008 at 3:09 am
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.
August 7, 2008 at 8:16 am
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
August 7, 2008 at 8:42 am
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