Tuesday, September 11, 2007

SQL 2005 collation matters to WSS

So I am reinstalling SQL 2005 on one of my images so I can have my TE edit chapter 15. It's been about eight months since I've had to install and configure SQL and I completely forgot the collation requirements for Sharepoint.

I've got them now, and since I'm here I am going to record them for safekeeping.

WSS needs the collation to be Latin1-general, case insensitive (don't check it), AS, KS, WS.

Keep it in mind. ; )

Oh, and by the way, you need the workstation component to get the system manager, and don't forget to open remote connections with the surface area configuration manager....

No comments: