VMware Communities: vcenter orchestrator configuration ...

VMware

Up to Discussions in Orchestrator

This Question is Answered

1 "correct" answer available (10 pts) 2 "helpful" answers available (6 pts)

1 2 Previous Next 16 Replies Last post: Oct 20, 2009 7:36 AM by everyangle

vcenter orchestrator configuration challenge using sqlserver posted: Jun 15, 2009 1:50 PM

gharouff

12 posts since
Jul 18, 2008

I keep getting "Database configuration successfully updated, but the configuration is in error" message.

Things I tried:

Went to ODBC clicked on system DSN tab / clicked on configure

Check to make sure I was on the correct SQL server (MBOEVMCONSOLE1\SQLEXP_VIM

Clicked next

Tested the connection and passed.

But when I click on apply changes I get the above error message.

This is SQL 2005 that came with the software

In the orchestrator configuration I have the following

Username:backup

Password:

Hostname or IP: localhost (tried IP address also)

Port:1433

Database name: SQLEXP_VIM

Instance name (if any): tried VIM_VCDB and (blank)

Domain: mentorschools.org

I have the following database error : -- Cannot connect to jdbc:jtds:sqlserver://localhost:1433/SQLEXP_VIM;domain=mentorschools.org;instance=VIM_VCDB. Connection error was: Server localhost has no instance named VIM_VCDB.

Or I get -- Nothing listening on port - SQLServer probably down

Any suggestions

Tags: sql, installation

Re: vcenter orchestrator configuration challenge using sqlserver

1. Jun 17, 2009 5:53 AM

in response to: gharouff

Texiwill

10,432 posts since
Jan 13, 2004

Hello,

Moved to the Orchestrator forum.

Best regards, Edward L. Haletky VMware Communities User Moderator, VMware vExpert 2009
Now Available on Rough-Cuts: 'VMware vSphere(TM) and Virtual Infrastructure Security: Securing ESX and the Virtual Environment'
Also available 'VMWare ESX Server in the Enterprise'
SearchVMware Pro|Blue Gears|Top Virtualization Security Links|Virtualization Security Round Table Podcast

Re: vcenter orchestrator configuration challenge using sqlserver

2. Jun 17, 2009 9:52 AM

in response to: gharouff

a.p.

22 posts since
May 18, 2007

I had the same issues. Solved them as follows:
(I am not sitting in front of my server, so this is kind of a braindump...)

1.) Configured Port 1433 for SQL-Express
Using the SQL Configuration Utilities configure the TCP/IP configuration and add port 1433 to IP-All fixed port.
Restart SQL-Express service

2.) Download and install "Microsoft SQL Server 2005 Express Edition Service Pack 2" from the MS web page
Create a new Database e.g. VCO_DB

3.) In Orchestrator SQL configuration
Database name = VCO_DB
Instance = leave blank
Port 1433
Once connected a link will show up to initialize the database. Once you click it the tables will be created.

Hope this helps.

Re: vcenter orchestrator configuration challenge using sqlserver

3. Jun 18, 2009 8:22 AM

in response to: gharouff

malaysiavm

604 posts since
Aug 24, 2008

I went through the whole configuration today, is a pain in the butt. You need to use the SQL management tools to create a blank DB then only you can attach it to the VCO

Craig

vExpert 2009
Malaysia VMware Communities - http://www.malaysiavm.com

Re: vcenter orchestrator configuration challenge using sqlserver

4. Jun 30, 2009 12:47 PM

in response to: gharouff

gharouff

12 posts since
Jul 18, 2008

I have tried installing SQL Express and receive the following error. Cannot connect to jdbc:jtds:sqlserver://localhost:1433/VCO_DB;domain=mentorschools.org. Connection error was: Cannot open database "VCO_DB" requested by the login. The login failed.

I have rebooted and restarted the services many times. But no luck.

Re: vcenter orchestrator configuration challenge using sqlserver

5. Jun 30, 2009 1:05 PM

in response to: gharouff

Burke-

82 posts since
Oct 23, 2007

When using a LOCAL instance of SQL, SQLExpress, etc.. it may be necessary to use the DYNAMIC port for your vCO configuration. So,

Launch your "SQL Server Configuration Manager"
Expand the SQL Network Configuration
Select the Protocols entry beneath that
In the Right Pane,double-click "TCP/IP"
In the TCP/IP Properties window, scroll down to the IPAll section and record the "TCP Dynamc Ports"

Use the port number recorded in step 5 above and see if you can connect... you should be able to

Re: vcenter orchestrator configuration challenge using sqlserver

6. Jun 30, 2009 1:07 PM

in response to: gharouff

Burke-

82 posts since
Oct 23, 2007

"GHAROUFF":

Login failed...

Okay, is your SQL server using SQL authentication? or Windows authentication?

If SQL Authentication, leave domain blank.

If Windows authentication AND server is in a Windows domain, enter your windows Domain in the domain box...

If Windows authentication and server is NOT in Windows domain, enter your Server name in the domain box...

Did that help?

Re: vcenter orchestrator configuration challenge using sqlserver

7. Jun 30, 2009 1:26 PM

in response to: Burke-

gharouff

12 posts since
Jul 18, 2008

Here is the error -- Cannot connect to jdbc:jtds:sqlserver://localhost:1433/VCO_DB;domain=mentorschools.org. Connection error was: Cannot open database "VCO_DB" requested by the login. The login failed..

I have done this "If Windows authentication AND server is in a Windows domain, enter your windows Domain in the domain box..."

Re: vcenter orchestrator configuration challenge using sqlserver

8. Jun 30, 2009 2:02 PM

in response to: gharouff

Burke-

82 posts since
Oct 23, 2007

Have you checked the dynamic port as I outlined in my previous post?

Re: vcenter orchestrator configuration challenge using sqlserver

9. Jul 1, 2009 3:58 AM

in response to: Burke-

gharouff

12 posts since
Jul 18, 2008

Yes I have. Please see attached

Attachments:

tcp.JPG (92.8 K)

Re: vcenter orchestrator configuration challenge using sqlserver

10. Jul 1, 2009 6:42 AM

in response to: gharouff

Burke-

82 posts since
Oct 23, 2007

Can I also see a screenshot of your Database Configuration page in vCenter Orchestrator Configuration please?

Re: vcenter orchestrator configuration challenge using sqlserver

11. Jul 1, 2009 6:46 AM

in response to: Burke-

gharouff

12 posts since
Jul 18, 2008

Here it is

Attachments:

vmware.JPG (101.6 K)

Re: vcenter orchestrator configuration challenge using sqlserver

12. Jul 1, 2009 6:57 AM

in response to: gharouff

Burke-

82 posts since
Oct 23, 2007

Okay, in your first post, you mention "MBOEVMCONSOLE1\SQLEXP_VIM" ...

Is MBOEVMCONSOLE1 your localhost? I assume it is... and that the server is in the mentorschools.org domain (This is your windows domain, right?) and that "Administrator" and the password used are domain accounts as well?

SQLEXP_VIM is your Instance nam...

Please enter "SQLEXP_VIM" in the Instance box
Please enter "3476" in the Port box

If the assumptions above are correct, please make the entries suggested and click apply changes...

Re: vcenter orchestrator configuration challenge using sqlserver

13. Jul 2, 2009 9:52 AM

in response to: Burke-

gharouff

12 posts since
Jul 18, 2008

I went back to the beginning and created a document the has resolved the SQL database challenge. Please see attached instructions.

Attachments:

Orchestrator Configuration Installation Guide Database section.doc (460.0 K)

Re: vcenter orchestrator configuration challenge using sqlserver

14. Jul 2, 2009 9:54 AM

in response to: gharouff

gharouff

12 posts since
Jul 18, 2008

The documentation resolves my challenge

1 2 Previous Next Go to original post

Go to original post

Search VMware Communities Advanced Search

Actions

View as PDF

Up to Discussions in Orchestrator