SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Fresh install no database server


Fresh install no database server

Author
Message
RICOUK
RICOUK
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 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
Steve Jones
Steve Jones
SSC Guru
SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)

Group: Administrators
Points: 146490 Visits: 19430
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
My Blog: www.voiceofthedba.com
RICOUK
RICOUK
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 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
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)

Group: General Forum Members
Points: 54065 Visits: 17681
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" ;-)
Steve Jones
Steve Jones
SSC Guru
SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)

Group: Administrators
Points: 146490 Visits: 19430
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
My Blog: www.voiceofthedba.com
RICOUK
RICOUK
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 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.
mtassin
mtassin
SSCertifiable
SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)

Group: General Forum Members
Points: 7262 Visits: 72521
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
RICOUK
RICOUK
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 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!!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search