I've installed MS SQL 2005 on 2003 server twice now. I did a fresh install and installed everything in default locations. I saved the install log and then after I installed SP4 (RTM) which I assume is the latest available SP for MS SQL 2005. So when I try to connect to the database using Microsoft SQL Server Management Studio, it can't connect to 127.0.0.1 or the host name of the machine for what ever reason. I checked to see if the service is running and I can't find anything listed in the 'Services' window for the MS SQL Server 2005. I don't know how to start or stop the services of the database. Am I missing something here?
I did a basic 2005 installation. It checks for .net frameworks & IIS and then just click next a few times. I did all the default installation parameters & installed every option possible to the hard drive. It never asks me for anything beyond that. I don't see what I'm missing here. I'm guessing I installed it as a default instance.