Connection Issues

Question

Post reply

Connection Issues

Welsh Punk

SSC Rookie

Points: 43
More actions
July 11, 2011 at 2:01 am

#241320

Hi there. Recently tried to install SQL Express on windows 7. Didnt have much joy. I have also installed Visual Studio 10 which I think may install some version of SQL. Uninstalled everything (SQL) and then installed SQL Server 2008 and applied the SP2.
In configuration manager I have MSSQLSERVER running AND SQLEXPRESS. I can connect to the SQLEXPRESS but not MSSQLSERVER. I dont know why SQLEXPRESS is there as I uninstalled everything to get a clean install.
Any help please
Phill

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 1

if the instance of sqlexepress is present (like a service), then occurs some errors on uninstall!!!

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

CarpenterBob Ten Centuries Points: 1026 More actions · Answer 2

Yes, check add/remove programs again to see if anything is left over & if the service is still there. Also, check to see if there is still folders for SQL EXPRESS under Program Files, delete those if so. They should be able to coexist so something may just be wrong with your other SQL instance. What is the exact error when trying to connect ?>

Steve Jones - SSC Editor SSC Guru Points: 738632 More actions · Answer 3

Visual Studio installs SQL Server Express as part of it's package.

The .\SQLEXPRESS is a named instance. The MSSQLSERVER should be the default instance you installed.

Welsh Punk SSC Rookie Points: 43 More actions · Answer 4

I cannot connect to MSSQLSERVER but I can connect to [PC NAME]\SQLEXPRESS. If I try to browse for server I only find the SQLEXPRESS?!?!

CarpenterBob Ten Centuries Points: 1026 More actions · Answer 5

I assume you are doing this in SSMS? Did you try with both Windows and SQL server authentication ?

Welsh Punk SSC Rookie Points: 43 More actions · Answer 6

Yes using SSMS. When I try to connect it only lists the [PC NAME]\SQLEXPRESS as a server using Database Engine. If I browse to look for additional server instances it still only lists the same one. Tried typing out MSSQLSERVER and using Windows NT Auth and the other but will not connect. In the configuration manager the service for MSSQLSERVER is running...

Steve Jones - SSC Editor SSC Guru Points: 738632 More actions · Answer 7

Steve Jones - SSC Editor

SSC Guru

Points: 738632

July 11, 2011 at 2:53 pm

#1351338

Can you connect to "(local)"

Welsh Punk SSC Rookie Points: 43 More actions · Answer 8

Can I connect to local what.... Sorry Im a newbie here. IN SSMS I get the choice to connect to

SERVER TYPE : Database Engine (Dropdown box will allow me to select others but not sure if I should select these so sticking to the default)

SERVER NAME : The only option here is my pcname\SQLEXPRESS Tried browsing for more but none others listed

I have tried Windows Authentication and SQL Server Authentication to no avail with anything but SQLEXPRESS

I have also tried to completely uninstall all versions of SQL. (and used REVO which tidies up files left over) After uninstalling and restarting - I tried to install afresh to see if this makes any difference. All this did was to add yet another instance of SQL THE PREVIOUS BLOODY INSTANCES CAME BACK!!!!

Totally peaved off with this now........ Tried to do a complete system restore but would only go back a few days so looks like I am stuck other than putting everything back to the factory default - which I dont really want to do.