Solved

SQL and VMWare

Posted on 2012-04-13
7
668 Views
Last Modified: 2012-04-14
SQL 2008 R2
Server 2008 R2

vCenter Server 4.1

I’m trying to get VMWare vCenter installed on my server. I have installed SQL and created a new database that I want to use for vCenter.

Under Database Options I select ‘Use and existing support database’.

I’ve tried to follow the directions in this article in order to set the connection up correctly:

http://www.techrepublic.com/blog/datacenter/installing-vmware-vcenter-prerequisites-on-windows-server-2008-r2/1791

1.      Select the System DSN tab.
2.      Click the Add button.
3.      On the first page of the Create New Data Source wizard, choose SQL Native Client.
4.      When prompted, provide a name and description of the new System DSN and indicate on which SQL Server the vCenter database resides.

When I select the dropdown list my system never finds my server so I type in the address 10.10.10.2.

5.      For my example, I’ve used SQL Server authentication. On the authentication page, choose the authentication method most appropriate for your use. If you use SQL Server authentication, use the same login ID and password that you created as per the VMware documentation.

Under login I use my administrator credentials (to make this as painless as possible.)

I’ve gone to the database in SQL and made sure the administrator is the dbowner.

6.      When prompted, test the data source to make sure it’s set up properly.
It fails with:

Connection failed:
SQL State: ‘08001’
SQL Server Error: 2
Could not open a connection to SQL Server [2]
SQL State: ‘HYT00’
SQL Server Error: 2
SQL Server Native Client 10.0 Login timeout expired.

Is this because I’m using the Admin account?
0
Comment
Question by:xmouser
  • 4
  • 2
7 Comments
 
LVL 119
ID: 37841742
turn firewall off?
0
 

Author Comment

by:xmouser
ID: 37841881
I'm running the install/setup from one machine. Firewall service is off. However, I turned it on and turn the firewall off.

Same error message.

Included that I didn't have on the original message is the line:

SQL Server Native Client 10.0 Named Pipes Provider:

However, I went in and enabled named pipes.
0
 
LVL 3

Expert Comment

by:Chris__W
ID: 37842966
Hello,

Is your SQL Server using the default instance?  \\[ip address]\[instance]

That it didn't find the server with the dropdown is annoying, but ours had the same issue there.  I would check to make sure the services for SQL Server are started, just to be sure.  

If it's truly a login named 'administrator', ensure that the credentials are consisted in scope (AD network administrator: [domain]\Administrator, sql account: administrator, local administrator: .\administrator).

Thanks,
Chris
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

Author Comment

by:xmouser
ID: 37843485
[domain]\Administrator - checked that

It's the administrative account for the box.

Defaul instance? No. I created a new instance (new database) called VMWareData to use.
0
 
LVL 3

Accepted Solution

by:
Chris__W earned 500 total points
ID: 37843623
Hello again,

So in the spot where it asks for the SQL Server you'll need to type in:
\\10.10.10.2\VMWareData


Also, to rule out authorizations, make the domain\admin account a sys admin on the sql server instance (not just dbo).  If I remember correctly, it want to create logins and other server objects and not just database objects.

Thanks,
Chris
0
 

Author Comment

by:xmouser
ID: 37843766
Hmm, makes sense. I'll try it in the morning. Thanks.
0
 

Author Comment

by:xmouser
ID: 37846058
Chris__W

Not quite correct but it pointed me in the right direction so that I was able to continue the install.

Thanks
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
should I enable deduplication in this case? 4 40
VCAP6-DCV Exam 11 66
SSRS 2012 r2 - Parm Drop Down has Date/Time 12 33
TSQL - How to declare table name 26 30
Last article we focus in how to VMware: How to create and use VMs TAGs – Part 1 so before follow this article and perform the next tasks, you should read the first article how to create the TAG before using them in Veeam Backup Jobs.
HOW TO: Upload an ISO image to a VMware datastore for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere Host Client, and checking its MD5 checksum signature is correct.  It's a good idea to compare checksums, because many installat…
Teach the user how to join ESXi hosts to Active Directory domains Open vSphere Client: Join ESXi host to AD domain: Verify ESXi computer account in AD: Configure permissions for domain user in ESXi: Test domain user login to ESXi host:
This video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…

777 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