Fresh install no database server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server Newbies » Fresh install no database server

Fresh install no database server

Rate Topic

Display Mode

Topic Options

Author

Message

RICOUK

Posted Saturday, September 06, 2008 4:10 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, November 03, 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

Steve Jones - SSC Editor

Posted Saturday, September 06, 2008 8:08 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:14 PM
Points: 31,421, Visits: 13,734

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

RICOUK

Posted Sunday, September 07, 2008 4:54 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, November 03, 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

Perry Whittle

Posted Monday, September 08, 2008 3:59 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:36 AM
Points: 5,201, Visits: 11,153

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" Wink

Post #565817

Steve Jones - SSC Editor

Posted Monday, September 08, 2008 4:11 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:14 PM
Points: 31,421, Visits: 13,734

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

RICOUK

Posted Tuesday, September 09, 2008 1:18 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, November 03, 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

mtassin

Posted Friday, September 12, 2008 8:35 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 8:24 AM
Points: 3,226, Visits: 64,213

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

RICOUK

Posted Friday, September 12, 2008 12:47 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, November 03, 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 »

Permissions