Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Course Of The Month
8 days, 3 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SQL and VMWare
Posted on 2012-04-13
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?
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?
[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
-
4
2
7 Comments
Active 2 days ago
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.
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.
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
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
Active 2 days ago
[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.
It's the administrative account for the box.
Defaul instance? No. I created a new instance (new database) called VMWareData to use.
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
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
Featured Post
Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
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 easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month8 days, 3 hours left to enroll
617 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.