Setting up ODBC for View 5 inside vCenter 5

 

Let’s do a quick recap of what we’ve done so far. 

• 1st – we’ve installed Windows SQL 2008 R2 inside a Windows 2008 R2 server.
• 2nd – we’ve setup the VMware View 5 Database inside that SQL Server

The next step of the View install is to go to vCenter and install VMware View Composer.  The first step of that process is to create the ODBC connection to our newly installed SQL 2008 R2 instance. This will be the first time we see if our SQL 2008 R2 server went in without any problems because if it didn’t, we’ll see it below.  SPOILER ALERT 🙂

1. Remote console into your vCenter 5 VM and then click on Start, Programs, Admin Tools, ODBC

2. Click on System DSN and then click Add

 

3. You will be adding a SQL Server Native Client 10.0

4. Fill in all the Database info we created from this blog post:

5. Then enter the user account info we created in that last blog post as well as the password – Click next:

 

5b – if you ran into the following error message:

• Connection Failed:
• SQLState: ‘08001’
• SQL Server Error: 5
• [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider
• Could no open a connect to SQL Server [S]
• Connection Failed:
• SQLStateL ‘HYT00″
• SQL Server Error: 0
• Login Timeout Expired

If you ran into this issue, click over to “Troubleshooting View 5 ODBC Connection Errors”

Hopefully you didn’t run into this error so let’s just keep moving on.

6. Select the VMwareView5 Database from the drop down menu

7. Let’s test everything and see if it works

8. Perfect – let’s move on to the next step.

 

Now on to install VMware View Composer on the vCenter 5 server.

 

@vTexan