vcenter orchestrator configuration challenge using sqlserver

[gharouff]

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

[Texiwill]

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'[/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]

[a_p_]

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.

[malaysiavm]

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 -

[gharouff]

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.

[Burke-]

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

1. Launch your "SQL Server Configuration Manager"

2. Expand the SQL Network Configuration

3. Select the Protocols entry beneath that

4. In the Right Pane,double-click "TCP/IP"

5. 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 :smileycool:

[Burke-]

"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?

[gharouff]

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..."

[Burke-]

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

[gharouff]

Yes I have. Please see attached

[Burke-]

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

[gharouff]

Here it is

[Burke-]

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...

[gharouff]

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

[gharouff]

The documentation resolves my challenge

[Burke-]

I'm glad to see that you've finally gotten through the configuration.. please note, however, that using the VC Database is not advised. It is safer to use a dedicated DB for vCO/LCM. The configuration you have right now is okay for testing, but definitely not recommended for production use.

[everyangle]

Thank you for the document it realy helped us!

[joshuamarshall]

Thanks very much for that document. It got me past the same issue on a new vCenter install!

[djnando]

thanks a lot for putting this procedure, works like a charm