[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

SQL connectivity problem

Posted on 2014-02-04
2
Medium Priority
?
655 Views
Last Modified: 2014-02-22
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
Comment
Question by:kbjijo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 13

Assisted Solution

by:Abhilash
Abhilash earned 1000 total points
ID: 39833305
Do not check NTLMv2
Check the database configuration part in this link
http://www.vspecialist.co.uk/configuring-vcenter-orchestrator/
0
 
LVL 13

Accepted Solution

by:
SagiEDoc earned 1000 total points
ID: 39834950
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

What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question