CODEWITHSUNDEEP
sqlsql-server-2012-express
stinaq
stinaq

Reputation: 1284

Installed SQL server management studio 2012, but there are no instances running

So, as it says, I installed sql server (2012 express), and during installation I checked the option LocalDB. Now I'm trying to connect to the database engine, but can't. I've tried connecting with windows authentication (to local, and localhost), with sa-user and no password and a bunch of other stuff.

When I visit the configuration tool and try to se what my instance is called, I see a new problem. There's nothing running at all. Under SQL Server configuration manager (local) --> SQL Server Services there's nothing.

What am I missing? Obviously I've missed som step where I start something up, but for the life of me I don't know what. Help!

Upvotes: 4

Views: 19334

Answers (3)

Graham Baitson
Graham Baitson

Reputation: 600

I had the same issue and was able to connect using (localdb)\v11.0 with Windows Authentication.

Upvotes: 2

matsho
matsho

Reputation: 121

http://www.stratospher.es/blog/post/connecting-to-localdb-with-sql-server-management-studio-2012-ssms

LocalDB doesn't create any database services; LocalDB processes are started and stopped automatically when needed. The application is just connecting to "Data Source=(localdb)\v11.0" and LocalDB process is started as a child process of the application. A few minutes after the last connection to this process is closed the process shuts down.

Upvotes: 2

Vishal Suthar
Vishal Suthar

Reputation: 17183

just use localhost\sqlexpress with Windows Authentication

You can also Try .\SQLExpress

Upvotes: 3

Related Questions