Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Novice Issue with SQL Management Studio 2012

Author  Topic 

Starting Member

2 Posts

Posted - 2015-03-28 : 22:09:38
Greetings all,

It's been ages since I've set up a server using Management Studio and I appear to have really messed up my first effort to install a basic local server on my machine for use in some home brewed applications.

Here is what I have currently (sorry, screen shots are easier):

As you can see I somehow have two express instances (mssqlserver and sqlexpress) as well as two shared components (SSMS and LocalDB), but as you can see from my services in the second image, only the mssqlserver is actually running. I cannot start (successfully) any of the others.

When I attempt to access any of them from SQL Management Studio 2012, my windows authentication fails every time as well.

I'm just trying to get a very nice, clean, basic install of a single local instance of express I can use for my own needs. I'm a fairly fussy person so seeing those other instances on there that I apparently cannot use would bother me.

How can I get to the point, from here, of having one instance I can actually use and only one?

Thanks so much for your time!

Starting Member

2 Posts

Posted - 2015-04-02 : 16:53:27
Go to Top of Page

Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-04-02 : 22:29:10
YOu need to go to the start menu, Computer/Manage/Services. Find the service that won't start and open its properties. Click on the Log On tab, delete the passwords (Password and Confirm Password) then click apply. You should get a message about being granted the right to logon as a service. Now click on the General tab and Start
Go to Top of Page

Aged Yak Warrior

819 Posts

Posted - 2015-04-06 : 13:55:02
The instance named SQLEXPRESS is actually your old SQL Server 2008 R2 instance. The instance named MSSQLSERVER is your 2012 default instance. If you do not need or want the 2008 R2 instance you can remove it using Programs and Features.

Go to Top of Page

- Advertisement -