Welcome to AggreGate Community

Need to connect MSSQL

Various questions that are not directly related to AggreGate Platform technology and AggreGate-based box products.

Need to connect MSSQL

Postby venubv/gmail_com » Thu Dec 14, 2017 9:48 am

Syntax provided in Aggregate = jdbc:sqlserver://host\instanceName[:port]

I am giving below syntax, which throwing an error in configuration. please help on the same.

jdbc:sqlserver://SMARTCAMPUS-HP\SQLEXPRESS\aggregate:1433

Details given below :
Server name : SMARTCAMPUS-HP\SQLEXPRESS
Database ; aggregate
port : 1433
venubv/gmail_com
 
Posts: 1
Joined: Thu Dec 14, 2017 9:40 am

Re: Need to connect MSSQL

Postby sergey_eritsyan/tibbo_com » Fri Dec 14, 2018 2:19 pm

Hi!

You need to use DNS name not PC name. Also, you can use an IP address.

Example :

jdbc:jtds:sqlserver://192.168.0.1:1433

jdbc:jtds:sqlserver://DBServer.com:1433
sergey_eritsyan/tibbo_com
 
Posts: 100
Joined: Fri Jul 07, 2017 10:42 am


Return to Other Questions

Who is online

Users browsing this forum: No registered users and 1 guest