Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Fresh install no database server Expand / Collapse
Author
Message
Posted Saturday, September 6, 2008 4:10 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 3, 2008 10:04 AM
Points: 4, Visits: 8
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
Post #565075
Posted Saturday, September 6, 2008 8:08 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:38 PM
Points: 31,355, Visits: 15,819
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #565082
Posted Sunday, September 7, 2008 4:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 3, 2008 10:04 AM
Points: 4, Visits: 8
(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
Post #565115
Posted Monday, September 8, 2008 3:59 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:21 AM
Points: 6,737, Visits: 14,369
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"
Post #565817
Posted Monday, September 8, 2008 4:11 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:38 PM
Points: 31,355, Visits: 15,819
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #565823
Posted Tuesday, September 9, 2008 1:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 3, 2008 10:04 AM
Points: 4, Visits: 8
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.
Post #565939
Posted Friday, September 12, 2008 8:35 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 7:42 AM
Points: 3,688, Visits: 72,435
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...




--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #568579
Posted Friday, September 12, 2008 12:47 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 3, 2008 10:04 AM
Points: 4, Visits: 8
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!!
Post #568859
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse