Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Multiple errors connecting VCenter to 2008 R2 DB

Author  Topic 

jstokes
Starting Member

2 Posts

Posted - 2014-10-01 : 08:36:40
Hi,
Can anyone tell me is it possible to insert attachments to mails here as the problem would be better understood with a few error Print screens.

The problem I'm having is when trying to install a View Environment (View 5.3.2) I'm getting multiple errors during the install of VCenter (VCenter 5.5)
SSO and Inventory Service and Web Client have all installed without a hitch. It's just the VC install itself.
I have everything on a domain and able to ping each other by hostname.

The SQL instance 2008 R2 DB I have installed is CASE Insensitive.
On this I have configured a new DB for the purpose of connecting to VCenter.
I have also set up a New Login User and made the User DB Owner.
This DB is also Case Insensitive.

From here when I configure the ODBC connection on VCenter I have no problems. I can see the DB in the dropdown and the Test Connection works fine.

Then when I install VCenter everything works ok up to the point where it reaches the Creating VCenter Server Repository stage and then it crashes with the error 25003: set up failed to Creqate the VC Server repository.
The most common reasons for this failure are:
- The DB is installed in Case Insensitive Mode.
- The DB is remote and the client Version does not match
Then it tells me to check out the VMware KB 1003960 for more info.

So what I have done so far is to re install a new SQL DB and make that Case Sensitive but this did not work as this time it told me that the DB was Case Sensitive.

I have a couple of questions.

Do I need to disable or enable firewalls on the VMs across the domain.
I've been advised by different people to do both.
If firewalls are to be enabled are these the domain firewalls or the other private and public firewalls?

From my dealings with this it seems that when you enable the firewalls on the VMs then you can't ping by hostname which would not allow connection from VC to the SQL instance via the ODBC DSN??

Should the DB be Case Sensitive or Insensitive?
Can I install a Case Sensitive DB on a SQL instance that is Case Insensitive?

How does one determine if they are using the right native Client?
I currently have the Native Client 10.0 installed

I have also set up the ODBCcad.exe file that adds the 32 bitDSN in Winsows/SysWOW64.Is this right to do this?

If there's any other info needed I will provide.

The funny or not so funny thing is is that I set up this exact configuration a couple of weeks back and had no issues with the VCenter install.

Thanks and Best Regards,

John


jstokes
Starting Member

2 Posts

Posted - 2014-10-01 : 10:34:05
Hi,
Just update this.
I think I have this one figured out with the help of the link below.

https://communities.vmware.com/message/2324755

In my situation what worked was:
I created a DB and a new Login.
The new Login was created using SQL authentication and the password had no special characters in it.
In the User mapping and I think this is the key part for the New User I gave db ownership to both the newly created DB and the Master DB, so check both the mscb and the new DB checkboxes and give them both DB_Owner permissions.
Then return to the VC VM and create the ODBC connection and use the Username and Password that corresponds to the ones you have just set up (using SQL authentication of course)
Finish out this wizard and then start the install of VCenter and youi should be good to go.
IT worked for me anyway.

Thanks Guys

John
Go to Top of Page
   

- Advertisement -