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?