[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 658
  • Last Modified:

SQL connectivity problem

Hi,

I am trying to configure vCO and as part, i need to configure the Database ( SQL).

ODBC connectivity is successful, but when i am configuring the same using vCO, i am getting the below error

Cannot connect to jdbc:jtds:sqlserver://xx.xx.xx.xx:1433/vcodb;domain=mydc.com;useNTLMv2=true. Network error IOException:

Tried on windows Auth & SQL Auth, but results same.

I have admin privilege to SQL server and DBO permission on SQL db.  Conenctity is configured as TCP/IP for SQL

Please let me know if any permission changes required
0
kbjijo
Asked:
kbjijo
2 Solutions
 
AbhilashCommented:
Do not check NTLMv2
Check the database configuration part in this link
http://www.vspecialist.co.uk/configuring-vcenter-orchestrator/
0
 
SagiEDocCommented:
Go into the SQL Server Configuration manager, open the Network configuration node on the left and make sure TCP/IP is enabled. See attachment.
Capture.JPG
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now