I have SQL server running and I can login using user, password. Now the same user, password combo doesn't work for Orchestrator. Any reasons why?
What should be the hostname or IP?
- The SQL browser service must be running
- fill Domain field in ONLY if you use a domain and want to use the Windows auth, if you leave it empty the SQL auth will be used.
Whats the erro message you getting?
The Orchestrator docs are loccated here: http://www.vmware.com/support/pubs/orchestrator_pubs.html
The install and config guide should help you through it. Certainly let us know if you are still having issues.
I had the same issue with SQL Express 2005.
Going through the SQL-Server configuration utility, I saw that only the dynamic port was set, the fixed Port was empty. So I edited the fixed port to be 1433, restarted SQL-Express and everything worked fine.
Hope this helps.
I'm having the same challenges in terms of connecting to the sql server. This is the error I get:
"Cannot connect to jdbc:jtds:sqlserver://vsphere:1433/;domain=LABNETWORK. Connection error was: Network error IOException: Connection refused: connect"
I made sure that the SQL Server database and SQL browser both have TCP/IP enabled and restarted both services.
You have to open mutliple ports in your Server firewall (SQL Server firewall). You should just try if it's a firewall issue by shutting it down for a short time.
The ports you'll need are the one from the SQL Server and the one from the SQL Browser