How to Connect to Microsoft SQL Server in Eclipse IDE

[@tbrizOfficial]

Holy shit - Eclipse is absolute dog shit when it comes to this. All the default SQL Server stuff is "broken" as you say and I fully agree. Was setting up and it wasn't giving me any properties window, no error messages, nothing to help me figure out why it wasn't working AT ALL. Wasted so many hours trying to figure this out. Using "Other Driver" and your settings was the saving grace. They should link your video from that window no joke. Your video freggin saved me so much, thank you!!!

[@CodeJava]

Glad it helped :)

[@RohitThirukarthick]

The TCP/IP connection to the host SV5503DB1021 qlexpress, port 1433 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".

[@mirrajeac8215]

What should I do if my schemas aren t showing when I expand ‘Schemas’ folder from my database project

[@CodeJava]

do you have any database schemas created before?

[@changtraitre9227]

hi anh em đã tạo được nhưng tới đoạn edit table(14:27) nó báo lỗi Cannot read the array length because "editors" is null # các table của em đều đã có dữ liệu rồi ạ mong anh phản hồi sớm

[@CodeJava]

Hmm, I don't know why :(

[@noddychoi]

Thanks ! You saved my life!!!

[@CodeJava]

Glad it helped!

[@MrHungdangtuan]

I had a problem during setup: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "No appropriate protocol (protocol is disabled or cipher suites are inappropriate)". I'm using sqljdbc_12.4.1lib How can I fix it?

[@CodeJava]

If I remember correctly, you need to configure SQL server to allow listening on TCP/IP protocol.

[@rameshkannan6986]

I couldn't able to edit the url connection in Properties. I am literally connecting MSSQL server with IP adddess. But i was need to add Encrpt: true,Trustcertificates:true; but it was neglacting

[@CodeJava]

Hmm, sorry to hear that. It is still able to connect, isn't it?

[@rameshkannan6986]

Not it is not able to connect because we need to add Encrpt:true

[@AyushSingh-nk6pv]

I wanted to use a centralize server. is this how we do it? Help me with that...

[@CodeJava]

yes, that is described in this video.

[@AyushSingh-nk6pv]

@@CodeJava in url do we have to write the same thing that u have written. Cuz I m getting an error that says the connection to host sqlserver, named instance sqlexpress failed. No such host is known...help me with this.

[@minhnguyenquang1724]

1/I had an error when I try to edit data from a table. The error message says: "Cannot edit table. An unknown or unsupported data type encountered for column " . That column name "Hoten" and it's data type is nvarchar(50). So pls help me .. 2/When I try to add new connection URL. It's only work when I use URL "jdbc:sqlserver://localhost;databaseName=JavaWebDemo". So why it's must be "localhost" instead of /[serverName[\instanceName][:portNumber]] I'm learning Java Web for my school Java Project and I'm VietNamese too but I want to practice English so I wrote this comment:))

[@jmrodriguez250]

Thank you very much, you are awesome!!!

[@CodeJava]

Glad it helped!

[@khangnguyenhuy1202]

i couldn't find mssql in enu

[@amankhairwar8072]

When i did the test connection it is showing ping failed

[@CodeJava]

make sure SQL server is running

[@sadwhatsappstatus9924]

What if we are using windows authentication not remote server??

[@CodeJava]

then you should use the JDBC URL like this: jdbc:sqlserver://localhost;integratedSecurity=true; Reference: www.codejava.net/java-se/jdbc/connect-to-microsoft-sql-server-via-jdbc

[@priyanthafernando2849]

@@CodeJava Tried this. But error says 'Enter a user name.' Please help

[@CodeJava]

@@priyanthafernando2849 you need to know username and password of the database.

[@priyanthafernando2849]

@@CodeJava but im using windows authentication. It does not have username and password ☹️?

[@CodeJava]

@@priyanthafernando2849 Windows Auth doesn't require credentials as it uses the current Windows user.

[@ashwinvp2163]

Can you make a video series for React or Angular?

[@CodeJava]

I will do in future. Currently I'm busy completing my course on Udemy: www.udemy.com/course/spring-boot-e-commerce-ultimate/?couponCode=PERFECT

[@shegyoo]

how do i find the url to my sql server

[@CodeJava]

check this answer: stackoverflow.com/questions/16088151/how-to-find-server-name-of-sql-server-management-studio

[@sabahalhasan4095]

thank you so much , this video really help me ... when I tried to edit the data this message appear "Cannot edit table. An unknown or unsupported data type encountered for column Template."

[@CodeJava]

that means Eclipse unable to edit the data due to unrecognized data type. In this case, you need to use SQL Management Studio directly.

[@sabahalhasan4095]

@@CodeJava you mean to create the table in eclipse directly ?

[@tartanclips2635]

Thank you so much for this. I was struggling to connect for a JPA project and my problem was that the Spring Boot connection string has \\sqlexpress where from the IDE it is a single \sqlexpress SAVED my bacon. Thanks again

[@CodeJava]

Glad it helped!

[@isaias8908]

thanks a lot friend!!!

[@CodeJava]

You're welcome!

[@daotuyentravel]

Anh người việt bảo sao em nghe rõ tiếng anh thế. anh có kênh tiếng việt không ạ.

[@CodeJava]

không em ạ. chỉ có kênh English này thôi.

[@nguynthhng1]

​@@CodeJava lần đầu nghe cũng đoán ra anh người Việt, accent không thể lẫn đi đâu được :))

[@swathisivakumar6394]

What is the password where can i find?

[@CodeJava]

it's the password you set when you install SQL Server (localhost). If it is a remove server, you need to ask your database admin.

[@Stranger-nu1jc]

What did you smoke

[@CodeJava]

why do you ask that?

[@d-daymkk6795]

em bị lỗi này ạ com.microsoft.sqlserver.jdbc.sqlserverexception: the driver could not establish a secure connection to sql server by using secure sockets layer (ssl) encryption

[@CodeJava]

maybe the JDBC driver version is outdated. Check and use the latest one.

[@tanloclai5111]

@@CodeJava i already use jdbc river 12.(the latest one) but still mess the same error like him. but when i add trustServerCertificate= true; in URL the error disappear, it not last long until reconnect. any helpful suggestion?