Cannot create MSSQL server Datasource

[Former Member]

Hello,

What is meant by namedinstance???

My set up paramters details are as follows,

Name : XXDatasource

alias ; XXDBSOURCE

Object factory : com.microsoft.jdbcx.sqlserver.SQLServerDataSourceFactory

CPDS class name : com.microsoft.jdbcx.sqlserver.SQLServerDataSource

serverName : myServer

port :1433

databaseName: xxtest

user : sa

password : abcd

when i try to execute an sql statement in DB initialization tab, i keep getting the following error as below.....

java.rmi.RemoteException: com.sap.engine.services.ejb.exceptions.BaseRemoteException: Exception in method com.prospecta.wso.ejb.SSFHazardHomeImpl0.create(java.lang.String,java.lang.String,java.util.Date,java.util.Date,java.lang.String,java.lang.String,java.lang.String,java.util.Date,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.util.Date,java.util.Date,java.lang.String,java.lang.String,java.util.Date,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String).

at com.prospecta.wso.ejb.SSFHazardHomeImpl0.create(SSFHazardHomeImpl0.java:518)

at com.prospecta.wso.ejb.SSFHazardHomeImpl0p4_Skel.dispatch(SSFHazardHomeImpl0p4_Skel.java:383)

at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:294)

at com.sap.engine.services.rmi_p4.DispatchImpl._run(DispatchImpl.java:183)

at com.sap.engine.services.rmi_p4.server.P4SessionProcessor.request(P4SessionProcessor.java:119)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:37)

at com.sap.engine.core.cluster.impl6.session.UnorderedChannel$MessageRunner.run(UnorderedChannel.java:71)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:94)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:162)

Caused by: com.sap.engine.services.ejb.exceptions.BaseEJBException: Can not obtain a JDBC connection

at com.sap.engine.services.ejb.entity.pm.TransactionContext.simpleGetConnection(TransactionContext.java:198)

at com.sap.engine.services.ejb.entity.pm.TransactionContext.getLockingConnection(TransactionContext.java:175)

at com.sap.engine.services.ejb.entity.pm.lock.TableLockingSystem.write(TableLockingSystem.java:80)

at com.sap.engine.services.ejb.entity.pm.UpdatablePersistent.create(UpdatablePersistent.java:242)

Can someone please give complete information on configuring SQL server on Visual Administrator

[Former Member]

Managed to resolve the issue, if anyone have same problem please contact me at sudhakar.pantula@prospecta.com.au

[Former Member]

Hi,

create a new driver with the following jars.

1. msbase.jar

2. mssqlserver.jar

3. msutil.jar

Datasource parameters:

driver: com.microsoft.jdbc.sqlserver.SQLServerDriver

URL: jdbc:microsoft:sqlserver://<serverip>:1433;databaseName=<databasename>;selectMethod=cursor;

provide user credentials.

On 'Additional Tab' set SQL Option to 'Native SQL'.

Regards,

S.Divakar

[Former Member]

sorry for the late reply Divakar. But I get the same error