I though this had to be an easy task. Well, actually it is. If you find the right documentation and read it in the correct order 🙂
Basically I wanted to be able to login with my AAD (Azure Active Directory) user.
In the first step, the database needs to be configured for Azure Active Directory in order to add users in the second step.
Did you know that the latest SSRS have a build-in support for SharePoint lists as DataSource?
So if you need arguments to update to SQL 2008 R2, this is one 🙂
The RSS Feed Product Index offers a feed with new KB articles for many products.
SharePoint relevant feeds are:
Some SQL feeds:
And Visual Studio
SharePoint and Office are now available via MSDN subscription:
http://msdn.microsoft.com/en-US/subscriptions/subscription-downloads.rss
Update:
Microsoft SharePoint Foundation 2010 (English)
Depending on the configuration of you databases, the log files (*.ldf) can be very large. See Selecting a Recovery Model.
Should I continue reading?
If your databases are configured to use the FULL recovery model, the log files are very large and you need some free space, you can use this SQL script to shrink them. So keep on reading 🙂
The script will change the recovery model for a single database to SIMPLE and shrink the log files. At the end it will restore the recovery model to the setting it has been before.
The SP1 has been released. You can download it here. (Release Notes)
Some changes to make the deployment easier:
In this post I would like to point to “an issue” with the Database Maintenance for Microsoft® SharePoint® Products and Technologies. It shows a stored procedure, which will defragment the index of a database.
How to defragment Windows SharePoint Services 3.0 databases and SharePoint Server 2007 databases
The problem is that it is mentioned nowhere, that the stored procedure requires the Enterprise version of the SQL Server 2005!
In case you missed it (like I did). The SP3 for SQL Server 2005 has been released. You can download it directly from Microsoft.
If you are running an Express version, you have to download an updated SQL Server 2005 Express from here.
Now it is official. Installing SharePoint with a SQL Server 2008 is supported (with the SharePoint Services SP1!)
See SQL Server 2008 Support for SharePoint Products and Technologies.
Enabling remote access for SQL Server 2008 is slightly different from how you were enabling remote access in SQL Server 2005.
In the “Sql Server Configuration Manager” go to “SQL Server Network Configuration” and enable the TCP/IP Protocol.
I wonder where this point will be hidden in the next release of the SQL Server…
Installing the new SQL Server is not very different from installing older version. You have some new options, don’t have to change the media anymore and have some nice wizards.
The SQL Server 2008 requires some components, which will be installed automatically during the setup process.
