Forums Register Login

Connecting MS SQL Server 2008 from java code in Windows7

+Pie Number of slices to send: Send
In Windows 7, I have tried from java to connect MS SQL 2008 server using jtds jar. I am having 2005 also in my machine. Here I was not able to connect 2008 server since 1433 port was assigned to 2005. So I have changed the port in my application to the port which is mentioned in SQL Server Configuration Manager ->SQL Server Network Configuration ->Protocols-> TCP/IP properties -> IP Addresses -> IP All(53033). It is connected!!!

Pons
+Pie Number of slices to send: Send
Are you asking us how to specify the port in the connection string? If so, just add :53033 just after the host name.
+Pie Number of slices to send: Send
dantaro hyedima,
Your post was moved to a new topic.
+Pie Number of slices to send: Send
I have posted as a Info only. Anyway Thanks...
Attractive, successful people love this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1284 times.
Similar Threads
JDBC version not supported error
SQLServerException: TCP/IP connection to the host has failed.
Not able to connect to MS SQL 2005 Evaluation version
Need to know Sql version.
a q about SQL Server 2005 DB and Java
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 00:07:15.