Cannot connect to SQL Server in Visual Studio

Question

I installed SQL Server and Visual Studio and tried to do my university project.

I can connect to SQL Server in Management Studio but can not connect in Visual Studio!

Remote connecting is enabled
all services are running
and everything is ok but I dont know why I get this error :

A network related or instance specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.verify that the instance name is correct and the ...

What's wrong with this code?

 SqlConnection sqcon = new SqlConnection("Data Source=.;Initial Catalog=Badan_Sazi;Integrated Security=True");

 SqlCommand com = new SqlCommand();
 com.Connection = sqcon;
 com.CommandText = "SELECT tbl_morabi.family   as 'lname'  FROM tbl_morabi";

 com.Connection.Open();

I also tried ., localhost, my pc name ... same error anyway

Visual Sudio 2012
SQL Server Express 2012

connectionstrings.com/sql-server

Dmitrii Bychenko
– Dmitrii Bychenko

2015-02-19 09:23:00 +00:00
Commented Feb 19, 2015 at 9:23 — Dmitrii Bychenko
– Dmitrii Bychenko, Commented Feb 19, 2015 at 9:23

marc_s · Accepted Answer · 2015-02-19 09:21:44Z

10

SQL Server Express defaults to a SQLEXPRESS instance name

So try to use .\SQLEXPRESS or (local)\SQLEXPRESS as your server+instance name.

And if that doesn't work: what server name do you use in Management Studio to connect to your SQL Server instance?? Use that name!

answered Feb 19, 2015 at 9:21

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

hrh_fourtyseven Over a year ago

thank you . tried that and now syntax error "Error 2 Unrecognized escape sequence "

Guffa Over a year ago

@hrh_fourtyseven: You need \\ to put a \ in the string.

nevra · Accepted Answer · 2015-02-19 09:22:28Z

0

You can check your connectionString. It should be like that below.

<connectionStrings>
<add name="SampleConnectionString" connectionString="Data Source=machinename\instancename;Initial Catalog=AdventureWorks;Integrated Security=SSPI;Min Pool Size=5;Max Pool Size=60;Connect Timeout=30″ providerName="System.Data.SqlClient"/>
</connectionStrings>

answered Feb 19, 2015 at 9:22

nevra

4282 gold badges7 silver badges22 bronze badges

3 Comments

hrh_fourtyseven Over a year ago

thank you. visual studio does not accept mymachine\instancename because of syntax error ! should I type it different?

nevra Over a year ago

If you use default settings, you should write .\SQLEXPRESS, for other things you should check SQL SERVER Server Name

Jari Turkia Over a year ago

Use Data Source=(localdb)\\MSSQLLocalDB instead. See: stackoverflow.com/a/52838019/1548275

Collectives™ on Stack Overflow

Cannot connect to SQL Server in Visual Studio

2 Answers 2

2 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related