VMware Cloud Community
mldmld
Enthusiast
Enthusiast

Vmware update manager : new DB and DSN entry

Hi all,

I've sucessfully installed Virtual Center 4 over a SQL Server 2005 64 bits on a Windows 2008 enterprise VM.

I added an 32 bits DSN for vCenter to access the database VCDB and it seems to work.

Now, I plan to install Update Manager on the same server.

I'm totaly newbie on SQL server 2005

I created a database using this script (I almost cut/paste the script to create de VCDB database for vCenter) See below.

Now, I have to create the DSN to allow access to this database :

This DSN can be 64 bits ? Or only 32 bits, as on vCenter ?

The documentation seems to say it can run on 64 bits DSN. But I would like to be sure.

By the way, I'm not sure that creating a new DB on the same SQL Server installation is usefull.

Thanks

Best regards

ML

-


h6. use

go
h6. CREATE DATABASE ON PRIMARY
h6. (NAME = N'vcupdatedb', FILENAME = N'E:\VCUPDATEDB\VCUPDATEDB.mdf'
+ , SIZE = 4000KB , FILEGROWTH = 10% )+
h6. LOG ON
h6. (NAME = N'vcupdatedb_log', FILENAME = N'E:\VCUPDATEDB\VCUPDATEDB.ldf'
+ , SIZE = 2000KB , FILEGROWTH = 10%)+
h6. COLLATE SQL_Latin1_General_CP1_CI_AS
h6. go
h6. use VCDB
h6. go
h6. sp_addlogin @loginame=[vpxuserupdate], @passwd=N'xxxxx',
+ @defdb='VCUPDATEDB', @deflanguage='us_english'+
h6. go
h6. ALTER LOGIN WITH CHECK_POLICY = OFF
h6. go
h6. CREATE USER for LOGIN
h6. go
h6. sp_addrolemember @rolename = 'db_owner', @membername =
+ 'vpxuserupdate'+
h6. go
h6. use MSDB
h6. go
h6. CREATE USER for LOGIN
h6. go
h6. sp_addrolemember @rolename = 'db_owner', @membername =
+ 'vpxuserupdate'+
h6. go

Reply
0 Kudos
6 Replies
RParker
Immortal
Immortal

By the way, I'm not sure that creating a new DB on the same SQL Server installation is usefull.

Not only useful, but that's the way SQL works, you can have hundreds thousands of tables on the SAME SQL database. The database is just a manager, and instance. SQL supports 2TB of RAM, 64 Cores and as much disk space as you can throw at it, all with a single install. Then you can have MULTIPLE installs of SQL on the same piece of hardware, so yes SQL is not only 'useful' but this is ideal.

Also UM is a 32-bit program, so that's why the 32-bit DSN requirement.

And for future referrence you should not do ANYTHING with these tables. Follow the admin guide, add appropriate permissions for the master table, create the UM table (call it whatever you want). That's it.

Point the UM to that table via the DSN, it will take it from there. There is no 'pre' work that's needs to be done.

Reply
0 Kudos
mldmld
Enthusiast
Enthusiast

If you are right, that means there is a mistake in the documentation.

In the VMware vCenter Update Manager Administration Guide, it is said, page 25 :

On your Update Manager server system, select Start > Settings > Control Panel > Administrative Tools >
Data Sources (ODBC).
2 Click the System DSN tab.
3 Create or modify an ODBC system data source.

But to create a 32 bits DSN on a 64 bits system, one must use C:\Windows\SysWOW64\Odbcad32.exe as it is said page 72 of the ESX and vCenter Server Installation Guide

Even though vCenter Server is supported on 64-bit operating systems, the vCenter Server system must have a 32-bit DSN. This requirement applies to all supported databases. By default, any DSN created on a 64-bit system is 64 bit.
Procedure
1 Install the ODBC drivers.
n For Microsoft SQL Server database servers, install the 64-bit database ODBC drivers on your Microsoft
Windows system. When you install the 64-bit drivers, the 32-bit drivers are installed automatically.
n For Oracle database servers, install the 32-bit database ODBC drivers on your Microsoft Windows
system.
NOTE The default install location on 64-bit operating systems is C:\VMware.
2 Run the 32-bit ODBC Administrator application, located at \SysWOW64\odbcad32.exe.
3 Use the application to create your DSN.
You now have a DSN that is compatible with vCenter Server. When the vCenter Server installer prompts you
for a DSN, select the 32-bit DSN.

ML

Reply
0 Kudos
RParker
Immortal
Immortal

Uh..yeah, but where does it say to run a script and that other stuff you did?

Plus you answered your own question about 32-bit DSN.

"Even though vCenter Server is supported on 64-bit operating systems, the vCenter Server system must have a 32-bit DSN. This requirement applies to all supported databases."

Reply
0 Kudos
mldmld
Enthusiast
Enthusiast

No, I did not answer my question myself ! :smileyblush:

My question is related to Vmware update manager. Not vCenter.

It's clear that vCenter need of a 32 bits DSN.

But it seems Vmware update manager can use a 64 bits DSN, but I would like to be sure.

And the script is my idea to create a different DB on the same SQL server. Because it is said that it's better to use a different DB for VCenter and Update manager

ML

Reply
0 Kudos
mldmld
Enthusiast
Enthusiast

All,

I tried to install according the documentation, so installing a 64 bits DSN. This DSN is not visible during the setup of Update Manager.

I create a 32 bits DSN , and it's visible. So the DSN must be 32 bits !

So there is a little omission in the documentation

Then I successfully update an ESX host.

ML

Reply
0 Kudos
Texiwill
Leadership
Leadership

Hello,

Moved to Update Manager forum


Best regards,

Edward L. Haletky VMware Communities User Moderator, VMware vExpert 2009, Virtualization Practice Analyst[/url]
Now Available: 'VMware vSphere(TM) and Virtual Infrastructure Security: Securing the Virtual Environment'[/url]
Also available 'VMWare ESX Server in the Enterprise'[/url]
[url=http://www.astroarch.com/wiki/index.php/Blog_Roll]SearchVMware Pro[/url]|Blue Gears[/url]|Top Virtualization Security Links[/url]|Virtualization Security Round Table Podcast[/url]

--
Edward L. Haletky
vExpert XIV: 2009-2023,
VMTN Community Moderator
vSphere Upgrade Saga: https://www.astroarch.com/blogs
GitHub Repo: https://github.com/Texiwill
Reply
0 Kudos