How do I configure the MS-SQLSERVER to accept JDBC connections and
process the sql?
I'm using SQLSERVER 2000 on Windows NT.

Thanks for your help

(soup_or_power@yahoo.com) writes:
> How do I configure the MS-SQLSERVER to accept JDBC connections and
> process the sql?
> I'm using SQLSERVER 2000 on Windows NT.

I don't know JDBC, but I can't see that there should be any particular
configuration needed for SQL Server to accept JDBC connections.

If you have connections problems, it helps if you give more details.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Erland Sommarskog wrote:

> (soup_or_power@yahoo.com) writes:
>
>>How do I configure the MS-SQLSERVER to accept JDBC connections and
>>process the sql?
>>I'm using SQLSERVER 2000 on Windows NT.
>
>
> I don't know JDBC, but I can't see that there should be any particular
> configuration needed for SQL Server to accept JDBC connections.
>
> If you have connections problems, it helps if you give more details.

The only possible issue is that the DBMS needs to accept 'mixed mode'
connection requests (TCP socket-level requests) for most JDBC drivers.
By default MS SQLServer is not configured in this way, but it is easily
done via the setup options.
HTH,
Joe Weinstein at BEA Systems