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

c++ - Function signature as a function template parameter -

algorithm - What are some ways to combine a number of (potentially incompatible) sorted sub-sets of a total set into a (partial) ordering of the total set? -

How to call a javascript function after the page loads with a chrome extension? -