SQL Express setup during install. SQL not listening?

[ProjecktMayh3m]

I just installed vCenter on a brand new 2008 R2 server. I'm going through the Orchestrator Configuration and am stuck at the Database tab. 2 problems:

1) I let the install put SQL Express 2005 on the server and I can't find any documentation telling me what the username (sa??) and password are.

2) I don't think SQL is listening. I get an error when trying to save the config: "Unknown host: Error when connecting to the host localhost/12.0.0.1, port 1433: Connection refused: connect". If I run a netstat -a, I don't see TCP 1433 anywhere as an open port. Only UDP 1434.

I tried to install SQL Server Mgmt Studio Express to investigate, but that install fails.... (another different issue).

Any thoughts?

Thanks all.

[ProjecktMayh3m]

I got SQL Server Mgmt Studio Express installed and I can connect to the instance using NT credentials. I see the VIM_VCDB database and all of the tables... Still can't get Orchestrator Configuration to connect to the server on 1433. :smileyangry:

[Burke-]

By default, SQLExpress is using Dynamic ports... so, you must either use the dynamic port specified in your SQL config, or set the port to 1433. Take a look at my tutorial here for more detailed information: http://www.vcoteam.info/new-to-vcenter-orchestrator-vco/how-to-install-vcenter-orchestrator-vco.html

[ProjecktMayh3m]

Brilliant. That was it. Right on the money.

Thanks so much.