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

Time:02-20

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]

CodePudding user response:

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

CodePudding user response:

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.

  • Related