We're getting ready to set up a new vCenter and plan to use MS SQL Server 2008 R2 for the data base. Looking at the DB install docs there are a number of Windows service accounts that have to be set up. Anybody have suggestions as to how to set these up? For example, the doc says to use a "minimally-privileged" domain account if the service is going to interact with network services. What privileges have people given this account?
Welcome to the forums!
Just do a standard installation of MS SQL and for vSphere stick to that documentation: http://pubs.vmware.com/vsphere-50/topic/com.vmware.vsphere.install.doc_50/GUID-36B92A8C-074A-4657-99...
There are scripts in that documentation which will do the work for you.
I've started running through the install procedure and I can't get past setting up the ODBC DSN connection. I'm getting:
SQL State 28000
SQL Server Error 18456
Whick is a login failed error. I've verified the user name and password on the SQL Server. The 1433 port is open because the server is advertising itself and I can choose it from the drop down box set up dialog. There's nothing I can see that should keep the connection from going through. Searches for the error have not returned anything helpful. Any suggestions will be greatly appreciated.
Go to SQL server configuration Manager and make sure that TCP/IP and named pipes are enabled as protocols.
We've fought our way through 90%+ of the SQL Server setup prior to installing the vCenter server. Can anybody help me out with the syntax for creating the ODBC DSN in the vCenter server database?
Thanks very much.