Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Ms SQL2005 remote connection problem

0 views
Skip to first unread message

Halim

unread,
Nov 18, 2009, 4:16:01 AM11/18/09
to
Hi,

I need help,
Im trying to connect MSSQL2005 database from a remote computer. Both system
using Windows xp. I have no problem connecting in the local laptop with
MSSQL2005 as local. But i get this error when trying to connect remotely:

"java.lang.classnotfoundexception
com.microsoft.sqlserver.jdbc.sqlserverdriver"

I have sqljdbc.jar and set the classpath:
classpath c:\program files\smcpl\btrek\lib\sqljdbc.jar in the remote computer

pls advise thanks

Regards,
Halim S

Rick Byham, MSFT

unread,
Nov 18, 2009, 11:50:49 AM11/18/09
to
I can't help you with Java but it may be that you don't have remote
connections enabled. See the Connecting from Another Computer in this short
tutorial: http://msdn.microsoft.com/en-us/library/ms345318(SQL.90).aspx
--
Rick Byham, MSFT
(Implies no warranty or rights)


"Halim" <Ha...@discussions.microsoft.com> wrote in message
news:A897FF8B-400E-46A7...@microsoft.com...

0 new messages