SPS 2010 Install – SQL Server 2008

So we have new VM domain controller and now we’ll try to get SQL Server to run.

I have the install disk in my metal server and so, in the VM, I have to uncapture the CD drive and then recapture it with the new disk.  It wants to auto start. I click OK and click Install Server Components.

I accept the license terms and click Next and then Install.

The Intstallation Center opens. I click New Installation. The wizard does a configuration check, I pass7 and fail none. I click Next.

I check the Database engine, Analysis Services and Reporting Services, the client tools,BIDS and Integration Services and click Next.

I accept the default instance and file locations and click Next.

I have to add a service account for the SQL Server Agent, the server itself as well as AS and RS. Start |  Administrative Tools | AD Users and Computers opens the ADU&C management console. I right click on Users and select New and then User. I give the new account a name and a logon name SVC_SQLServer. I give him a password and click Finish. Then I add him to the domain administrators group.

Back on the SQL Server Configuration wizard, I enter this account in the Use the same account for all fields and click Apply to all and then Next.

I allow for mixed mode security and enter an sa password. Then I add the current user, MyNewDomain\Administrator and my SQL Server service account, MyNewDomain\svc-sqlserver to the SQL Server administrators group and click Next.

I add the current user and the SVC_SQLServer acocunt to the Analysis Services configuration page and click  Next.

Then, I choose this option: Install the SharePoint mode default configuration. I let the server send whatever it wants to Microsoft. I click Next and it tells me it’s ready to install.

I click Install.

The database engine services, reporting services and analysis services fail. All I can do is click next. It points me to a .txt file in c:\program files\Microsoft SQL Server\100\Serup_Bootstrat\log\20200222_1720\MyDomainController)20100111_1720_Summary.txt.

That file tells me to check the logs to figure out what went wrong.

Not a great conclusion to a day’s work.

-robot


Tags:

 
 
 

Comments are closed.