Question Re: Connecting to SQL Server - xMII 12 in Product Lifecycle Management Q&A

Connecting to SQL Server - xMII 12

Former Member — Fri, 11 Jan 2008 19:16:12 GMT

Hello,

I' m trying to connect to the SQL server from xMII 12.0. The status is showing as error. I was able succesfully upload the "sqljdbc.jar" JDBC driver successfully.

Re: Connecting to SQL Server - xMII 12

erik_schrampf — Fri, 11 Jan 2008 19:28:33 GMT

Sunada,

I think everyone needs a little more information than that. What do the logs say there will be an error showing there (search the forum for how to look at the logs in 12.0 there are many out there). Is your username and password entered corretly, are you able to ping the box with SQL server? What version of SQL server are you connecting to? Are you using the correct port?

Erik

Re: Connecting to SQL Server - xMII 12

HariCS23 — Tue, 15 Jan 2008 05:08:04 GMT

What version of SQL you are using??

Please make sure the jdbc driver parameter

For SQL server 2005 - com.microsoft.sqlserver.jdbc.SQLServerDriver

server url : server://<ip>;1433;instance=SQL2005;database = <dbname>

Thanks

Vansi

Re: Connecting to SQL Server - xMII 12

Former Member — Tue, 15 Jan 2008 15:40:28 GMT

Thanks for all responses. I' m using SQL SERVER 2005. Here is my error log.

"Unable to create connection pool for funal2: com.sap.xmii.Illuminator.logging.LHException:java.lang.Classnotfoundexception: com.inet.tds.TdsDriver".

I uploaded the JDBC driver. May be this is giving problem.

Re: Connecting to SQL Server - xMII 12

Former Member — Tue, 15 Jan 2008 15:55:40 GMT

When you say uploaded - it means Deployed , right? What does the status of the JDBC driver reads?It should read "Deployed"

Re: Connecting to SQL Server - xMII 12

jamie_cawley — Tue, 15 Jan 2008 15:58:59 GMT

You need to modify the JDBCDriver of the data server.

It should be

com.microsoft.sqlserver.jdbc.SQLServerDriver

com.inet.tds.TdsDriver

is the path to the 2000 JDBCDriver.

Regards,

Jamie

Re: Connecting to SQL Server - xMII 12

Former Member — Tue, 15 Jan 2008 21:16:46 GMT

I deployed the JDBC driver, downloaded from the Microsoft web site.

JDBCDriver: com.microsoft.sqlserver.jdbc.SQLServerDriver

Server path : server://172.31.64.64:1033:instance=SQL2005?database=Legacy

I' m getting the following error.

Fatal error while filling connection pool for server://172.31.64.64:1033:instance=SQL2005?database=Legacy

[EXCEPTION]

java.sql.SQLException: No suitable driver

at java.sql.DriverManager.getConnection(DriverManager.java:532)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at com.sap.xmii.Illuminator.tools.database.ConnectionPool.createConnectionObject(ConnectionPool.java:322)

at com.sap.xmii.Illuminator.tools.database.ConnectionPool.fill(ConnectionPool.java:266)

at com.sap.xmii.Illuminator.tools.database.ConnectionPool.initialize(ConnectionPool.java:131)

at com.sap.xmii.Illuminator.tools.database.ConnectionPool.<init>(ConnectionPool.java:41)

at com.sap.xmii.Illuminator.tools.database.ConnectionHolder.addDBConnectionPool(ConnectionHolder.java:121)

at com.sap.xmii.Illuminator.server.Server.createHolder(Server.java:266)

at com.sap.xmii.Illuminator.server.Server.access$300(Server.java:20)

Because of this I' m not able to connect. I' m getting the following error.

Unable to create connection pool for Final2: com.sap.xmii.Illuminator.logging.LHException: Fatal error has occurred while filling connection pool for server://172.31.64.64:1033:instance=SQL2005?database=Legacy

Please suggest me how to correct this.

Thank you

Sunanda kambham

717-756-4852

Edited by: Sunanda kambham on Jan 15, 2008 10:19 PM

Re: Connecting to SQL Server - xMII 12

jamie_cawley — Tue, 15 Jan 2008 22:31:33 GMT

Depending on how sql server is set up the serverurl could be something like

jdbc:sqlserver://localhost\SQLEXPRESS:1433;database=YourDB

jdbc:sqlserver://localhost:1433;database=YourDB

By default sql server 2005 does not have tcp/ip connections enabled.

Regards,

Jamie

Re: Connecting to SQL Server - xMII 12

jcgood25 — Wed, 16 Jan 2008 03:41:35 GMT

Sunny,

Assuming that you have accurately uploaded and deployed the jar file properly, the 'No Suitable Driver' error message normally indicates you have a mismatch between the jar file and the JDBCDriver setting.

If you open a copy of the jar file you deployed using WinZip or WinRAR do you see a file called SQLServerDriver.class located in the nested path of com\microsoft\sqlserver\jdbc\ ? This path and the file name is case sensitive too.

Problems with the connection string should only produce errors like 'Connection Refused' or 'Host Unavailable', not a driver error.

Regards,

Jeremy

Re: Connecting to SQL Server - xMII 12

Former Member — Wed, 16 Jan 2008 17:33:04 GMT

I created the data server as explained in the previous step. I uploaded and deployed the SQLJDBC.JAR file.

Data server status is showing as pending. In the log there is a warning message "Unable to detemermine maximum number of connections from JDBC driver".

Look's like I'm getting close. Appreciate your help.

Re: Connecting to SQL Server - xMII 12

Former Member — Mon, 20 Oct 2008 21:18:59 GMT

Hi,

I am in a similar situtation. The error message is:

Unable to create connection pool for MID: com.sap.xmii.Illuminator.logging.LHException: Fatal error has occurred while filling connection pool for server://localhost:1433?database=MID

I am unsure where to go from here. I have tried a local database and a remote database and I get the same error message.

Any help would be appreciated.

Thanks

Casey

Re: Connecting to SQL Server - xMII 12

former_member192939 — Mon, 20 Oct 2008 23:41:11 GMT

Casey

Check for the firewall rule

Regards,

Ajay.

Re: Connecting to SQL Server - xMII 12

Former Member — Tue, 21 Oct 2008 03:01:43 GMT

Yes, both the Netweaver Server and Database Server firewalls are off.

I have counfirmed TCP/IP connectivity with telnet on port 1433. But the problem remains

Thanks,

Casey

Re: Connecting to SQL Server - xMII 12

erik_schrampf — Tue, 21 Oct 2008 14:58:07 GMT

Casey,

Take a look at note 990322 looks like your server URL is not set up correctly. Try one of the following:

1. jdbc:sqlserver://localhost:1433;database=Northwind

2. jdbc:sqlserver://localhost;instanceName=instance;portName=1433;database=Northwind

Erik

Re: Connecting to SQL Server - xMII 12

Former Member — Tue, 21 Oct 2008 15:14:25 GMT

Hi Erik,

Yes, in one of many iterations, I tried the url as you specified both to a local and a remote database (both Default Instances). For my situation, it does not seem to make any difference. (one of the other forum threads I found with similar connection problems, suggested the url as specified in the error message.

regards,

Casey

Re: Connecting to SQL Server - xMII 12

Former Member — Tue, 21 Oct 2008 16:29:44 GMT

Try restarting your Netweaver instances and good luck

Re: Connecting to SQL Server - xMII 12

Former Member — Tue, 21 Oct 2008 19:34:13 GMT

Thanks Pramod,

it never hurts to reboot and I reverted to Erik's url suggestion but I still get:

Unable to create connection pool for MID: com.sap.xmii.Illuminator.logging.LHException: Fatal error has occurred while filling connection pool for jdbc:sqlserver://localhost:1433?database=MID

Any other ideas?

Casey

Re: Connecting to SQL Server - xMII 12

erik_schrampf — Wed, 22 Oct 2008 14:10:47 GMT

Casey,

Can you copy your connection information into the message. The easiest way to do this would be to copy and paste your Summary screen for the Data Server you are having problems with. Also by default 2005 has tcp/ip turned off. It also has dynamic ports turned on. You'll need to have tcp/ip turned on and dynamic ports turned off.

Re: Connecting to SQL Server - xMII 12

Former Member — Wed, 22 Oct 2008 17:22:48 GMT

Hi Erik,

The following data is a summary for a local default instance of MSSQL 2005 (Installed as part of NW 70 Install - via SQL4SAP.vbs)

Name Value

Connector IDBC

ConnectorID

ConnectorType SQL

DatePrefix '

DateSuffix '

DaysRetention 7

Description ---

Enabled T

InitCommand

InternalDateFormat yyyy-MM-dd HH:mm:ss

JDBCDriver com.microsoft.sqlserver.jdbc.SQLServerDriver

MaxRetryCount 5

Name MID

PoolMax 100

PoolSize 1

RetryInterval 60000

ServerPackage com.sap.xmii.Illuminator.connectors.IDBC

ServerURL jdbc:sqlserver://localhost:1433?database=MID

Timeout 15

UseCount 256

UserName sa

ValidationQuery SELECT GETDATE()

WaitTime 30

Does this show any discrepancies?

Thanks,

Casey

Re: Connecting to SQL Server - xMII 12

Former Member — Thu, 23 Oct 2008 13:09:49 GMT

Hi Erik,

I reverted to Una2000.jar as per your suggestion and this has solved my problem - I am now connected to my databases.

Is there a reason to pursue the issue with sqljdbc.jar?

Thanks,

Casey