Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Varwulf
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! |
|
|
Varwulf
Starting Member
2 Posts |
Posted - 2015-04-02 : 16:53:27
|
| Bump. |
 |
|
|
gbritton
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 |
|
|
|
jeffw8713
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. |
|
|
|
|
|
|
Novice Issue with SQL Management Studio 2012