I have been using SQL Express for some time and found that I could get a copy of SQL Server Standard from my uni so I thought I would give it a try (I wish I never did now!!)
I am running Vista Ultimate x64 SP1 with IIS7 installed and set up and trying to install SQL Server 2005 Standard x64.
I completely removed Express and then installed Standard, it all installed fine but when I opened up Management Studio and entered localhost\mssqlserver it could not connect, so I clicked on browse and it found no local servers, the services for mssqlserver are started but nothing. I thought something went wrong in the install so I uninstalled SQL server and installed again, however, on reinstall it said an instance of Reporting Services was already installed so won't be installed, This install still had no database server so I looked in services and sure enough, there was a reporting services service but it would not start (as the files were uninstalled), so now even worse off!!
Basically, I have SQL server with no database servers and reporting services not being able to be installed as it was half uninstalled.
How can I set up the mssqlserver manually? and how can I remove reporting services so that I can at least install it next time I do a fresh install of SQLExpress?!!
Thank you in advance,