Hi,

I am unable to get VirtualCenter 2.0.2 Build 50618 to connect to a remote SQL 2005 SP2 database. I am using a SQL account for authentication.

The SQL server is Windows 2003 Standard SP2 and the VC server is Windows 2003 R2 Standard SP2. Both servers are running the latest MS security fixes.

I am not using the Native SQL Client - I know that is not supported...

When I run the VC server service interactively, I get the following output:

[code][2007-09-06 16:46:04.221 'App' 3184 info] Current working directory: C:\Program Files\VMware\VMware VirtualCenter 2.0
[2007-09-06 16:46:04.221 'App' 3184 info] Initializing SSL context
[2007-09-06 16:46:04.565 'App' 3184 info] Vmacore::InitSSL: doVersionCheck = true, handshakeTimeoutUs = 120000000
[2007-09-06 16:46:04.565 'BaseLibs' 3184 info] NFC connection accept timeout: 180000 milliseconds

[2007-09-06 16:46:04.565 'BaseLibs' 3184 info] NFC request timeout: 180000 milliseconds

[2007-09-06 16:46:04.565 'BaseLibs' 3184 info] NFC read timeout: 60000 milliseconds

[2007-09-06 16:46:04.565 'BaseLibs' 3184 info] NFC write timeout: 600000 milliseconds

[2007-09-06 16:46:04.565 'App' 3184 info] Starting VMware VirtualCenter 2.0.2 build-50618
[2007-09-06 16:46:04.565 'App' 3184 info] Account name: SVC_VC2
[2007-09-06 16:46:04.565 'App' 3184 info] [VpxOsLayer] Enabled low-frag process heap.

[2007-09-06 16:46:04.565 'App' 3184 info] [VpxOsLayer] Enabled low-frag crt heap.

[2007-09-06 16:46:04.565 'App' 3184 info] [VpxLRO] 34 max LROs
[2007-09-06 16:46:04.565 'App' 3184 info] [VpxLRO] 6 reserved internal LROs
[2007-09-06 16:46:04.565 'App' 3184 info] [VpxLRO] 6 reserved blocker LROs
[2007-09-06 16:46:04.565 'App' 3184 info] [VpxLRO] 6 reserved short LROs
[2007-09-06 16:46:04.565 'App' 3184 info] [VpxLRO] 4 reserved long LROs
[2007-09-06 16:46:04.565 'App' 3184 info] [VpxLRO] 600-second task lifetime
[2007-09-06 16:46:09.690 'App' 3184 error] [VpxdVdb] Failed to init tableDef: Column VER_ID does not exist in table VPX_VERSION. Database version may be incompatible.
[2007-09-06 16:46:09.690 'App' 3184 error] Failed to intialize VMware VirtualCenter. Shutting down...[/code]

The installer connected to the database and created the tables without error, so I am confused by the service failure and the "Database version may be incompatible" mentioned on second to last line.

If SQL 2005 SP2 is NOT supported, what SQL 2005 SP level is?

Any thoughts/ideas/comments..?

Cheers,

Martin