Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connecting MS SQL Server 2008 from java code in Windows7

 
Ponnusamy Gov
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Rob Spoor
Sheriff
Pie
Posts: 20753
68
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you asking us how to specify the port in the connection string? If so, just add :53033 just after the host name.
 
Rob Spoor
Sheriff
Pie
Posts: 20753
68
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
dantaro hyedima,
Your post was moved to a new topic.
 
Ponnusamy Gov
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have posted as a Info only. Anyway Thanks...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic