September 6, 2008 at 4:10 pm
Hi
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,
Rich
September 6, 2008 at 8:08 pm
If SQL Server is running, meaning the service is running, can you connect to "(local)"?
Also, it installs under Program Files, look for the SQL Server log files, and you will see under which ports it is listening and if this is a named instance or the default instance.
September 7, 2008 at 4:54 am
(local) does work, how comes localhost\mssqlserver does not work then, surely it should do?
As for reporting services, I am not sure what to do about that!
If I run Reporting Services Configuration Manager it errors with "Provider load failure".
Something isn't right so a method to completely wipe SQL Server and all the extras would be great so I could start from fresh (Not reinstalling Windows!)
Thanks,
Rich
September 8, 2008 at 3:59 pm
SQL server 2005 std requires installing to a server OS not a client OS, for clients use developer or Express
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2008 at 4:11 pm
localhost/mssqlserver is a named instance. (local) defaults to local (I think 127.0.0.1)
The /mssqlserver isn't necessary for a default instance. You'd just connect to the Windows machine name.
If you want to reinstall, I'd save off your databases (ldf/mdf files) just in case. Run uninstall from the Control Panel. Note that there are multple SQL Server 2005 installation items. I think RS is separate. REmove them all, whack the registry keys (HKLM/Software/MS SQL Server) and then reinstall.
September 9, 2008 at 1:18 am
OK thanks, I was unaware of this, would explain a lot, I will stick to express until I have my server up and running then. I will try the registries this afternoon, thanks for your help.
September 12, 2008 at 8:35 am
See if you can't get SQL 2005 Developer... it's the enterprise edition with all the bells and whistles... but it installs onto a client OS (Vista, Win2k, XP, etc).
I used to try to do dev work with express... but there are pieces missing...
September 12, 2008 at 12:47 pm
Downloading now and will try it, I originally did not want to use the developer as I wanted a 64bit version (have 64 Vista so may as well!!!) and my uni msdn only has the developer 32bit version. Trying to install express again moaned that an instance of reporting services was already installed although I removed everything, the files and the registries of it so I don't know what else it has found, very annoying!!
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply