We are preparing to upgrade our database server from SQL Server 2000 to 2005. I'm planning on doing an in-place upgrade to maintain accounts, privileges, etc., and I'm hoping it will be pretty straightforward. This server hosts databases for several of our applications, but the main one that I'm concerned about is SharePoint (MOSS 2007), since that involves eight databases and seems to be pretty finicky about the connections between the front-end server and the DBs.
Does anyone have practical experience with this scenario? Is this as simple as it should be? Are there any tricks or tips to enlighten me?
Thanks for your help.