'I can't connect to SQL Server - getting connection error

I am somehow new with the coding. My error appears when I try to "transfer" the table from the SQL Server

Pic:[username+other stuff]

I have changed the name, I tried many things. Something weird is that when I go to Windows authentication, I still have the same files (I don't know if this is normal) and I also tried to do it without password but the error occurred faster.

Pic:[the error]

c++sharpsql-serverconnection


Solution 1:[1]

Make sure you choose the DB/conString to your Local DB DESKTOP-UB6UCB&, make the username and password same as its login standart: username = sa password = as

Solution 2:[2]

Have you checked that you have TCP/IP and Named Pipes enabled? Open SQL Server Configuration Manager and enable both settings then restart the SQLSERVER service.

This can be necessary if you didn't choose allow Mixed Authentication when installing and configuring SQL Server.

The other suggestions about Integrated Security and Trusted_Connection above will also be helpful, but I believe that you have to enable TCP/IP and Named Pipes first.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Fikri
Solution 2 OldBuildingAndLoan

Related Questions