Sql-server – Error from Program Compatibility Assistant when installing SQL Server 2008
installationsql serversql-server-2008windows 8
I am new to this so please do not mind if this is dumb question.
I am receiving an error while installing SQL Server 2008 on Windows 8.1
I have .net 4. I have windows installer 4.5
Best Answer
From Mark Sinkinson's enigmatic comment, you'll notice that that earlier versions are not compatible on Windows 8. 2008 & 2008R2 are supported, but you need to update them to their most recent service packs.
I agree though, Program Compatibility Assistant isn't the most assisting.
Basically, you just need go through the "Run the program without getting help" option, and then when the installation is finished apply the most recent Service Pack (2 for 2008R2, 3 for 2008).
Not really your question but you might want to head over to Brent Ozar's website for a handy checklist/guide for SQL Server installations. I've done quite a few of them but still have that to hand whenever I do a new one.
Make sure the account doing the installation is a member of the following groups in local security policy:
Adjust Memory quotas for a process
Bypass Traverse checking
Log on as a batch job
Log on as a service
Replace a process level token
Backup files and directories
Debug programs
Manage auditing and security log
Additional Items to check:
Make sure the account doing the install is a local admin on the server, make sure you are not installing to a compressed drive or folder, make sure you are installing the right version, IE 32 or 64 bit based on your OS
Best Answer
From Mark Sinkinson's enigmatic comment, you'll notice that that earlier versions are not compatible on Windows 8. 2008 & 2008R2 are supported, but you need to update them to their most recent service packs.
I agree though, Program Compatibility Assistant isn't the most assisting.
Basically, you just need go through the "Run the program without getting help" option, and then when the installation is finished apply the most recent Service Pack (2 for 2008R2, 3 for 2008).
This MSDN blog post goes into further details on this.
Not really your question but you might want to head over to Brent Ozar's website for a handy checklist/guide for SQL Server installations. I've done quite a few of them but still have that to hand whenever I do a new one.