Страница 1 из 1

Need to connect MSSQL

СообщениеДобавлено: Чт дек 14, 2017 9:48 am
venubv/gmail_com
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

Re: Need to connect MSSQL

СообщениеДобавлено: Пт дек 14, 2018 2:19 pm
sergey_eritsyan/tibbo_com
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