Error 25003 setup failed to create the vCenter server repository (4.1)

[Wasisnt]

Im trying to setup a vCenter 4.1 server installation and get the error that says:
vCenter setup error 25003 setup failed to create the vCenter server repository

I did all the suggestions I found from different threads on the same error:

vCenter and SQL 2008 are on separate servers which are both Windows 2008 R2 64 bit
    I read that R2 may not be supported for SQL 2008 used with vCenter?

Turned off UAC on the vCenter and SQL servers

Installed the SQL Server 2008 Native Client on the vCenter Server

Have the same local admin with the same password on both servers

     I still dont understand why the username section is auto populated with a  local admin user and they greyed out during the vCenter installation.

Made sure that the SQL collation is case insensitive

Have the DSN setup and tested (Im not a SQL expert or even close)
    I used the odbcad32.exe from C:\Windows\System32 because thats what the guide said
    Others say to use the odbcad32.exe C:\Windows\SyWOW64 but I dont know which is right

I found this on a VMware page but I dont know what it means: Add the database user into db2user or db2admin group

Have the Vcenter database and database user configured using the script provided in the configuration manual

Took out any special characters in the password for the vpxuser DB account

I found another step in a different thread that said Run each script specified in the "create schema" section of the manual but I dont know what manual he is referring to.

[MauroBonder]

Hello,

I found two KBs, check if help with you problem.

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=100396...

http://kb.vmware.com/kb/1024737

Good Luck

Please, don't forget the awarding points for "helpful" and/or "correct" answers. 

Mauro Bonder - Moderator

[Troy_Clavell]

also, you must provide dbo on both the MSDB and the VCDB.  Since vCenter is 64bit, you'll need to use a 64bit DSN.  For your install you can use the SQL Native Client from http://www.microsoft.com/download/en/details.aspx?id=16978

see also, http://kb.vmware.com/kb/1003960

[Wasisnt]

I made sure its not set to Case Insensitive mode.

Im not sure about the ensure that the Database client version matches the Database version but the SQL server is 2008 SP2 and the vCenter server is using the SQL 2008 native client.

Everything is English so that other link doesnt apply.

[Wasisnt]

Is there more to the Microsoft SQL Server 2008 R2 Feature Pack than the SQL Server 2008 Native Client? Im not sure what it does.

[Troy_Clavell]

one other thing SQL 2008 R2 is only compatible with 4.1U1

http://www.vmware.com/pdf/vsphere4/r40/vsp_compatibility_matrix.pdf

[Troy_Clavell]

All you need is the SQL Native Client.  Download and install on your vCenter Host OS and then choose the SQL Native Client when creating your ODBC connection

http://go.microsoft.com/fwlink/?LinkID=188400&clcid=0x409

[Wasisnt]

I am using update 1 for ESXi but my vCenter files dont say update 1. How would I check that? I downloaded them less than a month ago.

[Wasisnt]

I am using the SQL Server 2008 Native Client and the DSN looks fine

Here is my vpxd log file if it helps

Section for VMware VirtualCenter, pid=2972, version=4.1.0, build=build-258902, option=Release
[2011-08-23 10:36:09.643 02968 info 'App'] Current working directory: C:\Windows\system32
[2011-08-23 10:36:09.643 02968 info 'App'] Log path: C:\ProgramData\VMware\VMware VirtualCenter\Logs
[2011-08-23 10:36:09.659 02968 info 'App'] Initializing SSL
[2011-08-23 10:36:09.659 02968 info 'Libs'] Using system libcrypto, version 9080CF
[2011-08-23 10:36:11.018 02968 info 'App'] Vmacore::InitSSL: doVersionCheck = true, handshakeTimeoutUs = 120000000
[2011-08-23 10:36:11.081 02968 error 'App'] ODBC error: (28000) - [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'SQL-2008\nestis'.
[2011-08-23 10:36:11.081 02968 error 'App'] Error getting configuration info from the database
[2011-08-23 10:36:11.081 02968 error 'App'] [Vdb::GetTLSConnection] TLSConnection callback functions are not provided or removed
[2011-08-23 10:36:16.565 02968 info 'App'] CoreDump: Writing minidump
[2011-08-23 10:36:19.674 02968 panic 'App']

Panic: Not Reached: @ d:/build/ob/bora-257238/bora/vim/lib/vdb/vdb.cpp:3061
Backtrace:
backtrace[00] rip 000000018010a1aa Vmacore::System::Stacktrace::CaptureWork
backtrace[01] rip 00000001800e8018 Vmacore::System::SystemFactoryImpl::CreateFileWriter
backtrace[02] rip 00000001800e850e Vmacore::System::SystemFactoryImpl::CreateQuickBacktrace
backtrace[03] rip 0000000180129205 Vmacore::PanicExit
backtrace[04] rip 0000000180129311 Vmacore::PanicExit
backtrace[05] rip 00000001800772be Vmacore::RunTimeFailure
backtrace[06] rip 000000013f73122b (no symbol)
backtrace[07] rip 000000013f733a3f (no symbol)
backtrace[08] rip 000000013f902e58 (no symbol)
backtrace[09] rip 000000013f90479a (no symbol)
backtrace[10] rip 000000013f3820ce (no symbol)
backtrace[11] rip 000000013f37bcc5 (no symbol)
backtrace[12] rip 000000013f37c0c4 (no symbol)
backtrace[13] rip 000000013f37adf2 (no symbol)
backtrace[14] rip 000000007785652d BaseThreadInitThunk
backtrace[15] rip 000000007798c521 RtlUserThreadStart

[2011-08-23 10:36:19.721 02968 panic 'App'] Not Reached: @ d:/build/ob/bora-257238/bora/vim/lib/vdb/vdb.cpp:3061

------ In-memory logs start --------
[2011-08-23 10:36:09.643 02968 info 'App'] Current working directory: C:\Windows\system32
[2011-08-23 10:36:09.643 02968 verbose 'ThreadPool'] TaskMax=90, IoMin=1, IoMax=181
[2011-08-23 10:36:09.643 02968 info 'App'] Log path: C:\ProgramData\VMware\VMware VirtualCenter\Logs
[2011-08-23 10:36:09.659 02968 info 'App'] Initializing SSL
[2011-08-23 10:36:09.659 02968 info 'Libs'] Using system libcrypto, version 9080CF
[2011-08-23 10:36:11.018 02968 info 'App'] Vmacore::InitSSL: doVersionCheck = true, handshakeTimeoutUs = 120000000
[2011-08-23 10:36:11.081 02968 error 'App'] ODBC error: (28000) - [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'SQL-2008\nestis'.
[2011-08-23 10:36:11.081 02968 error 'App'] Error getting configuration info from the database
[2011-08-23 10:36:11.081 02968 error 'App'] [Vdb::GetTLSConnection] TLSConnection callback functions are not provided or removed
[2011-08-23 10:36:16.565 02968 info 'App'] CoreDump: Writing minidump
[2011-08-23 10:36:19.674 02968 panic 'App']

Panic: Not Reached: @ d:/build/ob/bora-257238/bora/vim/lib/vdb/vdb.cpp:3061
Backtrace:
backtrace[00] rip 000000018010a1aa Vmacore::System::Stacktrace::CaptureWork
backtrace[01] rip 00000001800e8018 Vmacore::System::SystemFactoryImpl::CreateFileWriter
backtrace[02] rip 00000001800e850e Vmacore::System::SystemFactoryImpl::CreateQuickBacktrace
backtrace[03] rip 0000000180129205 Vmacore::PanicExit
backtrace[04] rip 0000000180129311 Vmacore::PanicExit
backtrace[05] rip 00000001800772be Vmacore::RunTimeFailure
backtrace[06] rip 000000013f73122b (no symbol)
backtrace[07] rip 000000013f733a3f (no symbol)
backtrace[08] rip 000000013f902e58 (no symbol)
backtrace[09] rip 000000013f90479a (no symbol)
backtrace[10] rip 000000013f3820ce (no symbol)
backtrace[11] rip 000000013f37bcc5 (no symbol)
backtrace[12] rip 000000013f37c0c4 (no symbol)
backtrace[13] rip 000000013f37adf2 (no symbol)
backtrace[14] rip 000000007785652d BaseThreadInitThunk
backtrace[15] rip 000000007798c521 RtlUserThreadStart

[2011-08-23 10:36:19.721 02968 panic 'App'] Not Reached: @ d:/build/ob/bora-257238/bora/vim/lib/vdb/vdb.cpp:3061

------ In-memory logs end   --------

[Wasisnt]

Im downloading vCenter again and am going to make sure I have update 1 and try it again.

[Troy_Clavell]

as you log indicated you are not using U1, but instead base 4.1

Section for VMware VirtualCenter, pid=2972, version=4.1.0, build=build-258902, option=Release

[Wasisnt]

Good to know. Im downloading it now and will report back after I try the installation again.

[Troy_Clavell]

Also, note the login failure below. You tested your ODBC connection successfully?

[2011-08-23 10:36:11.081 02968 error 'App'] ODBC error: (28000) -  [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for  user 'SQL-2008\nestis

[Wasisnt]

The connection was tested sucessfully. I think that error was from when I was trying other accounts and passwords when I was "troubleshooting" earlier.

[Wasisnt]

I tried it with the update 1 installation files and got the same result. I noticed the login failure again so I made the nestis user's local account and SQL account match the domain admin account's (named nestis) password and still no go.

Here is the log before I changed the password:

Section for VMware VirtualCenter, pid=2116, version=4.1.0, build=build-345043, option=Release
[2011-08-23 12:13:08.584 02480 info 'App'] Current working directory: C:\Windows\system32
[2011-08-23 12:13:08.584 02480 info 'App'] Log path: C:\ProgramData\VMware\VMware VirtualCenter\Logs
[2011-08-23 12:13:08.584 02480 info 'App'] Initializing SSL
[2011-08-23 12:13:08.584 02480 info 'Libs'] Using system libcrypto, version 9080EF
[2011-08-23 12:13:09.599 02480 info 'App'] Vmacore::InitSSL: doVersionCheck = true, handshakeTimeoutUs = 120000000
[2011-08-23 12:13:09.631 02480 error 'App'] ODBC error: (28000) - [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'SQL-2008\nestis'.
[2011-08-23 12:13:09.631 02480 error 'App'] Error getting configuration info from the database
[2011-08-23 12:13:09.631 02480 info 'App'] [LdapBackup] Making sure LDAP instance VMwareVCMSDS is running
[2011-08-23 12:13:09.631 02480 info 'App'] [LdapBackup] Attempting to start service ADAM_VMwareVCMSDS...
[2011-08-23 12:13:09.631 02480 info 'App'] [LdapBackup] Service started
[2011-08-23 12:13:09.631 02480 error 'App'] [LDAP Client] Failed to get all pages of search result: : 0x57 (The search filter is bad.)
[2011-08-23 12:13:09.631 02480 error 'App'] [LicMgr] Failed to execute ldap query to get usage

Here is the log after I matched the passwords and tried the installation again. Its still giving me a login failure. Does there need to be a user account in SQL for the local user thats being used to install vCenter? The error looks as though the local nestis account is the issue but the password is the same for the local nestis account on vCenter that is being used for the installation even though Im logged in as the doman admin nestis when running the installation. I tried logging in as the local nestis to run the installation but the SQL connection fails when I do that because I assume there is no vCenter\nestis account on the SQL server.

Section for VMware VirtualCenter, pid=2104, version=4.1.0, build=build-345043, option=Release
[2011-08-23 12:18:52.702 01676 info 'App'] Current working directory: C:\Windows\system32
[2011-08-23 12:18:52.702 01676 info 'App'] Log path: C:\ProgramData\VMware\VMware VirtualCenter\Logs
[2011-08-23 12:18:52.702 01676 info 'App'] Initializing SSL
[2011-08-23 12:18:52.702 01676 info 'Libs'] Using system libcrypto, version 9080EF
[2011-08-23 12:18:53.717 01676 info 'App'] Vmacore::InitSSL: doVersionCheck = true, handshakeTimeoutUs = 120000000
[2011-08-23 12:18:53.749 01676 error 'App'] ODBC error: (28000) - [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'SQL-2008\nestis'.
[2011-08-23 12:18:53.749 01676 error 'App'] Error getting configuration info from the database
[2011-08-23 12:18:53.749 01676 info 'App'] [LdapBackup] Making sure LDAP instance VMwareVCMSDS is running
[2011-08-23 12:18:53.749 01676 info 'App'] [LdapBackup] Attempting to start service ADAM_VMwareVCMSDS...
[2011-08-23 12:18:53.749 01676 info 'App'] [LdapBackup] Service started
[2011-08-23 12:18:53.749 01676 error 'App'] [LDAP Client] Failed to get all pages of search result: : 0x57 (The search filter is bad.)
[2011-08-23 12:18:53.749 01676 error 'App'] [LicMgr] Failed to execute ldap query to get usage

[Troy_Clavell]

maybe you should try using SQL authentication instead.  create a SQL user and assign dbo on the MSDB and VCDB (to create rollup jobs), update your DSN to reflect the new SQL account and try again.

[Wasisnt]

I was just about to give up and install SQL Express since we only have 4 hosts but then I tried adding the local SQL-2008\nestis account to the SQL server logins and it worked!

[Troy_Clavell]

somehow I missed this yesterday.  Glad to see you got it resolved!