Make sure that TCPĬonnections to the port are not blocked by a firewall.'.Īs you said, your protocol (TCP) is disable, so let activate it with some code :) Sure that an instance of SQL Server is running on the host andĪccepting TCP/IP connections at the port. The TCP/IP connection to the host WALSER, port 1433 has failed.

String connectionUrl = 'jdbc:sqlserver://WALSER:1433 databaseName=MYSQLDATABASE user=walser/kyle password=brenna1020 ' Ĭonnection con = DriverManager.getConnection(connectionUrl) I have also tried this way as well but kept getting a time out error: Class.forName('.SQLServerDriver') Public static void main(String args) throws SQLExceptionĬlass.forName('') Ĭonnection con = DriverManager.getConnection('jdbc:odbc:movie_archive_DSN') ĭata source name not found and no default driver specifiedĬan anyone offer advice on how to fix this error? Also tcp/ip is enabled and port set to 1433. I'm using driver for the connections and have created my dsn through the admin tools and this is the code I'm using: import java.sql.*

I'm having some issues with the connection with Java and SQL 2008 Express.

Sun jdbc odbc jdbcodbcdriver jar