maybe you need to enable TCP for SQL server. Reference: www.ibm.com/docs/en/sss/3.1.1?topic=install-enabling-sql-server-express-communication-over-tcpip
Hello! I am getting this error: Cannot establish a connection to jdbc:sqlserver://{Host Name}\{Instance Name};databaseName=Sample using com.microsoft.sqlserver.jdbc.SQLServerDriver (Login failed for user 'user'. ClientConnectionId:{ID}). I'm new to MS SQL, what should I do? Thanks
Hello I'm getting this error "Timeout expired. IDE unable to establish connection. Check your proxy settings or try again later. The server may be unavailable at the moment. You may also want to make sure that your firewall is not blocking network traffic."
so you need to specify JDBC URL with SQL authentication. See this article for more details: www.codejava.net/java-se/jdbc/connect-to-microsoft-sql-server-via-jdbc
@@CodeJava quầy, đồng hương bác ơi! Em đang bị gặp lỗi trong trường hợp này, bác có thể hộ trợ em với được không ạ, em thử két nối bằng tay cũng như dùng công cụ cũng không được ạ
Sir I getting such type of message Cannot establish a connection to jdbc:sqlserver://sqlsrv\sqlexpress;database name=EMS using com. Microsoft. sqlserver
I think you must also explain where do we get the values Host, Database and Instance Name 4:42
you're right. I forgot. Thanks for your valuable suggestion.
I am getting error that TCP/IP connection to the host location failed
Port is open in firewall and SQL is running
maybe you need to enable TCP for SQL server. Reference: www.ibm.com/docs/en/sss/3.1.1?topic=install-enabling-sql-server-express-communication-over-tcpip
@@CodeJava I figured it out. SQL Server Browser was turned off
@@asapaska1 great to hear that :)
Hello! I am getting this error: Cannot establish a connection to jdbc:sqlserver://{Host Name}\{Instance Name};databaseName=Sample using com.microsoft.sqlserver.jdbc.SQLServerDriver (Login failed for user 'user'. ClientConnectionId:{ID}). I'm new to MS SQL, what should I do? Thanks
I have the same problem now
Hello I'm getting this error "Timeout expired. IDE unable to establish connection. Check your proxy settings or try again later. The server may be unavailable at the moment. You may also want to make sure that your firewall is not blocking network traffic."
did you fix it ?
@Code Java
I want to connect to a database Sql Server .
Located on a server on a local network
Not on an localhost
how do I write ??
so you need to specify JDBC URL with SQL authentication. See this article for more details: www.codejava.net/java-se/jdbc/connect-to-microsoft-sql-server-via-jdbc
@@CodeJava Thanks
I connect my SQL server to (local) host. How to do it?
did you follow the steps explained in this video?
Are you Vietnamese?
Yes, I am.
@@CodeJava quầy, đồng hương bác ơi! Em đang bị gặp lỗi trong trường hợp này, bác có thể hộ trợ em với được không ạ, em thử két nối bằng tay cũng như dùng công cụ cũng không được ạ
@@tamhoangminh197 bác fix đc chưa em cũng bị lỗi :((
@@K1ethoang chọn đúng ver driver phù hợp với ver của SQL bác
@@tamhoangminh197 được rồi nè :) oimeoi em định cài lại win :))
Create tutorial on read PDF using java
I will consider. Could you give some example use cases?
@@CodeJava just read values from the pdf file using any java API.. And print those values in the console
@@ilavarasansriraman4140 okay, noted.
Do we guess the SA user password ?
No, it's the password you set when installing SQL server.
Sir I getting such type of message
Cannot establish a connection to jdbc:sqlserver://sqlsrv\sqlexpress;database name=EMS using com. Microsoft. sqlserver
is the SQL server running?
@@CodeJava yeah it's running I created database too but cannot establish connect in windows authentication