Sql2008 installed on two new WINDOWS2008 for cluster server, two IP server operating system operation were 10.44.6.1/10.44.6.2, cluster, the virtual IP is 10.44.6.3 SQLSERVER2008 after installation of IP is 10.44.6.16

Use SQL2008 client can connect to the server, but PB9 connected with the following statement:
The sqlca. DBMS='MSS Microsoft SQL Server 2008
The sqlca. Database='COC'
The Sqlca. Servername='10.44.6.16'
The sqlca. Userid='dbo
The sqlca. Dbpass='
The sqlca. Logid='sa'
The sqlca. Logpass="1 q2w3e!!!!! "
The sqlca. DBParm='

Run after the prompt: unable to connect, essentially unavailable or does not exist.

Consult everybody what reason be? Configuration is wrong is there?

CodePudding user response:

The SQLCA. DBMS="MSS Microsoft SQL Server"

MSS Microsoft SQL Server in a PB environment try to create a connection

CodePudding user response:

Upstairs is the solution, the SQLCA. DBMS="MSS Microsoft SQL Server
"

CodePudding user response:

Should do not support the SQLCA. DBMS="MSS Microsoft SQL Server
"Try to switch to the odbc, SNC

CodePudding user response:

Should not support the SQLCA. DBMS="MSS Microsoft SQL Server" maybe 2000, 2008 connections are not
Try to switch to the odbc, SNC

CodePudding user response:

The SQLCA. DBMS="MSS Microsoft SQL Server"

Pb9 direct-connect sql2008, 2005200

CodePudding user response:

The SQLCA. DBMS="MSS Microsoft SQL Server"

Nor even,

In 2008 single SQL, SQL IP and OS IP is consistent, can be connected,