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
Post a Comment