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

sql sql-server-2012-express
stinaq picture stinaq · Aug 29, 2012 · Viewed 19k times · Source

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!

Answer

Vishal Suthar picture Vishal Suthar · Aug 29, 2012

just use localhost\sqlexpress with Windows Authentication

You can also Try .\SQLExpress

Related questions

How to prevent 'query timeout expired'? (SQLNCLI11 error '80040e31')

I have a connection to a MS SQL Server 2012 database in classic ASP (VBScript). This is my connection string: Provider=SQL Server Native Client 11.0;Server=localhost; Database=databank;Uid=myuser;Pwd=mypassword; When I execute this SQL command: UPDATE [info] …

Read More
Get .sql file from SQL Server 2012 database

I need to get .sql files from an existing database with SQL Server 2012. Is this possible because all I see in the export option is delimited files. Ex.) I have table1 with 30 records. I need a file that would be …

Read More
Can't create stored procedure with table output parameter

I have this code: IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetProfitDeals]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[GetProfitDealsVar2] GO IF EXISTS(SELECT 1 FROM sys.types WHERE name = 'TableOrderType' AND is_…

Read More