unknown SQL Server Instance name... cannot connect

After installation, in SSMS, I cannot connect to database because I don't know what the server name is. I tired .  .(local)   (local) SQLEXPRESS but none of four options work.

During installation of SQLManagementStudio_x86_ENU.exe at http://www.microsoft.com/en-us/download/details.aspx?id=7593
I was not prompted to specify instance name (or maybe I have not paid attention when it was prompted). This may be related to an existing but abandoned version of SQL Server Express there. Meaning, a version existed and during the installation I haven't asked for a new instance.

Prior to the installation of SQLManagementStudio_x86_ENU.exe, I attempted to install another version of SQL Server (also express). After I knew it was wrong version, I restored the system to a previous restore point which must have cleared the registries for bad version of SLQ Server Express but must have kept the bad installation intact. This is why I am having this problem I guess.

Question1:
Is it possible now to associate the new installation with SQLEXPRESS as its instance name?

Also I need the missing SP3 to facilitate Visual Studio 2010 Premium to work with SQL Server just installed.

Question2: , Also need SP3 (I am not sure that will be SP3 for SQL Server or SP3 for Visual Studio if they are different to begin with).

FYI, I have Windows 7 home edition.

Thank you.
LVL 34
Mike EghtebasDatabase and Application DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jacques Bourgeois (James Burger)PresidentCommented:
In the administrative tools of the station, accessible through the Control Panel if you do not see it on the Start button, go into the services and start the SQL Server Browser. That will enable you to list the name of the available servers in different places.

If SQL Management Studio works, you will be able to see your server listed when trying to connect.

If SQL Management Studio does not work, you will be able to get the name of the server by adding a new Data Connection in the Server Explorer.
0
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
Hi James,

As shown on the attached image, there is no SQL Server under administrative tools.

I tried to make a data connection which failed to connect, this is also shown on the image.

Also, I expended services to look through in case it is supposed to be there.

Thanks,

Mike
server.png
services.png
0
sumeshbnrCommented:
Use your computer name\SQLEXPRESS

Sa your computer name is SYSTEM1 then you need to use  SYSTEM1\SQLEXPRESS  on the server field of the SQL management studio
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

sumeshbnrCommented:
Also you should check you have installed MSSQL server properly The SQL Server Express service name is MSSQL$SQLEXPRESS and the display name is SQL Server (SQLEXPRESS).I coulnt fin dthe service in your screen shot.Please check
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
sumeshbnr,

I think you are right. The installation is not done right. I am reformatting my HD to do all over again but correctly this time.

Thanks,

Mike
0
sumeshbnrCommented:
Why reformatting you can now install SQL express only and solve the problem itself
0
Jacques Bourgeois (James Burger)PresidentCommented:
You did not read my post correctly:

In the administrative tools of the station, accessible through the Control Panel if you do not see it on the Start button, go into the services and start the SQL Server Browser. That will enable you to list the name of the available servers in different places.

Until the browser service is started, you won't see the name of the server anywhere. It is off by default as a security feature.
0
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
Due to lack of skill, sometimes I find easier to have a fresh start instead of going to endless loop often Microsoft makes you to go though it. Microsoft is master of torturing people. For example, Appache installs server, database, and any other requirements with just one click while Microsoft produces redundant software frequently each with its own special requirements, and have a very touchy settings. I don't know why their programmers spend lots of time hiding games in Excel (one could start some sort video game using some special key sequence in Excel) which surely slows Excel down. But, they are not willing to put their mind into building a logic where by a single click of button (like other companies do) the software in question could pull in all the requirements from their site (or even better from Google's site if they cannot keep it together) and install all hassle free like other companies do.

Mike
0
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
Hi James,

Sorry for missing the point. Because I didn't see SQL Server Browser under the services, I thought I have messed up SQL Server installation.

Now, on my second try could you possible help me with this question:

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_28272946.html

Thank you,

Mike
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.