I cannot connect to my basic SQL server from Visual Studio Ultimate 2013? Error 40 - Cannot establish connection


i started learning asp.net through book, , asks connect "your" sql server , explore .mdf file. i've been trying install sql, got working installation, , won't let me install management software. whenever try connect, error: http://puu.sh/7f2jy.png

this connect:

1) open project

2) navigate server explorer

3) click on connect database

4) in menu, can see me machine name on top part, think means it's picking server runningh

5) on bottom, wants me enter database name. think may problem, have no idea here.

also, when double click on database file, errpr (52): http://puu.sh/7f2yw.png

i don't know here, post tips down below


hi,

did choose correct server name? should machine name installed sql server on.

is empty when open select or enter database name drop box in add connect dialog box in visual studio 2013?

“update: re-installed, , used both installers. have server management tools, still cannot connect.”

the screenshots indicates sql server not accessible.

do mean not able connect sql server using sql server management studio?

if so, make sure sql server services started.

please check out following articles details:

how to: start instance of sql server (sql server configuration manager)

http://technet.microsoft.com/en-us/library/ms190699(v=sql.105).aspx

connect sql server component sql server management studio

http://technet.microsoft.com/en-us/library/ms173871.aspx

thanks.

tracy cai
technet community support



SQL Server  >  Getting started with SQL Server



Comments

Post a Comment

Popular posts from this blog

Reindexing

hi     using sql server 2005 ee sp4. our database size 150 gb. weekly once schedule reindex job. ran 4 5 hours maximum. but recent days getting more 13 hours. the possibilities there? ragu thangavel how perform reindex? maint plan? or check fragmentation first , reorganize fragmented? if later, quite more data nowadays fragmented before. if not, consider doing "smart" defrag (ola.hallengren.com). tibor karaszi, sql server mvp | web | blog SQL Server  >  SQL Server Database Engine
Read more

Users List

hello everyone, i"m builing tool tfs , want user list form tfs "assigned to" field. if 1 can post code review i"ll gled.   thanks hello, to imports users tfs, can try this: using microsoft.teamfoundation.server; using microsoft.teamfoundation.client; using microsoft.teamfoundation.workitemtracking.client; icredentialsprovider provider = new uicredentialsprovider (); teamfoundationserver tfs = teamfoundationserverfactory .getserver(“your_server_name”, provider); tfs.authenticate(); igroupsecurityservice gss = ( igroupsecurityservice )tfs.getservice( typeof ( igroupsecurityservice )); identity idsid = gss.readidentity( searchfactor .accountname, "team foundation valid users" , querymembership .expanded); identity [] idusername = gss.readidentities( searchfactor .sid, idsid.members, querymembership .none); foreach ( identity id in idusername) {       if (id != null && id.type == identitytype .windowsuser) ...
Read more

List of charts

Image
i'm trying build report show activity for reservations placed and satisfied month branch. the report has parameter the item category and dataset has fields month category branch reservations placed reservations satisfied on front sheet i've created system wide figures 2 columns per month and a matrix broken down category (e.g. child fiction, child non fiction, adult fiction, adult non fiction) has row , column totals. i want have page each branch in system. what's best way of approaching this?  add parent group based on branch field in row groups  and add page breaks repeat matrix report every branch. please mark answer if post solved problem. milan das SQL Server  >  SQL Server Reporting Services, Power View ...
Read more