zehs_sha
دوشنبه 07 آذر 1390, 21:04 عصر
در ارتباط بین سرور و کلاینت فایروال خاموش است ولی پیغام زیر در هنگام باز کردن دیتابیس می دهد و sqljdbc4 جهت کانکشن با دیتا بیس استفاده شده است
String connectionUrl =
"jdbc:sqlserver://192.168.1.100/sanad;databaseName=SERP;user=zarrin;password=123;";
error:
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection
to the host 192.168.1.100/sanad, 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.".
at com.microsoft.sqlserver.jdbc.SQLServerException.ma keFromDriverError(SQLServerException.java:171)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.c onnectHelper(SQLServerConnection.java:1033)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.l ogin(SQLServerConnection.java:817)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.c onnect(SQLServerConnection.java:700)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.conne ct(SQLServerDriver.java:842)
String connectionUrl =
"jdbc:sqlserver://192.168.1.100/sanad;databaseName=SERP;user=zarrin;password=123;";
error:
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection
to the host 192.168.1.100/sanad, 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.".
at com.microsoft.sqlserver.jdbc.SQLServerException.ma keFromDriverError(SQLServerException.java:171)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.c onnectHelper(SQLServerConnection.java:1033)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.l ogin(SQLServerConnection.java:817)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.c onnect(SQLServerConnection.java:700)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.conne ct(SQLServerDriver.java:842)