I am installing SharePoint Foundation Server 2010 on a SBS 2008 machine in order to upgrade from WSS 3.0 - SP2) and I am following these detailed instructions:
I’m running into issues at step # 6. Instead of installing SQL Server 2008 SP1, I instead opted to go with SQL Server 2008 R2 – (64bit) in order to have access to a 10GB content database, instead of 4GB. I installed pretty much along these lines:
SQL Server 2008 R2 is now up and running on SBS 2008 and I created an instance called “Express” as directed to do so (using SQL Server Management Studio).
In step 6:(1) I’m not too sure how to:
“Make sure that the new instance of SQL Server 2008 Express is running as a domain account” (??)
In step 6: (2) – I ran the SharePoint Products Preparation tool again and all went well. No errors there.
In step 6: (3) – Installing SharePoint Foundation 2010 in Farm Mode – this is where the issue starts. I specify the Server Name\Database instance name as instructed and put in credentials and then upon clicking OK, I get the following error message:
“The database name located at the specified database server has in incorrect collation. Rebuild the database with the Latin1_General_CI_AS_KS_WS
collation or create a new database using the Latin1_General_CI_AS_KS_WS
I neither know how to rebuild this newly created database, or how to create a new one without the same error appearing again and again. I’ve gone into the SQL Server Studio and have right-clicked and deleted the database and recreated it, but to no avail.
I know virtually nothing about SQL Server – I’m an Access 2007 guy. Any help is greatly appreciated.