How to connect to SQL Server using SQL Server Management Studio using Windows and SQL Authentication -


i new sql server 2012. have installed sql server 2012 on local machine successfully. when try connect using management studio, getting errors. not able connect using windows authentication or sql server authentication. didn't screen asking username or password while installing sql server. credentials should use connect via sql server authentication. pfb screen shots of errors both modes:

windows authentication:

loginscreen

sql server authentication:

loginscreen

error message:

errormessage

please me resolve error. have been stuck week here.

first step: go start menu > programs > microsoft sql server 2012 > configuration tools > sql server configuration manager.

you should see screen this:

enter image description here

you should see at least one entry named sql server (instance name) , should in running state.

note: if there no entry labeled sql server (....), don't have sql server installed. reinstall it.

if entry not in running state, need start it.

if "instance name" indeed sqlexpress, should able connect .\sqlexpress machine/instance name.

however, if name anything else, then:

  • if "instance name" mssqlserver (as in screenshot), have unnamed default instance - connect using . (just dot), or (local) (with parenthesis!)
  • if "instance name" else that, connect using .\instance or (local)\instance - use dot or (local) denote local machine, , backslash , instance name find in screen

-