windows 8 - What is the connection string for a SQL Server 2012 default instance? -


i have installed windows 8 , vs 2012, want connect sql server 2012 default instance, can't figure out connection string it.

i have tried:

.\sqlexpress .\sqlexpress,1433 

and same connections pcname instead of .

first using ssms ? or trying connect using vs 2012 ? second connecting default instance of express edition or non-express edition ? (if using express edition please modify question header , question reflect that) express edition have default name sqlexpress , non-express edition has default name mssqlserver

if need know instance of sql server trying connect, can found looking @ sql server configuration manager (sscm). make sure sql server service running.

if instance name correct, @ sql native client configuration -> client protocol in sscm , check if tcp/ip enabled or not.

if enabled check if firewall blocking connection or not.

as side note, if using default port don't have explicitly define port when trying make connection.


Comments

Popular posts from this blog

Perl - how to grep a block of text from a file -

delphi - How to remove all the grips on a coolbar if I have several coolbands? -

javascript - Animating array of divs; only the final element is modified -