Skip to Content
0
Former Member
Aug 06, 2006 at 01:14 PM

NW04s JDBC Connection for MSSQL not working

54 Views

In portal JDBC settings are:

Connection properties

-


URL = jdbc:microsoft:sqlserver://192.168.0.101:1433;DatabaseName=Northwind

Driver = com.microsoft.jdbc.sqlserver.SqlServerDriver

User Management

-


User mapping type = admin,user

I assigned a user to Administrator under User Administration

Visual Administrator settings are:

-


DriverName = com.microsoft.jdbc.sqlserver.SqlServerDriver

URL = jdbc:microsoft:sqlserver://192.168.0.101:1433;DatabaseName=Northwind

UserName = empty

Password = empty

Result

-


Connection test fails in portal. The settings appear ok.

The only thing I can think of is that user specified in portal user mapping is not setup properly on SQLServer.

Also:

When I run link:

http://localhost:53000/TestJDBC_Web/TestJDBCPage.jsp

my jdbc service MSSQL_JDBC does not appear. MSSQL_JDBC was cloned from SDK_JDBC and the libray for drivers was added

I am running MSSQL 2000 SP4 but using JDBC drivers for SP3 as I didn't find any for SP4 and assumed they would work for SP4

What am I missing?