SQL Server connection string error cannot connect

Question

This is my connection string

I have added double \\ for the unrecognized escape sequence in vs 2019

SqlConnection db = new SqlConnection("Server=localhost\\DESKTOP-8QL52AL\\ASADI; Database=atm;  Integrated Security=True;");
db.Open();

Error at line -26 check your server name or check your SQL Server is configured for remote connections

You have given a host twice in the connection string. Remove either one. — fredrik
– fredrik, Commented Jun 21, 2020 at 13:58

marc_s · Accepted Answer · 2020-06-21 13:59:00Z

2

You server/instance name is all wrong:

"Server=localhost\\DESKTOP-8QL52AL\\ASADI;

You can either have

just the server name (or IP address) when connecting to the default, unnamed instance on your machine
```
 Server=DESKTOP-8QL52AL
```
or you can have the server name and an instance name, if you're connecting to a named instance
```
 Server=DESKTOP-8QL52AL\\ASADI
```

And in both cases, you can replace the actual physical machine name with localhost to connect to the local machine (without specifying its explicit name):

    Server=localhost
    Server=localhost\\ASADI

but you CANNOT have localhost AND your explicit machine name DESKTOP-8QL52AL in a single connection string - that just doesn't make any sense and isn't supported.

answered Jun 21, 2020 at 13:59

marc_s

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

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

Comments

VertexGames · Accepted Answer · 2020-06-21 13:58:51Z

0

If the SQL server is on the local machine and you only have 1 sql instance installed

"Server=localhost; Database=atm; Integrated Security=True;"

if its SQL EXPRESS use

"Server=localhost\SQLEXPRESS; Database=atm; Integrated Security=True;"

answered Jun 21, 2020 at 13:58

VertexGames

973 bronze badges

Comments

barath · Accepted Answer · 2020-06-21 15:21:23Z

0

Basic Sql Server connection string syntax:

connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"

If you have a named instance of SQL Server, you'll need to add that as well.

"Server=localhost\sqlexpress"

answered Jun 21, 2020 at 15:21

barath

13 bronze badges

Collectives™ on Stack Overflow

SQL Server connection string error cannot connect

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related