cancel
Showing results for 
Search instead for 
Did you mean: 

Error in connection

Former Member
0 Kudos

I have to check if drivers of sql are properly inserted in the PI system.

I created a receiver cc and tried to connect to the databse by creating a external definition.

I tried to import metadata and I got exception cannot establish connection with this driver. I am using mssql

connection parameters are

com.microsoft.jdbc.sqlserver.SQLServerDriver

jdbc:Microsoft:sqlserver://IPaddress:port;databaseName=<tablename>

are they correct?

how do I check telnet in SM69 ? Can tell me how?

Regards

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Midhun,

The Database name in the connection URL will be the schema name of the database that you are connecting to; and these are case sensitive. Also, the IP address can be replace by the fully qualified host name of the database server. Make sure that the host name is defined on the DNS of your organization.

Regards,

Alka.

Former Member
0 Kudos

The IP Address should be defined in the local machine on which I am working or the PI server or both?

Former Member
0 Kudos

Hi Midhun,

PI Server should have the IP and host name entry.

Regards,

Alka.

suman_saha
Contributor
0 Kudos

How do you connect to the database from your local system?

You may use the same server name you use to connect to MS SQL server management studio or so. The host name may define in your PI server inside /etc/host file. You may follow the link https://library.netapp.com/ecmdocs/ECMP1368834/html/GUID-CD7BDEA3-6754-4128-A260-CF05624F1772.html

Former Member
0 Kudos

Hi Alka

I get this error login failed for user.

the database people said they are able to login to the databse using user id and password

any suggestions plz

Former Member
0 Kudos

Hi Midhun,

Verify your connection URL with the database team.

As mentioned previously, in the connection URL, database name will be the DBSchema name and not the table name.

Other points that you can check with your DB team is concurrent logins permission and also Select and modify permissions to be given to the user with which you are trying to connect.

Regards,

Alka Panday.

Former Member
0 Kudos

IP address and Port are correct I assume

So I should get the DBschema name? It's different from the db name?

I am not giving any table nane

Former Member
0 Kudos

Hi Midhun,

DB name and DB schema name are same references.

Regards,

Alka Panday

Answers (3)

Answers (3)

Former Member
0 Kudos

The problem with the database name. Once they corrected it, al worked

suman_saha
Contributor
0 Kudos

Hi,

The connection parameters to connect to MS SQL should be:

com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc:sqlserver:://IPaddress:port;databaseName=<tablename>

Suman

Former Member
0 Kudos

Is there anything else that we can replace the IP address with?

Are the databse names case sensistive?

Will not the database sever have an address that ends in .com? Can I use it instead of IP?

suman_saha
Contributor
0 Kudos

Yes sure. You can use jdbc:sqlserver:://servername:port;databaseName=<tablename>

suman_saha
Contributor
0 Kudos

Hi,

You may follow the link to check telnet from PI

Suman