Where is my DB instance?

Question

Where is my DB instance?

Jacob Pressures

SSCertifiable

Points: 5804
More actions
April 16, 2016 at 6:07 pm

#315704

I just installed SQL Server Developer's 2014 edition. I've attached a picture. It can't find my instance. I've installed this tons of times in the pass, usually when I open the management studio I have something if not just the model db. During the installation, also I was not asked if I wanted to create a default instance or a named instance.
I'm running Windows 10 Pro.
Thanks!

Viewing 5 posts - 1 through 4 (of 4 total)

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

Alan Burstein SSC Guru Points: 61141 More actions · Answer 1

Have you tried clicking the drop-down and selecting "<browse for more>" then looked at local servers? If there's nothing in there then there may have been an issue with you install or the SQL Server service is not running.

You can also try "localhost" or your computer's IP address.

FYI.The default instance name is MSSQLSERVER

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

Jacob Pressures SSCertifiable Points: 5804 More actions · Answer 2

Thanks for your reply. I took a look at the services and I didn't see anything related to SSMS. I tried typing localhost and I got an error message. Of course there doesnt' seem to be a SQL Server running. I've attached pictures of what I saw.

Thanks!

Alan Burstein SSC Guru Points: 61141 More actions · Answer 3

From the looks of your first and last picture - it would appear that SQL Server is not installed. There is a checkbox during the install for "Database engine services"...

(Note the top checkbox)

That would explain why you were not asked if I wanted to create a default instance or a named instance. If you had the SQL engine installed you would see this under services:

If that is the case you can just run the install again and check that box.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

Jacob Pressures SSCertifiable Points: 5804 More actions · Answer 4

Thanks Alan! That was it. I thought about checking that and when you showed the screen shot I wasn't sure if I did. But I don't remember doing that in previous editions and I think I assumed it would check the whole tree of sub options as well.

anyway! Thanks! that worked.