;font-family:'segoe wp','segoe ui',verdana,arial,helvetica,sans-serif;font-size:36px;margin-top:0px;margin-bottom:0px;vertical-align:baseline;"> Download:
SQL Server 2012 capabilities and highlights are as follows ( from Microsoft site directly)
After downloading the ISO, run it and Accept the Terms and click Next
If your internet connection is ok, it will search for updates, you can skip it, or leave for searching.
In my case I leaved, but it return nothing, so again NEXT
SQL Server 2012 will run some tests, in my case it showed a warning on the FIREWALL, because it was enabled. The warning was for "not forgetting" to open the specific ports for the communication.
SQL Server 2012 will run some tests, in my case it showed a warning on the FIREWALL, because it was enabled. The warning was for "not forgetting" to open thana,arial,helvetica,sans-serif;font-size:14px;vertical-align:baseline;">
You can use the Evaluation Version or insert a Product Key and NEXT
Again (!) accept the License Terms
We chose the role "SQL SERVER Feature Installation"
Check all these features from the list. It's just amazing that they putted "Reporting Services Add-in for SharePoint". We don't have to download the add-in separatly and install. just priceless..
Again some tests, if passed just click NEXT
You can give a named instance or leave the default. In my case default.
Again wonderfull, I don't have to create users for my services.. Priceless !
Be sure to set the startup type to "Automatic" for each service (exlude Full Text Filter Daemon Launcher ).
Select Mixed Mode and give a Password for sa account.
Add the Administrator and Farm administrator.
Select Mixed Mode and give a Password for sa account.
Add the Administrator and Farm administrator.
Add the Administrator and Farm administrator. NEXT
Install Reporting Services but do not configure it.
Just NEXT
Some tests, there should be no erros, so NEXT
Ready to Install? so NEXT
Installation progress bar. ( I had to wait 1 hour, hope not you .. )
It will ask to restart your Server, just do it.
Failed to create a database. An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: Could not find stored procedure ‘sp_dboption’.
After a bit of reading I found that SharePoint Server 2010 needs SP1 to be installed before I could configure it with SQL Server 2012. I reached to the Microsoft Knowledge Base article : http://support.microsoft.com/kb/2460045 , downloaded the SharePoint Server 2010 SP1 and executed it.
My Farm is being created.
And as you can see, on Central Administration My content DB is ending with 75d09 and under DENALI Server, you can find the same GUID.
This is meaning that you can use Denali server with SharePoint ONLY if you have SP1