![]() ![]() Make sure to change Enabled to Yes and TCP Dynamic Ports to 0 (zero). Right click on TCP/IP and click Properties. Skip this part if vCenter and SQL are running on the same box: You will need to modify the TCP/IP settings for SQL. Open the SQL Server Configuration Manager, go to SQL Server Network Configuration, then Protocols for MSSQLSERVER. I will give SQL 2 GB which leaves 2 GB for the OS. I am running this in my home lab on a VM with 4 GB of RAM. On the Memory page we will want to limit the amount of memory SQL can use. Click Ok:īefore we leave SQL Management Studio as a best practice right click your SQL server name and go to Properties: Go to the Options page and change the Recovery model to Simple. Next right click on your VCDB database and go to Properties: You will now have a VCDB DB under Databases. You should receive a message saying “Command(s) completed successfully. Make sure it matches all the way through the script.Ĭlick Execute. This script will create a user and give it DBO permissions, rename the vpxuser with your own username.Change the initial size of the MDF to 4096KB, if you leave it at the default 3000KB you will get an error when you execute.I used defaulted install so below is my path./ Add the location of your SQL data directory.Now click on “ New Query” and enter the database script from above. Open SQL Server Management Studio and login using an account that has access: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |