NAMEWITHELD12
asked on
Best set of instructions for Vcenter install with separate SQL 2008 standard
I am looking for the best set of instructions for installing SQL 2008 and then installing Vcenter 5.1 , I am looking for some good screen shots and maybe the scripts that I have to user to create the DB schema etc
This YouTube video will walk you through the vCenter 5.1 install on a MS SQL server..
http://www.youtube.com/watch?v=lsLiJGQDIJg
http://www.youtube.com/watch?v=VyJkSrmcGNg
Hope this helps...
http://www.youtube.com/watch?v=lsLiJGQDIJg
http://www.youtube.com/watch?v=VyJkSrmcGNg
Hope this helps...
ASKER
thanks , I am having many errors when I try to run the script to create the DB and set the permissions , is there a way to do this entirely thru the GUI ?
You shouldn't need the run the DB scripts manually.
1)Create an empty DB and either create a SQL account or domain user account which has DBOwner rights to the DB
2)Run the vcenter install
1)Create an empty DB and either create a SQL account or domain user account which has DBOwner rights to the DB
2)Run the vcenter install
I have tried that option and i have got Tablespaces missing error when i just created a DB. Have always seen people creating the DB beforehand by running the scripts. That's my experience.
NAMEWITHELD12,
What errors are you getting?
NAMEWITHELD12,
What errors are you getting?
What name did you give the DB, what about permissions?
Can you upload screen shots of your SQL DB setup and the error you are getting when running the vCenter install. Also what build number of vCenter are you trying to install?
Can you upload screen shots of your SQL DB setup and the error you are getting when running the vCenter install. Also what build number of vCenter are you trying to install?
ASKER
ASKER
Run the script only for SSO(RSA DB) And create a empty DB and a user for that DB for vCenter.
Give the user db_owner permission.
Give the user db_owner permission.
ASKER
I am VERY confused , this is hard stuff I am not a DBA at all can you walk me thru it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok ,thanks I am using SSO 5.5 so there is not any database that is needed to be created , I will follow the vidio for the Vcenter DB creation
thanks !!
thanks !!
here's a video for that
http://www.youtube.com/watch?v=WeAQkHhpQHw
http://www.youtube.com/watch?v=WeAQkHhpQHw
ASKER
yeah , that worked
You shouldn't need the run the DB scripts manually.
1)Create an empty DB and either create a SQL account or domain user account which has DBOwner rights to the DB
2)Run the vcenter install
I was not completely giving permissions correctly on the SQL database , if you set the permmisions right then you can just run the install , the only other issue I had was the SQL client service would not run on the SQL server, I check out the logs and found out that it was a typical permissions issue
You shouldn't need the run the DB scripts manually.
1)Create an empty DB and either create a SQL account or domain user account which has DBOwner rights to the DB
2)Run the vcenter install
I was not completely giving permissions correctly on the SQL database , if you set the permmisions right then you can just run the install , the only other issue I had was the SQL client service would not run on the SQL server, I check out the logs and found out that it was a typical permissions issue
Nice Job!!!!
Good to know it finally worked. As i mentioned before it all boils down to permissions when it comes to vcenter DB.
The best instructions will be in the link below
http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2032885
It also has a video of how to do the simple install.
You can also take a look at the best practices document
http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2021202