Test-Connection Errors in B1iF-SLD (Multiple SQL-Instances)

[Former Member]

Hello Community

First of all i describe my situation:

My company has a fully functional SAP Business One 8.81 PL11 installation. Additionally we installed the Integration Framework (v. 1.10) to this Business One installation.

We d'like to work with it, but if i try to access the companies out of B1iF i allways got errors

Now, how does our environment looks like?

Basicly everything is installed on the same physically server!

Our Business One-Environment:

B1-Server: MyServer

Licence-Server: MyServer:30000

Our SQL-Environment:

MS SQL Server 2008 -> MyServer/MSSQL (default instance) = Company Databases

MS SQL Server 2008 R2 -> MyServer/MSSQLTEST (second instance) = Test Databases

Both on the same server!

Our B1iF-Installation:

Installation: MyServer

SQL Server: B1iF database is located in the default instance

How does my SLD looks like?

System: MyCompany

Key	Value
b1Server	MyServer
licenseServer	MyServer:30000
company	MyCompany
dbType	Microsoft SQL Server 2008
dbUser	sa
dbPassword	sa12345
userName	B1i
password	b1if
language	German
isTrust	false
jcoPath	C:\Program Files (x86)\SAP\SAP Business One DI API\JCO\LIB
diProxyhost	MyServer
diProxyport	2099
proxyHost	-
proxyPort	-

Key	Value
driver	com.microsoft.sqlserver.jdbc.SQLServerDriver
url	jdbc:sqlserver://MyServer:1433;databaseName=MyCompany;
username	sa
password	sa12345

Result: WORKS

System: SBODemoCH

Key	Value
b1Server	MyServer
licenseServer	MyServer:30000
company	SBODemoCH
dbType	Microsoft SQL Server 2008
dbUser	sa
dbPassword	sa12345
userName	B1i
password	b1if
language	German
isTrust	false
jcoPath	C:\Program Files (x86)\SAP\SAP Business One DI API\JCO\LIB
diProxyhost	MyServer
diProxyport	2099
proxyHost	-
proxyPort	-

Key	Value
driver	com.microsoft.sqlserver.jdbc.SQLServerDriver
url	jdbc:sqlserver://MyServer:1433;instanceName=MSSQLTEST;databaseName=SBODemoCH;
username	sa
password	sa12345

Result: FAILED

Now i am confused. Here, i got these errors

Business One DI Connection-Test

com.sap.b1i.adapter.dia.exception.ConnectionFailedException: Connect to Business One failed.

(-111) Unable to access SBO-Common database

{b1Server=MyServer/MSSQLTEST, company=SBODemoCH, licenseServer=MyServer:30000, dbType=6, dbUser=sa, userName=B1i}

JDBC Connection-Test

com.sap.b1i.xcellerator.XcelleratorException: XCE001 Nested exception: java.lang.Exception: com.sap.b1i.xcellerator.XcelleratorException: XCE001 Nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "SBODemoCH" requested by the login. The login failed.

The first error is cause it does not find a SBO-Common database but there is one :S Hmmm...?`

The second error is cause it can't login.. but the credentials are correct!

Does someone else also works with different sql-instances?

Does someone know something that could help me?

Thanks for helping me!

[Former Member · Accepted solution]

I found somthing that helped me! Check out this article on msdn

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

If the SQL Server Browser service is running, you don't need to specify the port.

SQL Server allows for the installation of multiple database instances per server. Each instance is identified by a specific name. To connect to a named instance of SQL Server, you can either specify the port number of the named instance (preferred), or you can specify the instance name as a JDBC URL property or a datasource property. If no instance name or port number property is specified, a connection to the default instance is created. See the following examples:

To use a port number, do the following:

jdbc:sqlserver://localhost:1433;integratedSecurity=true;<more properties as required>;

To use a JDBC URL property, do the following:

jdbc:sqlserver://localhost;instanceName=instance1;integratedSecurity=true;<more properties as required>;

http://msdn.microsoft.com/en-us/library/ms378428.aspx

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I simply removed the database port of my JDBC Connection-URL and the JDBC connection works nicely

Additionally to work with the b1 company i had to change the b1Server value to MyServer\MSSQLTEST and it also worked !